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 need to search the web and find 10 articles that talk about soft skills: 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 to answer the queries.
You need to design and setup a database 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 to retrieve the article
Publication or web site where it appears
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. If you need to change from testing for 1 or 2 to testing for 3 or 4 etc, that is fine – just let me know!
Query for all articles where your opinion was a 1 or a 2.
Test for two things in an and relationship.
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 2015 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 2014 or 2015. (You can change the years if you need to).