James works as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based
computer with Microsoft Office 2010 installed on it. The computer has a database named Accounts
and two tables named Table1 and Table2, which are created in Microsoft Office Access 2010. James
wants to apply referential integrity to establish a relationship between these tables. Which of the
following are required to accomplish the task?
Each correct answer represents a part of the solution. Choose three.
A.
The related fields contain the same format.
B.
Table1 and Table2 are related to the same database.
C.
The common field is the primary key of the primary table.
D.
The related field must have different formats.
Explanation:
The following are required for establishing referential integrity between two tables:
The common field is the primary key of the primary table.
The related fields contain the same format.
Both tables are related to the same database.
Answer D is incorrect. In order to establish referential integrity, it is required that both tables have
the same format.