From The ER Diagram, Fill in the blanks: Match A-M to the correct statements: 1)

Question

From The ER Diagram, Fill in the blanks:

Match A-M to the correct statements:

1) ____ Manufacturer entity type
2) ____ Computer Part entity type
3) ____ 'Makes' relationship type
4) ____ Production Date attribute of Makes
5) ____ primary key attribute of Manufacturer will be:
6) ____ primary key attribute of ComputerPart will be:
7) ____ the total participation constraint on the Makes relationship type
8) ____ the key constraint on the Makes relationship type


List of options:
A. becomes a productionDate attribute in Manufacturer
B. becomes a foreign key in Manufacturer that references ComputerPart
C. name
D. is mapped as a relation Makes with attribute productionDate
E. cannot be captured in the relational schema
F. becomes a foreign key in ComputerPart that references Manufacturer
G. is mapped as a relation with attributes Barcode and Price
H. barcode
I. is captured as a NOT NULL constraint on the foreign key
J. makes this relationship a many-to-many relationship which must be mapped as a separate relation
K. id
L. makes this relationship a one-to-many relationship which must be mapped as a foreign key
M. is mapped as a relation with attributes Name and Address
N. becomes a productionDate attribute in ComputerPart

From The ER Diagram, Fill in the blanks: Match A-M to the correct statements: 1) ____ Manufacturer entity type 2) ____ Computer Part entity type 3) ____ 'Makes' relationship type 4) ____ Production Date attribute of Makes 5) ____ primary key attribute of Manufacturer will be: 6) ____ primary key attribute of ComputerPart will be: 7) ____ the total participation constraint on the Makes relationship type 8) ____ the key constraint on the Makes relationship type List of options: A. becomes a productionDate attribute in Manufacturer B. becomes a foreign key in Manufacturer that references ComputerPart C. name D. is mapped as a relation Makes with attribute productionDate E. cannot be captured in the relational schema F. becomes a foreign key in ComputerPart that references Manufacturer G. is mapped as a relation with attributes Barcode and Price H. barcode I. is captured as a NOT NULL constraint on the foreign key J. makes this relationship a many-to-many relationship which must be mapped as a separate relation K. id L. makes this relationship a one-to-many relationship which must be mapped as a foreign key M. is mapped as a relation with attributes Name and Address N. becomes a productionDate attribute in ComputerPart

Explanation / Answer

Match A-M to the correct statements:

1) Manufacturer entity type is mapped as a relation with attributes Name and Address.
2) Computer Part entity type is mapped as a relation with attributes Barcode and Price.
3) 'Makes' relationship type is mapped as a relation Makes with attribute productionDate.
4) Production Date attribute of Makes becomes a productionDate attribute in ComputerPart.
5) Primary key attribute of Manufacturer will be: name.
6) Primary key attribute of ComputerPart will be: barcode.
7) The total participation constraint on the Makes relationship type makes this relationship a               one-to-many relationship which must be mapped as a foreign key
8) The key constraint on the Makes relationship type: becomes a foreign key in Manufacturer that references ComputerPart.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.