ER MODEL

Question

How to solve this question ?

Comments

Are answers like this?

1) 4

2) 1

3) 12

---

Answers are
1)4
2)5
3)16

---

How 4 minimum tables are required?

---

How 4 minimum tables are required? @Bikram Sir please consider explaining this question ad givig the answer for the same.

Answer 1

I THINK THE ANSWERS ARE 4,5 AND 16 RESPECTIVELY.

i)no. Of minimized rdbms tables=4

E1R1E2R3R2(A,B,C,D,F,E,G).HERE D IS PK.

R4(A,G)HERE AG ARE BOTH PK

E3(G,H)HERE G IS PK

E4(PG,Q,R) HERE PG IS COMBINELY PK

ii)NO. OF FK'S=5

FOR SELF REFERENTIAL ENTITY

R4(G)

R4(A)

E3(G)

E4(G)

iii)NO. OF ATTRIBUTES IN MINIMIZED RDBMS IS 16(SHOWN IN (i) part above )

(Note:one extra for fk in self referential relation)