Suppose you have a small retail store and decide to create a database to track sales.

computer science

Description

Database Design

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


Related Questions in computer science category


Disclaimer
The ready solutions purchased from Library are already used solutions. Please do not submit them directly as it may lead to plagiarism. Once paid, the solution file download link will be sent to your provided email. Please either use them for learning purpose or re-write them in your own language. In case if you haven't get the email, do let us know via chat support.