Database One to One Relationship with example
In Pakistan a person can have only one ID Card. Also, a specific ID card can belong to only one person.
Let’s look at the Person and ID Document example:
In the Person table, the column Person ID will be the Primary Key. In the ID Document table, the ID Number will be the Primary key.