A salesperson serves many customers, but each customer is assigned to only one salesperson. A customer can place many orders, but an order can belong to only one customer. An order contains many products. A product may also appear on many orders.
Identify the steps you will take to create an Entity Relationship Diagram (ERD) for the above scenario. [10]
Note: Even though you are not required to submit the ERD, you may benefit from creating the ERD on paper before before answering this question.
Select all options that apply. 1 mark will be deducted for each incorrect choice.

Question

A salesperson serves many customers, but each customer is assigned to only one salesperson. A customer can place many orders, but an order can belong to only one customer. An order contains many products. A product may also appear on many orders. 
 Identify the steps you will take to create an Entity Relationship Diagram (ERD) for the above scenario.  [10] 
 Note: Even though you are not required to submit the ERD, you may benefit from creating the ERD on paper before before answering this question. 
 Select all options that apply. 1 mark will be deducted for each incorrect choice.

Accepted Answer

Create a one-to-many (1:M) relationship between  Salesperson  and  Customer

Accepted Answer

Create a bridge entity between  Order  and  Product  and name it  ProductOrder

Accepted Answer

Create a one-to-many (1:M) relationship between  Customer  and  Order

Accepted Answer

Add the primary key of  Customer  as a foreign key in  Order

Accepted Answer

Add the primary key of  Salesperson  as a foreign key in  Customer

Accepted Answer

Create the entities  Salesperson ,  Customer ,  Order  and  Product

Answer

The primary keys of  Order  and  Product  together become composite key for the bridge entity named  ProductOrder

Answer

Create a many-to-many (M:N) relationship between  Customer  and  Order

Answer

Add the primary key of  Customer  as a foreign key in  Salesperson

Answer

Identify other additional attributes and add them to their corresponding entities as necessary to complete the ERD

Answer

Create one-to-many (1:M) relationships linking  Product  and  Order  to the bridge entity  ProductOrder

Answer

Create one-to-many (1:M) relationships linking  Customer  and  Order   to the bridge entity  CustomerOrder

Answer

Add the primary key of  Order  as a foreign key in  Customer

Answer

Add the primary key of  Order  as a foreign key in  Product

Answer

Add the primary keys of  Customer  and  Order   as foreign keys in the bridge entity named  CustomerOrder

Answer

Create a bridge entity between  Customer  and  Order  and name it  CustomerOrder

Answer

The primary keys of  Customer  and  Order  together become composite key for the bridge entity named  CustomerOrder

Answer

Add the primary keys of  Order  and  Product  as foreign keys in the bridge entity named  ProductOrder

Answer

Create a one-to-one (1:1) relationship between  Salesperson  and  Customer

Crowdly

A salesperson serves many customers, but each customer is assigned to only one s...

Want instant access to all verified answers on connect.belgiumcampus.ac.za?