edited by
427 views

1 Answer

0 votes
0 votes

R1(1-1) RELATION  E1 REQUIRED 3 ATTRIBUTE TABLE (A B C) AND  E2 ALSO REQUIRED 3(D E F) ATTRIBUTE TABLE (1-1 RELATION WITH ONE PARTIAL REQUIRED NO EXTRA TABLE REQUIRED )

R2 RELATION (M-1) REQUIRED ONE EXTRA KEY WITH E3 (G H) + ONE ATTRIBUTE ADD IN E2 (G) TOTAL 3 ATTRIBUTES

R3 RELATION (M-M) REQUIRED ONE EXTRA TABLE IN E3  (G H) 2 ATTRIBUTES THEIR OWN + ONE EXTRA ATTRIBUTE OF E1 PK (A) FOR SO (G A) NEW TABLE . TOTAL 4 ATTRIBUTES 

R4 IS SELF REFERENTIAL IN (M-1) SO NO NEED FOR EXTRA ATTRIBUTE REQUIRED FOR IDENTIFY.

R5 (M-1) E4 REQUIRED ONLY 3 ATTRIBUTE THEIR OWN (I J K) -3 ATTRIBUTES

TOTAL NO OF ATTRIBUTES = 3+3+3+4+3 = 16

https://gateoverflow.in/127908/tables-in-self-referential-relations

 

 

 

Related questions

1 votes
1 votes
4 answers
1
1 votes
1 votes
1 answer
2
0 votes
0 votes
0 answers
3
1 votes
1 votes
0 answers
4