MadeEasy

Question

The minimum number of table needed to implement the following 

Answer is 3 thats okk but as its not mentioned normalized or un-normalized can we say 2 also???[i have seen similar  Q in DBMS test 1 in Go and answer was 2]

Comments

Hemanth_13

I have written E1 and E2 by mistake. It will be E1 and E3.

Why we can't merge E1 and E3 ???

---

It's many to one relationship we need two tables and attributes of R2 can be moved to any of E1 and E3.

Relation for E1 has ABCG with A as PK and G as FK refering to G of E3 if we have attributes to R2 can be placed here.

Relation for E3 has GH with G as PK

But if we still want to minimize to two tables I think E1 and E2 can be merged but it will have some redundant data.

---

@Hemanth_13 i.e why i was saying about normalization no mentioned so minimum 2

see this one https://gateoverflow.in/86626/database-systems-1