ER Model to Table conversion

Question

What is the minimum number of tables for a BINARY RELATIONSHIP WITH ATTRIBUTES for the follwoing cases:

Case 1: One-to-One relationship between two entities and partial participation from both sides

Case 2: One-to-One relationship between two entities and partial participation from one side and total partici[ation from the other side

Case 3: One-to-One relationship between two entities and total participation from both sides

Case 4: One-to-Many relationship between two entities and partial participation from both sides

Case 5: One-to-Many relationship between two entities and partial participation from One's sides and total participation from Many's side

Case 6: One-to-Many relationship between two entities and total participation from One's sides and partial participation from Many's side

Case 7: One-to-Many relationship between two entities and total participation from both sides

Case 8: Many-to-Many relationship between two entities and partial participation from both sides

Case 9: Many-to-Many relationship between two entities and total participation from one sides and total participation from the other side

Case 10: Many-to-Many relationship between two entities and total participation from both sides

Also explain why that number of minimum number of tables are needed in each case and in which table we will put the attributes of the relationship

Comments

https://gateoverflow.in/blog/16592/minimum-number-of-tables-required-to-represent-er-diagram

---

do the same rules apply when the relationship itself has attributes along with the entities? or do we need an extra table for the relationship when the relationship has attributes

---

That question will be answered by yourself after reading and understanding of the blog content.

Answer 1