One-to-One Cardinality

One to One Cardinality has two possible cases where we have the case of either total participation or no participation at one end.

There are two possibilities

Total Participation at One End

For example, consider the below ER diagram. 

One to One

A1 and B1 are the primary keys of E1 and E2 respectively. In the above diagram, we have total participation at the E1 ends. Only a single table is required in this case having the primary key of E2 as its primary key. Since E2 is in partial participation, atleast one entry in E2 does not participate in relationship set, but all entries in E1 are related to an entry in E2. Therefore E2 cannot be null for any value of E1, but E1 will be null for atleast one value of E2.

Note: Only 1 table is required.

No Participation at One End

One to One

A1 and B1 are the primary keys of E1 and E2 respectively. 

The primary key of R can be A1 or B1, but we can’t still combine all three tables into one. if we do so, some entries in the combined table may have NULL entries. So the idea of merging all three tables into one is not good. But we can merge R into E1 or E2. So a minimum of 2 tables is required.

Minimization of ER Diagrams

Pre-Requisite: ER Diagram

Entity-Relationship (ER) Diagram is a diagrammatic representation of data in databases, it shows how data is related to one another. In this article, we require previous knowledge of ER diagrams and how to draw ER diagrams.

Minimization of ER Diagram simply means reducing the quantity of the tables in the ER Diagram. When there are so many tables present in the ER DIagram, it decreases the readability and understandability of the ER Diagram, and it also becomes difficult for the admin also to understand these. Minimizing the ER Diagram helps in better understanding. We reduce tables depending on the cardinality.

Similar Reads

Cardinality

Cardinality means that what is the number of relationships between the two entity sets in any relationship model. There are four types of cardinality which are mentioned below....

Many-to-One Cardinality

For example, a student can be enrolled only in one course, but a course can be enrolled by many students....

Many to Many Cardinality

Let us consider the above example with the change that now a student can enroll in more than 1 course....

One-to-One Cardinality

One to One Cardinality has two possible cases where we have the case of either total participation or no participation at one end....

FAQs

1. What is an ER Diagram?...

Contact Us