Answered step by step
Verified Expert Solution
Question
1 Approved Answer
From looking at this diagram, how would you write this in SQL xml format. We have following entities- 1. Customers 2. Employees 3. Orders 4.
From looking at this diagram, how would you write this in SQL xml format.
We have following entities- 1. Customers 2. Employees 3. Orders 4. OrderLineltems 5. Products 6. Shippers Relationships- Employees "handles" Customers Customers "place" Orders Orders "are shipped by" Shippers Orders have" OrderLineltems OrderLineltems "consist of" Products ShipperNameShipperD Foreign key to Products table A customer can place many orders 1: Many Relationship ProductiD one order can be shipped by many shippers. 1Many One Employee handles many oustomers. 1Many place shipped Quantity An Order can have many Order Line bems. 1 Many Orders Consist ofhave one productiD. 1:1 OrderDate SSN toreign key to Products EoveIFirstame Product iD
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started