Write SQL DDL commands to :

Create a database schema named "Assignment2"

Create the tables above (Customer, Invoice, InvoiceEntries) in the database "Assignment2"

Add FKs to map the relationships between the tables

 

Given the following tables (the csv file next to each table contains the text version of the table to save you the typing) Customer Table (customers.csv ) CustId Name 33 47 222 234 invNo CustomerId invDate 2 6 Rianon Bursnall Deck Hearnes Vittorio Anderson Land Tregenna Invoice Table (invoices.csv ) 19 33 33 222 2 2 2 6 19 19 Cust_Email rbursnall 19@homestead.com dhearnesla@g.com vanderson@omniture.com Itregennaic@msu.edu 1 2 3 1 1 2 Casheir subTotal 2020-02-25 John 2021-03-12 Alice 2020-02-25 John InvoicetEntries Table (invoice Entries.csv) InvoiceNumner EntryNo ItemDescription Groceary #2232 Frozen Foods #0232 Meat product #1125 TV Model # 9922 Meat product #1125 Groceary #2232 120.490 9.639 310.000 24.800 57.990 4.639 Tax 8% Unit Price 7.99 18.75 25.00 310.00 25.00 7.99 Total 130.129 334.800 62.629 Quantity 1.00 2.00 3.00 1.00 2.00 1.00