Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Basics Computer EngineeringInformation Warehouse Basics From Science

Authors: Odiljon Jakbarov ,Anvarkhan Majidov

1st Edition

620675183X, 978-6206751830

More Books

Students also viewed these Databases questions

Question

Evaluate 3x - x for x = -2 Answer:

Answered: 1 week ago

Question

What is group replacement? Explain with an example. (2-3 lines)

Answered: 1 week ago