in Databases
654 views
0 votes
0 votes

Minimum number of tables required to represent the relation R where the $A_n$ stands for the primary key of each entity is ___________

in Databases
by
654 views

4 Comments

5 tables.

1 for E1,E2,E3,E4 each and other table that connects them and contains A1,A2,A3,A4,A5 as columns.
2
2
thanks..:)
0
0

@Satbir

how r u concluding that separate table will be formed as A1, A2, A3, A4, A5?

0
0
edited by
because i am thinking that A1,A2,A3,A4,A5 will be used in the relation to connect all the tables.

 a tuple of A1 is related to another tuple of A2 and it is also connected to a tuple of A3.

So if you write two combined tuples as a result and make a single table for A1,A2 and A3  then there will be data duplicacy as A1 tuple data will be present in both the tuples.

So instead of doing this just write seperate tables for each of them and make an extra table named connection which just shows the connection among various tables.
0
0

1 Answer

0 votes
0 votes
Every relationship is N To N so separate table consider to everyone so 5 is answer
by

1 comment

@avadh

how u got that every relationship is N: N?

0
0

Related questions

0 votes
0 votes
0 answers
1