Question

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

Answer 1

ANSWER:

1)i. The relationship is a degree of 2 ( i.e Binary). The cardinality of the relationship is One-to-Many.

ii. The model is from piano description to piano manufacturer.

PIANO:

Model name

Model number

Serial number

Manufacturing completion date

MANUFACTURER:

Ebony and Ivory

2)i. The relationship is a degree of 2 ( i.e Binary). The cardinality of the relationship is Many-to-Many.

ii. The model is from piano description to Technician.

PIANO:

Model name

Model number

Serial number

Manufacturing completion date

TECHNICIAN

Employee number

Specialty

3)i. The relationship is a degree of 2 (i.e Binary). The cardinality of the relationship is Many-to-One.

ii. The model is from Technician to Technician

TECHNICIAN:

Lower rank

TECHNICIAN:

Higher rank