0 votes 0 votes How many minimum number of tables needed for this Quaternary Relationship? Databases databases er-diagram er-to-relational relational + – Balaji Jegan asked Nov 4, 2018 Balaji Jegan 2.2k views answer comment Share Follow See all 27 Comments See all 27 27 Comments reply Gupta731 commented Nov 4, 2018 reply Follow Share 6? 0 votes 0 votes adarsh_1997 commented Nov 4, 2018 reply Follow Share @gupta731 what type of attribute is Z? 0 votes 0 votes Gupta731 commented Nov 4, 2018 reply Follow Share multivalued attribute 0 votes 0 votes adarsh_1997 commented Nov 4, 2018 reply Follow Share 7? 0 votes 0 votes Gupta731 commented Nov 4, 2018 reply Follow Share Oh I missed 1 multivalued attribute, answer should be 7 0 votes 0 votes utk0203 commented Nov 4, 2018 reply Follow Share Please explain anyone? What I did is 4 Tables each for E F G H. Now There is only 1 many to many relation i.e E<-->G. So, 1 MORE TABLE. So, Total number of tables = 5 . Anything I am missing? 0 votes 0 votes Magma commented Nov 4, 2018 reply Follow Share I got 4 Need to confirm :3 1 votes 1 votes Balaji Jegan commented Nov 4, 2018 reply Follow Share Please tell ur approaches. This is a self-doubt question. 0 votes 0 votes Gupta731 commented Nov 4, 2018 reply Follow Share Multivalued attributes must be represented in separate tables, so we require 3 more tables for B, Z and K 0 votes 0 votes srestha commented Nov 6, 2018 i edited by srestha Nov 6, 2018 reply Follow Share @Magma yes 4 table 3 table for multivalued attribute and 1 table for many to 1 participation and partial participation on one side 0 votes 0 votes Gupta731 commented Nov 6, 2018 reply Follow Share @srestha mam why 5 tables , we need separate tables for E, F, G, H and there are 3 multivalued attribute. So total 7 tables. Is anything wrong with my approach? 0 votes 0 votes srestha commented Nov 6, 2018 reply Follow Share No actually if there is total participation we can merge it in 1 table 0 votes 0 votes Magma commented Nov 6, 2018 reply Follow Share you take multi-valued attribute as a candidate key How it's possible ?? -- > see the "Z" attribute btw if One entity have 2 or more multi-valued attribute we can merge it into the one table assume here J is a candidate key then Relation (J Z K ) .. where JZK act as primary key I'm right ?? 0 votes 0 votes Gupta731 commented Nov 6, 2018 reply Follow Share Means if we have a multivalued attribute with an entity and if that entity is in total participation then we can merge. Like here in case of B and G? 0 votes 0 votes Manas Mishra commented Nov 6, 2018 reply Follow Share @balaji if we need our table to be in 1NF then we can merge evrything in jst one table......... 0 votes 0 votes srestha commented Nov 6, 2018 reply Follow Share @Magma if One entity have 2 or more multi-valued attribute we can merge it into the one table how multivalued attribute can merge in a single table Any eample or book recommend for this? 0 votes 0 votes Magma commented Nov 6, 2018 reply Follow Share mam i'm just talking about how many separate tables we needed for multi-valued attribute 2 separate table needed for multi-valued attributes and 2 tables are needed for of relation G to F and H to E 0 votes 0 votes Manas Mishra commented Nov 6, 2018 reply Follow Share If we take E and F then its Total and partial relationship and partial on N side so we can merge E , F and R in one table .. now take E and G both side total participation so can be merged in one table then merge G with E,Fand R .. Now take E and H its Total and partial relationship and partial on N side so we can merge E and H in one table ... so we can merge all E, F ,G ,H ,R in one table... so 1 table neede 0 votes 0 votes srestha commented Nov 6, 2018 reply Follow Share 2 tables are needed for of relation G to F and H to E why? @Magma 2 separate table needed for multi-valued attributes which one r u merging? 0 votes 0 votes Gurdeep Saini commented Nov 8, 2018 reply Follow Share Manas Mishra Magma please anyone explain summery 0 votes 0 votes Raghav Khajuria commented Nov 8, 2018 reply Follow Share I got 4 tables to satisy 1NF & thats what he is asking about.Result would vary if ask for 2NF,3NF,BCNF or 4NF. 0 votes 0 votes Hemanth_13 commented Dec 2, 2018 reply Follow Share @Magma how can we merge a many to one or one to may relation ship into one table ? 0 votes 0 votes pradeepchaudhary commented Jan 28, 2019 reply Follow Share Yes, Multi valued attributes should be placed in the separate table.... 0 votes 0 votes balchandar reddy san commented Jan 28, 2019 i reshown by balchandar reddy san Jan 28, 2019 reply Follow Share There is M:N relation b/w E&F right..don't you think we need one more table for relation? 0 votes 0 votes Gurdeep Saini commented Jan 28, 2019 reply Follow Share how a multivalued attribute can be a primary key (z) 0 votes 0 votes hitesh159 commented Oct 31, 2019 reply Follow Share any good source to learn this topic???,i am unable to find any standard rules 0 votes 0 votes `JEET commented Oct 31, 2019 reply Follow Share Refer Korth. It's given there. 0 votes 0 votes Please log in or register to add a comment.
2 votes 2 votes 7 4 for entities and 3 for multivalued mranaljoshi answered Nov 7, 2018 mranaljoshi comment Share Follow See all 3 Comments See all 3 3 Comments reply Balaji Jegan commented Nov 8, 2018 reply Follow Share Doesn't the relation require an extra table, since it is Quaternary? 0 votes 0 votes mranaljoshi commented Nov 9, 2018 reply Follow Share it has nothing to do with it.we just see the entities and m to n relationships in order to have the min tables 0 votes 0 votes jiminpark commented Jan 21, 2022 reply Follow Share @mranaljoshi Sir, I have read somewhere that if any entity had more than one Multivalued attributes, it can even be put in the same table created for other multivalued. Means here in this case we dont need fo create seperate tables for two Multivalued attributes of same entity, it can be put into one. Is it true? 0 votes 0 votes Please log in or register to add a comment.
1 votes 1 votes I think answer is 6 nishant_magarde answered Nov 25, 2018 nishant_magarde comment Share Follow See all 0 reply Please log in or register to add a comment.