1. Engineering
  2. Computer Science
  3. which statement best represents the model shown in the following...

Question: which statement best represents the model shown in the following...

Question details

SALESPERSON Nick Name CUSTOMER CustomerlD LastName FirstName HireDate WageRate CommissionRate Phone Email LastName FirstName Address City State ZIP Phone Fax Email

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.CUSTOMER PURCHASE CustomerlD InvoiceNumber Date PreTaxAmount LastName FirstName Phone Email ITEM PURCHASE ITEM InvoiceNumber ltemNumber ItemNumber Description Cost ArtistName

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

BIRD BirdID BIRD-OBSERVATION BirdID ObservationNumber BirdName Species Gender isBanded BandNumber ObservationDate Location Comments

The BIRD_OBSERVATION entity is a weak entity.

True
False
Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution