What is One-to-One Relationship?

A one-to-one Relationship in a Relational Database occurs when one figure report or subject has both 0 or one infant File simplest. These Relationships are the easiest to represent in Databases due to the fact both the figure and baby Records can be within the equal desk.

What Does One-to-One Relationship Mean?

As an Instance, inside the CUSTOMER_MASTER Table in a financial institution’s Database, each patron is represented by a unique CUSTOMER_ID, which is also the desk’s Primary Key. Each Client can also have a government issued social security card, which includes a unique social safety wide Variety. Therefore, each client have to have a unmarried purchaser ID inside the financial institution’s database. If a patron does have one, then there can only be one social safety number in keePing with customer.

The discern subject (CUSTOMER_ID) has a one-to-one dating with the social security subject. For such relationships, it is first-rate to place them into one table for ease of reference. In this case, the social protection Range must honestly be a further column inside the CUSTOMER_MASTER table.