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

 

Transcribed Image Text:

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

Answer rating: 100% (QA)

Step 1 The Questions are Create a database schema named Assignment2 To create the database name as A View the full answer