Write SQL DDL commands to : Create a database schema named Assignment2 Create the tables
Fantastic news! We've Found the answer you've been seeking!
Question:
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 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
Expert Answer:
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
Related Book For
Posted Date:
Students also viewed these databases questions
-
Chapters, a bookseller, had the following transactions during the month of July 2 0 2 2 and uses the perpetual inventory system. Date Transaction Purchases Sales Balance Quantity Cost Quantity Cost...
-
Question 3 Consider a medical match problem with three hospitals, h1, h2 and h3, and four doctors d1, d2, d3 and d4. The capacities are 9h = 2 and 9h3 1, 9h2 = 1. The preferences = are given by the...
-
Mr Ha is interested in setting up a coffee shop in Canberra, Australia. After consulting with his brother who owns a caf in other town of the territory, he has decided to commence the business in...
-
In Exercises 13 through 24, compute the derivative of the given function and find the equation of the line that is tangent to its graph for the specified value x = c. f(x) = -2 X ; c = - 1
-
Determine by direct integration the moment of inertia of the shaded area with respect to the x axis. b
-
Castillo Nutrition Company has 14,000 shares of cumulative preferred 1% stock, $130 par, and 70,000 shares of $5 par common stock. The following amounts were distributed as dividends: Year 1...
-
Consider the electronic inverter data in Table B.14. Delete the second observation in the data set. Split the remaining observations into prediction and estimation data sets. a. Find the minimum...
-
Polly, Molly, and Dolly are all single mothers. They each can earn $10 per hour working for up to 2,000 hours per year. Their government runs a welfare system that gives income benefits of $5,000 per...
-
Supervision of the Audit Engagement Of the standard, paragraph . 0 6 states the engagement partner and other engagement team members performing supervisory activities should take into account: State...
-
After a complaint was filed against him, Broker Ike was found guilty of a license law violation. He was fined and had to pay legal fees totaling $8,900. This was paid by the Recovery Fund. What else...
-
An increase in the initial stock of knowledge: Suppose we have two economies- let's call them Earth and Mars-that are identical, except that one begins with a stock of ideas that is twice as large as...
-
Smithson Co. provides scientific services to a wide range of clients. Typical assignments range from testing food for illegal addicts to providing forensic analysis on items used to commit crimes to...
-
Basic CVP Concepts Becca's Bakery sells cupcakes at $3.15 apiece. The variable cost per cupcake is $1.10. The fixed costs are $12,500 per month. Calculate the unit contribution margin if unit...
-
Amidst the evolving landscape of global finance, what are the emerging trends and challenges pertaining to cross-border insolvency regimes, including the harmonization of legal frameworks,...
-
Hindustan Petroleum Corporation Ltd. - Driving Change Through Internal Communication. Write SWOT Analysis and PESTLE.
-
Find current lo 2 A 110 A www 10 => www 4 A
-
Define Isobars
-
Huntingdon Capital Corp. is a competitor of Plazacorp and First Capital Realty. Huntingdon reported the following selected information (in millions):...
-
Write SQL statements to insert data into the PetWeight column you created in question 3.47. Use the PetWeight from the PET_3 table. PET_OWNER ( OwnerID , OwnerLastName, OwnerFirstName, OwnerPhone,...
-
What is Oracle Database Express Edition 11g Release 2?
-
As illustrated in Figure K-5, what is column family database storage and how are such systems organized? How do column family database storage systems compare to RDBMS systems?
-
When the Glen Canyon hydroelectric power plant in Arizona is running at capacity, 690 m 3 of water flows through the dam each second. The water is released 220 m below the top of the reservoir. If...
-
A pronghorn, the fastest North American animal, is capable of running at 18 m/s (40 mph) for 10 minutes, after which it must slow down. The time limit isnt because the pronghorn runs out of energy;...
-
When the hoof of a galloping horse hits the ground, the digital flexor tendon in its lower leg may stretch by 5% in length, a significant stretch for this 45 cm tendon. The tendon is elastic; mostbut...
Study smarter with the SolutionInn App