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 ___________ Databases databases rdbms + – Hirak asked May 25, 2019 Hirak 684 views answer comment Share Follow See all 4 Comments See all 4 4 Comments reply Satbir commented May 25, 2019 reply Follow Share 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 votes 2 votes Hirak commented May 25, 2019 reply Follow Share thanks..:) 0 votes 0 votes akash.dinkar12 commented May 27, 2019 reply Follow Share @Satbir how r u concluding that separate table will be formed as A1, A2, A3, A4, A5? 0 votes 0 votes Satbir commented May 27, 2019 i edited by Satbir May 27, 2019 reply Follow Share 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 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes Every relationship is N To N so separate table consider to everyone so 5 is answer avadh answered May 27, 2019 avadh comment Share Follow See 1 comment See all 1 1 comment reply akash.dinkar12 commented May 27, 2019 reply Follow Share @avadh how u got that every relationship is N: N? 0 votes 0 votes Please log in or register to add a comment.
