Access Design and SQL Project:
There are three parts to this project:
- Search the web to find the information you will need to populate the
database.
- Develop and populate a database table using data appropriate for the
queries you need to make.
- Query the database using SQL.
First, you will need to search the web and find 10 articles that talk about
the term "soft skills" (i.e. what they are and the value that business
places on them). The information about these articles is what you are going
to store on the database table that you are creating. Be sure to check the
queries before entering the data so you know what you need to have in the
database (i.e. fields, properties, etc.) in order to run accuratly populated
queries.
You need to design and setup a table within a database to
hold the information about the articles (be sure to check the queries below
to help you decide about what data to use):
- Each record should have a 5 digit unique identifying number (you
decide on what numbers to use)
- Name of the article
- Web address (URL) of the article
- Publication or web site where it appears (i.e. USA Today, WIRED,
etc.)
- A code from 1 to 3 where you rank the credibility of the web site.
If you recognize the site and find it credible give it a 1, if you are
not sure about the credibility give it a 2, if you think the site is
unreliable give it a 3. You should have some variety in your codes so
you can effectively query the table.
- Primary author of the site (first author listed)
- Your opinion of the article. Rank the article from 1 to 5 based on
whether you found the article provided a good explanation of what soft
skills are and the value that business place on these skills. You should
have some variety in your codes so you can effectively query the table.
- Where the article originated. NoAm, Europe, SoAm, Asia, Africa,
Australia, Unknown. Again you need some variety so you can query
effectively.
- Year of publication
Queries: The following queries must be written using SQL.
When you write the SQL copy and paste it into a text document that you send
me along with the database. Sometimes when you go back and forth, the code
you wrote gets altered. I want to see the original query you wrote. I do not
want to see Microsoft generated queries.
- Query for all articles where your opinion was a 1 or a 2.
- Query for all articles that have a creditbility of 2 and year of
publication > 2015. (you can change the date to fit your data).
- Query for all articles that have a credibility of 2 or a year of
publication > 2015. (you can change the data to fit your data).
- Query for all articles where your opinion of the article is a 1 and
where either of two other conditions is true.
- Query for all articles where you gave a credibility of 1 and an
opinion of 1 OR where you gave a credibility of 2 and an opinion of 2.
- Query for all articles that were published in 2019 and either have a
credibility of 1 or an opinion of 1.
- Query for all articles that you gave an opinion of 2 and were either
published in 2019 or 2020. (You can change the years if you need to).
- Query for all articles that originated in NoAm and have a year of
publication > 2017 and the opinion is > 3 or originated in Asia and have
a year of publication <=2020.
If you have problems with the interpretation of one of these let me know in
the email and I will let you know if I was looking for a different
interpretation.