0 0 votes 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] Databases + – Abhisek Tiwari 4 1.2k views answer comment Share Follow Print See all 8 Comments 8 8 Comments reply Show 5 previous comments kumar.dilip commented Dec 2, 2018 reply Follow flag Hemanth_13 I have written E1 and E2 by mistake. It will be E1 and E3. Why we can't merge E1 and E3 ??? 0 0 replyShare Hemanth_13 commented Dec 2, 2018 reply Follow flag 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. 0 0 replyShare Abhisek Tiwari 4 commented Dec 2, 2018 reply Follow flag @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 0 0 replyShare Please log in or register to add a comment.
