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

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.Diagram A salesperson must have customers assigned to them and a customer

PURCHASE PURCHASE _ITEM

CUSTOMER PURCHASE

ITEM PURCHASE_ITEM

CUSTOMER ITEM

1.

1:M, Mandatory-Optional

2.

No relationship

3.

1:M, Mandatory-Mandatory

4.

1:1, Mandatory-Optional

Saved

has to be assigned to a salesperson. A salesperson must have customers

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!