The Community College of Baltimore County Design a Store Database MySQL Task

Complete the SQL Basics Tutorial through “Project: Design a store database“.

Why?

This will give you a good introduction to the SQL language and walk you through the basics to help build a foundation.

Procedure

1. Click here to access the SQL Basics Tutorial
2. Complete all the sections, they include:
   1. Welcome to SQL
   2. Creating a table and inserting data
   3. Challenge: Book list database
   4. Querying the table
   5. Challenge: Box office hits database
   6. Aggregating data
   7. Challenge: TODO list database stats
   8. S-Q-L or SEQUEL?
   9. Project: Design a store database
3. Once you finish the “Design a Store Database” take several screenshots of your work and compile into one document (docx, pdf). Attach it to this assignment. (20 points)

Here’s a screenshot of my work as an example – note: the solution isn’t 100% correct on purpose. I’m nice but I’m not that nice. 🙂