In a 1:1 relationship,the foreign key is defined as an alternate key to make the DBMS enforce uniqueness.

Question

Quizplus · Accepted Answer

In a 1:1 relationship, the foreign key is defined as an alternate key to ensure that each entity on either side of the relationship has a unique mate on the other side. This is done to enforce the one-to-one relationship and prevent any duplication or overlap of data. Therefore, the foreign key is also used to maintain referential integrity and ensure that no invalid data is inserted into the database.

In a 1:1 Relationship,the Foreign Key Is Defined as an Alternate