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
	Email	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