made_easy

Question

Comments

made easy gave the solution as 5 tables are needed.

They merged E1 table along with R1 and made it a single table. But since it is 1:M relationship with partial participation on both sides, so minimum two tables are required.

Where am i going wrong?Pls help!

---

@Shaik can u pls check this question?

---

isn't that is self recursive entity ?

---

yes..

---

then we can represent with 1 table it self,

E(A,B,C,A) ---> A is a foreign key, ==> E is both parent table and child table.

But there is some restriction " First insert the row which have a NULL in the Foreign Key ", then you can easily insert the remaining rows

---

Shaik Masthan

ya..got my mistake..thanks :)