Question: Which statement best represents the model shown in the following ER Diagram A salesperson must have customers assigned to them and a customer has to

Which statement best represents the model shown in the following ER Diagram
| A salesperson must have customers assigned to them and a customer has to be assigned to a salesperson. | |
| A salesperson must have customers assigned to them but a customer does not need to be assigned to a salesperson. | |
| A salesperson may or may not have customers assigned to them and a customer may or may not be assigned to a salesperson. | |
| A salesperson may have many or no customers assigned to them. A customer must be assigned to a salesperson. |
Match the following relationships to those depicted in the ER Diagram displayed.
| |
| PURCHASE PURCHASE _ITEM |
| CUSTOMER PURCHASE |
| ITEM PURCHASE_ITEM |
|
|
Saved

The BIRD_OBSERVATION entity is a weak entity.
| True | |
| False |
SALESPERSON Nick Name CUSTOMER CustomerlD LastName FirstName HireDate WageRate CommissionRate Phone Email LastName FirstName Address City State ZIP Phone Fax Email CUSTOMER PURCHASE CustomerlD InvoiceNumber Date PreTaxAmount LastName FirstName Phone Email ITEM PURCHASE ITEM InvoiceNumber ltemNumber ItemNumber Description Cost ArtistName BIRD BirdID BIRD-OBSERVATION BirdID ObservationNumber BirdName Species Gender isBanded BandNumber ObservationDate Location Comments SALESPERSON Nick Name CUSTOMER CustomerlD LastName FirstName HireDate WageRate CommissionRate Phone Email LastName FirstName Address City State ZIP Phone Fax Email CUSTOMER PURCHASE CustomerlD InvoiceNumber Date PreTaxAmount LastName FirstName Phone Email ITEM PURCHASE ITEM InvoiceNumber ltemNumber ItemNumber Description Cost ArtistName BIRD BirdID BIRD-OBSERVATION BirdID ObservationNumber BirdName Species Gender isBanded BandNumber ObservationDate Location Comments
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
