5 votes 5 votes Consider the following E-R diagram: What is the minimum relations required which satisfied the 2nd normal form? A) 1 B) 2 C) 3 D) 4 Databases databases database-normalization er-diagram + – Rohit Gupta 8 asked Nov 18, 2017 edited Nov 18, 2017 by Rohit Gupta 8 Rohit Gupta 8 1.3k views answer comment Share Follow See all 12 Comments See all 12 12 Comments reply Show 9 previous comments joshi_nitish commented Nov 18, 2017 reply Follow Share yups.. 0 votes 0 votes Shubhanshu commented Nov 18, 2017 reply Follow Share Suppose if it were asked to cal number of tables for BCNF with same diagram except that C should be single valued then we will have 3 tables E1((A)BC) R((AD)) E2((D)EF) because if we merge all in one then that will be in 1nf but not even 2nf because of PDs A--> BC D --> EF ryt. 0 votes 0 votes joshi_nitish commented Nov 18, 2017 reply Follow Share yes, correct. 0 votes 0 votes Please log in or register to add a comment.
6 votes 6 votes There will be 4 tables as follows: $E_1$(A,C) (for mutivalued attribute C) $E_1$(A,B) $E_2$(D,E,F) R(A,D) (for m:n relationship ) Arnabi answered Nov 18, 2017 edited Nov 18, 2017 by Arnabi Arnabi comment Share Follow See all 6 Comments See all 6 6 Comments reply Show 3 previous comments Rohit Gupta 8 commented Nov 18, 2017 reply Follow Share Here relationship type is not given. Are we supposed to think it as m:n relationship? 0 votes 0 votes Arnabi commented Nov 18, 2017 reply Follow Share how 3? if there are no arrows it means many to many relationship. 0 votes 0 votes joshi_nitish commented Nov 18, 2017 reply Follow Share line without arrow head (------------) means 'n' line with arrow head (----------->) means '1' 5 votes 5 votes Please log in or register to add a comment.
0 votes 0 votes 3 table is required abhishekmehta4u answered Mar 30, 2018 abhishekmehta4u comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes 4 table is required -- R1(A,B) R2(A,C) R3(A,D) R4(D,E,F) Shailendra_ answered Nov 22, 2019 Shailendra_ comment Share Follow See all 0 reply Please log in or register to add a comment.