Multiple Choice
To create a 1:1 relationship between two tables in Microsoft Access ________.
A) the Indexed property of the foreign key column must be set to No
B) the Indexed property of the foreign key column must be set to Yes (Duplicates OK)
C) the Indexed property of the foreign key column must be set to Yes (No Duplicates)
D) the Data Type of the foreign key column must be set to AutoNumber
E) the Smart Tag property of the foreign key column must be set to Foreign Key
Correct Answer:

Verified
Correct Answer:
Verified
Q24: The identifier of the entity becomes the
Q40: What is denormalization and why can it
Q41: The ideal primary key is short,numeric,and nonchanging.
Q42: Explain the representation of ID-dependent weak entities
Q43: Given the tables<br><b>PRODUCT (<u>ProductID</u>,Description,Cost)</b><br><b>SUPPLIER (<u>SupplierID</u>,ContactName,PhoneNumber)</b><br>As shown in
Q44: The key for an intersection table is
Q46: As far as Microsoft Access is concerned,there
Q48: An example of a join in SQL
Q49: To create a 1:1 relationship between two
Q50: Explain the process of representing an entity