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
Q4: Which of the following is true when
Q9: By default,Microsoft Access creates 1:1 relationships between
Q13: As far as Microsoft Access is concerned,there
Q26: The key for an intersection relation is
Q43: All recursive relationships are 1:1.
Q62: In a relational database design,all relationships are
Q67: Which of the following is not true
Q70: The ideal primary key is _.
A)short
B)numeric
C)fixed
D)A and
Q73: The first step in transforming an extended
Q75: A surrogate key should be considered when
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents