ER diagram to Tables

Question

Tables needed for ER diagram

Comments

there is a slight change in ER-Diagram

---

that is wrong ( due to the relation in 1:M or 1:M, and the one-side is partial participation, then merging is should be at many side ), the correct answer is,

1. M(M1,M2,M3,P1) which covers R1 and M ------- M1 is the key

2. P(P1,P2)

3. N(N1,N2,P1) which covers R2 and N ------- N1 and P1 is combinely form the key

 

there is a slight change in ER-Diagram

i hope,it is arrows only, No problem this diagram is equivalent to GATE question diagram.

---

They did not mention they needed the min. number of tables and I solved it that way! I think it is worthwhile to look for the min word in the given question.