/* SQL Server Data Definition Script */
/* Database Table Creation Begins Here */
Use Demo_Database

Create Table Customer
(
     Customer_ID Int Not Null,
     Last_Name Char (20) Not Null,
     First_Name Char (20) Not Null,
     Street Char (20) Not Null,
     City Char (20) Not Null,
     State Char (20) Not Null,
)
Go

Create Table Order_Invoice
(
     Order_Id Int Not Null,
     Order_Date Datetime Not Null,
     Customer_ID Int Not Null,
)
Go

Create Table Order_Invoice_Items
(
     Order_ID Int Not Null,
     Item_ID Int Not Null,
     Quantity Int Not Null,
)
Go