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.
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 articles where credibility was 2 or the year is less than 2016.
Write a query to test for three things in an AND relationship
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 have an opinion of 1 and either were published in 2016 or were published in 2014. (You can change the years to meet your data but the years must have a gap between them).
Query for all articles where your opinion is a 2 and the credibility is 2 OR the year is 2014 (year 2014 is enough to show the article).
Query for all articles where your opinion of the article is a 1 and where either of two other conditions is true.