Question

For each of the descriptions below, perform the following tasks:

Answer 1

Answer:

attached below in the explanation and the diagrams attached

Explanation:

question

i) identify the degree and cardinality of the relationship

ii) Express the entities and the relationships with attributes in each description graphically with an E-R diagram

A)

i) The degree and cardinality of the relationship

• The entities PIANO, MODEL and DESIGNER have a degree of two i.e. Binary relationship
• The cardinality of the entities PIANO, MODEL and DESIGNER have a relationship of ONE-to-many

ii) description graphically with an E-R diagram

The E-R diagrams show that  The degree of the relationship for the entities PIANO, MODEL, and DESIGNER is two(2).  and also shows that there is a One-to-Many cardinality available in the entities PIANO, MODEL, and DESIGNER

E-R diagram Attached below

B)  

i) The degree and cardinality of the relationship

• entities PIANO and Technician have a degree of two ( 2 ) ; i.e. a Binary relationship
•  The cardinality of the entities PIANO, and TECHNICIAN have  a relationship of Many-to-Many.

ii) Graphical description with an E-R diagram

The diagram describes/ shows that, entities PIANO and Technician have a degree of two ( 2 ) ; i.e. a Binary relationship and also The cardinality of the entities PIANO, and TECHNICIAN have  a relationship of Many-to-Many.

E-R diagram attached below

C)

i) Degree and cardinality of the entity Technician

•  The entity TECHNICIAN has a degree one, i.e.  a unary relationship.

• The cardinality of the entity TECHNICIAN have the relationship of  One-to-Many.

ii) E-R diagram attached below

D)

i) Degree and cardinality of the relationship

• The entities TABLET TYPE and PROCESSOR TYPE have a degree of two(2) , i.e. a binary relationship

• The cardinality these entities TABLET TYPE, and PROCESSOR TYPE have is a Many-to-Many relationship

ii) E-R diagram attached for TABLET TYPE, PROCESSOR TYPE is attached below

E)

i) Degree and cardinality of the relationship

• The entities TABLET TYPE, TABLET COMPUTER, and CUSTOMER have a degree of two(2) ; i.e. a binary relationship.

• The cardinality these entities TABLET TYPE, TABLET COMPUTER, and CUSTOMER have is a   One-to-Many relationship

also  the shipment to the customer is multiple hence the relationship can be said to be  Many-to-Many relationship

also The attribute Shipping Date will become an attribute of that M: M relationship.

ii) The E-R diagram for TABLET TYPE, TABLET COMPUTER, CUSTOMER  is attached below

F)

i) Degree and cardinality of the relationship  between TABLET TYPE, TECHNICIAN

• The entities TABLET TYPE, and TECHNICIAN have a degree of two(2); i.e.  a binary relationship.

•  The cardinality these entities TABLET TYPE, and TECHNICIAN have is a Many-to-Many relationship

ii) E-R diagram attached below