database doubt

Question

if two entities A and B are connected using total participation with relation R then minimum number of tables required in relational model is?

Answer 1

If both entities have total participation then one table is sufficient..

Comments

if cardinality is m:n with total participation then also u need 1 table only?

---

No.. that's for 1:1 cardinality .. for m:n cardinality would require two separate table for entities but no table for relationship... am I correct?

---

I think We should keep all tables ..separately.

---

@kriti singh

@Debashish has done right..we'll need 3 tables for m:n....2 or entities and 1 for relationship...doesnt matter u have total participation or partial!!

---

@Debashis,..very nice (y).. now.. can you please convert your comment to ans ??

---

have to show all cases !! leave it !! ..comments ...above ans + below answer ..would be ok for now ! ..later I will provide Or someone will provide explanation for all.

---

If relationship is 1:1  and total participation exists only on one side , then can we merge both tables ?

---

^no....

---

@User007

If relationship is 1:1 then for total participation on either one side or both sides we can merge the tables