You have been hired by a small retail outlet store in your community to help them build
Fantastic news! We've Found the answer you've been seeking!
Question:
You have been hired by a small retail outlet store in your community to help them build a small database that will help them track customers, products and orders placed. This database will have three tables, and your task noted below is to write the code needed to generate the tables as designed.
Given the requirements for a database in the chart below, construct the SQL code needed to create each table. You can use this site to create and validate your code:
- Ensure you correctly identify the primary key fields in your code that are required to create the tables.
- Provide clear comments in the code.
- Discuss the fields you will use to join these tables together to make the database relational.
When you have completed this assignment, copy and paste your code into a Word document along with your response to the question and submit it for review. This assignment will be assessed by your instructor using the Building a Database Rubric.
Table Name | Field | Data Type | Required? |
---|---|---|---|
Customers | CustomerID | Integer | Y |
FirstName | Variable Character | Y | |
LastName | Variable Character | Y | |
Address1 | Variable Character | Y | |
Address2 | Variable Character | N | |
CustCity | Variable Character | Y | |
CustState | Character | Y | |
CustZipCode | Character | Y | |
Variable Character | N | ||
AccountCreated | DateTime | Y | |
Orders | OrderID | Integer | Y |
OrderDate | DateTime | Y | |
OrderItemName | Variable Character | Y | |
OrderQuantity | Integer | Y | |
ProductID | Integer | Y | |
Products | ProductID | Integer | Y |
ProductName | Variable Character | Y | |
ProductDesc | Variable Character | Y | |
ProdManfacName | Variable Character | Y |
Related Book For
Posted Date: