Suppose you have a small retail store and decide to create a database to track sales. You have information about recent sales that you want to use for testing the database. In this Assigmment, you will use the data from the Week 2 Assignment to create a database.
To complete this Assignment:
1. Create the tables for the data provided in the Assignment Data Table, located in the Learning Resources. The tables should include the primary and foreign keys. Provide the SQL statements. (35 points)
2. Insert the data into the tables. Provide the SQL statements. (20 points)
3. Show the contents of each table. Provide the SQL statements. (20 points)
Note: Insert your name and your instructor’s name in the of the table. When you show the content of each table, you will have to provide evidence via screenshots, including your name and your instructor’s name! Cheryl Waters Instructor
Wayne Reu student
Use MySQL or MS SQL express