Question: 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
Get step-by-step solutions from verified subject matter experts
