Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

( a ) Draw a logical level ER diagram based on the following scenario. Indicate clearly any assumptions that you make. ( 1 5 Marks

(a) Draw a logical level ER diagram based on the following scenario. Indicate
clearly any assumptions that you make.
(15 Marks)
A salesperson can be an agent for many customers. A customer is managed by
one salesperson. A customer can place many orders. An order can be placed by
one customer. An order lists many inventory items. An inventory item may be
listed on many orders. An inventory item is assembled from many parts. A part
may be assembled into many inventory items. Many employees assemble an
inventory item from many parts. A supplier supplies many parts. A part may be
supplied by many suppliers.
b) Convert this ERD into Relational Model.
(15 Marks)
image text in transcribed

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

Marketing Database Analytics

Authors: Andrew D. Banasiewicz

1st Edition

0415657881, 978-0415657884

More Books

Students also viewed these Databases questions

Question

What lessons in OD contracting does this case represent?

Answered: 1 week ago

Question

Does the code suggest how long data is kept and who has access?

Answered: 1 week ago