Multiple Choice
Given the tables
TABLE_A (Attribute1,Attribute2,Attribute3)
TABLE_B (Attribute4,Attribute5,Attribute6)
As shown in the figure below,which of the following would display the correct placement of foreign keys in the relational model?
A) TABLE_A (Attribute1, Attribute2, Attribute3) TABLE _B (Attribute4, Attribute5, Attribute6, Attribute1)
B) TABLE _A (Attribute1, Attribute2, Attribute3, Attribute4, Attribute5) TABLE _B (Attribute4, Attribute5, Attribute6)
C) TABLE _A (Attribute1, Attribute2, Attribute3, Attribute4) TABLE _B (Attribute4, Attribute5, Attribute6, Attribute1)
D) TABLE _A (Attribute1, Attribute2, Attribute3) TABLE _B (Attribute4, Attribute5, Attribute6)
E) TABLE _A (Attribute1, Attribute2, Attribute3, Attribute6) TABLE _B (Attribute4, Attribute5, Attribute6)
Correct Answer:
Verified
Correct Answer:
Verified
Q25: From a pragmatic standpoint,the only important rule
Q26: In relational database design,ID-dependent entities are used
Q27: Recursive relationships can be represented in the
Q28: Which of the following would be a
Q29: To represent a 1:N relationship in the
Q32: Given the tables<br><b>PRODUCT (<u>ProductID</u>,Description,Cost)<br>SUPPLIER (<u>SupplierID</u>,ContactName,PhoneNumber)</b><br>As shown in
Q33: Write the schema to represent the entities
Q35: As far as Microsoft Access is concerned,there
Q50: How are one-to-one recursive relationships addressed using
Q87: Explain the representation of a many-to-many strong