Scribd
Upload
675 views1 page

ERD Example: Question: Draw The Entity-Relationship Diagram (ERD) For The Following Scenario

A 3 sentence summary of the ERD document is: The ERD models the relationships between salespeople who can manage other salespeople but are managed by only one, customers who place orders that list inventory items assembled from parts supplied by suppliers, and employees who assemble inventory items from multiple parts. Salespeople are agents for customers who place orders containing inventory items assembled from parts supplied by multiple suppliers.

Uploaded by

mah moud
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
675 views1 page

ERD Example: Question: Draw The Entity-Relationship Diagram (ERD) For The Following Scenario

A 3 sentence summary of the ERD document is: The ERD models the relationships between salespeople who can manage other salespeople but are managed by only one, customers who place orders that list inventory items assembled from parts supplied by suppliers, and employees who assemble inventory items from multiple parts. Salespeople are agents for customers who place orders containing inventory items assembled from parts supplied by multiple suppliers.

Uploaded by

mah moud
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

ERD Example

Question: Draw the Entity- Relationship Diagram (ERD) for the following scenario:

A salesperson may manage many other salespeople. A salesperson is managed by only


one salespeople. A salesperson can be an agent for many customers.

A customer is managed by one salespeople. 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.

Answer:

You might also like