Question

Create a new relationship between the StaffID field in the Staff table and the Reviewer field in the Reviews table. Enforce data integrity between the two tables.

a. Database Tools>Relationships>Drag StaffID to Reviewer>Click checkbox for Enforce Referential Integrity>Create.
b. Data>Link Tables>Connect StaffID to Reviewer>Enable Data Integrity>Apply.
c. Table Design>Define Relationship>Link StaffID to Reviewer>Tick Enforce Data Integrity>Save.
d. Query Builder>Create Relationship>Associate StaffID with Reviewer>Enforce Integrity>Finish.

Answer 1

To create a new relationship between the StaffID field in the Staff table and the Reviewer field in the Reviews table, you should select option a - Database Tools>Relationships>Drag StaffID to Reviewer>Click checkbox for Enforce Referential Integrity>Create.

Correct option is a. Database Tools>Relationships>Drag StaffID to Reviewer>Click checkbox for Enforce Referential Integrity>Create.

Step-by-step explanation:

The correct option to create a new relationship between the StaffID field in the Staff table and the Reviewer field in the Reviews table is option a. Database Tools>Relationships>Drag StaffID to Reviewer>Click checkbox for Enforce Referential Integrity>Create.

Enforcing referential integrity means that any value entered in the Reviews table for the Reviewer field must already exist in the Staff table for the StaffID field. This ensures that the relationship between the two tables is maintained and prevents any orphaned records.

For example, if a StaffID of 123 does not exist in the Staff table and a Reviewer field in the Reviews table is set to 123, the referential integrity constraint will prevent this record from being saved.