Using the tables provided below relating to customer and salespersons:

(a) Prepare entity-relationship diagrams to model the relationships between sales person and customer as one-to-one (1:1), one-to-many (1:N) and many-to-many

(N:M).

(b) Discuss and provide relationship sentences for each of the models.

(c) Implement the relationships on the entity-relationship diagram with primary and foreign keys.

(d) Which relationship between salesperson and customer do you think would be the most common for a business to have? Give reasons why.

Transcribed Image Text:

Salesperson ID Last Name Table: Salesperson First Name Address Telephone Table: Customer Customer ID Last Name First Name Telephone