database managment

3) Consider the following binary relationships:

Buys

Cust

Car

Sam

Mustang

Sam

Cobra

Jenn

Mustang

Jenn

Cobra

Buys from

Cust

SP

Sam

Don

Sam

Sharon

Jenn

Sharon

Sells

SP

Car

Don

Cobra

Don

Mustang

Sharon

Cobra

Sharon

Mustang

These relationships involve customers (), salespersons (), and cars(). What information, if any, can you get from these relationships about who sold Sam a Cobra?

Answer:

If it is not possible to determine who sold Sam the Cobra, show a possible ER diagram that would be able to answer this question without ambiguity. Populate the table(s) with some representative data.