Answered step by step
Verified Expert Solution
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.
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.
Marks
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