Access Design and SQL Project:

There are three parts to this project:
  1. Search the web to find the information you will need to populate the database.
  2. Develop and populate a database table using data appropriate for the queries you need to make.
  3. 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):
  1. Each record should have a 5 digit unique identifying number (you decide on what numbers to use)
  2. Name of the article
  3. Web address (URL) of the article
  4. Publication or web site where it appears (i.e. USA Today, WIRED, etc.)
  5. 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.
  6. Primary author of the site (first author listed)
  7. 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.
  8. Where the article originated. NoAm, Europe, SoAm, Asia, Africa, Australia, Unknown. Again you need some variety so you can query effectively.
  9. 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.
  1. Query for all articles where your opinion was a 1 or a 2.
  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).
  3. 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).
  4. Query for all articles where your opinion of the article is a 1 and where either of two other conditions is true.
  5. 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.
  6. Query for all articles that were published in 2019 and either have a credibility of 1 or an opinion of 1.
  7. 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).
  8. 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.