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
Q1: Given the tables PRODUCT (ProductID,Description,Cost)<br>SUPPLIER (SupplierID,ContactName,PhoneNumber)<br>As shown
Q9: The ideal primary key is short,numeric,and fixed.
Q26: In relational database design,ID-dependent entities are used
Q37: An entity needs to be examined according
Q55: Which of the following is the correct
Q56: By default,when Microsoft Access creates a relationship
Q59: In certain circumstances,there may be a preference
Q68: Microsoft Access does not create N:M relationships
Q73: The first step of database design is
Q90: The ideal primary key is _.<br>A)short<br>B)numeric<br>C)fixed<br>D)A and