0 votes 0 votes $(A)1$ $(B)2$ $(C)4\\$ $(D)\ 5$ Databases databases bcnf-decomposition made-easy-test-series + – tirth_patel asked Jan 17, 2022 tirth_patel 546 views answer comment Share Follow See all 5 Comments See all 5 5 Comments reply palashbehra5 commented Jan 17, 2022 i edited by palashbehra5 Jan 17, 2022 reply Follow Share if multivalued attributes cannot be NULL, only 2:R1(Sid, Email, Dob, Sname) {Sid, Email → DoB, Sname }R2(Game Likes, Phone No, Course Id, Sid, Email)However, if attributes can be NULL, 4 :R1(Sid, Email, Dob, Sname) {Sid, Email → DoB, Sname }R2(Game Likes, Sid, Email)R3(Phone No, Sid, Email)R4(Course Id, Sid, Email) 0 votes 0 votes Shaik Masthan commented Jan 17, 2022 reply Follow Share your first case : 2 tables sufficient, is those tables are in BCNF ? 0 votes 0 votes palashbehra5 commented Jan 17, 2022 reply Follow Share Shaik Masthan I might be missing something, can you please explain why they are not? 0 votes 0 votes Shaik Masthan commented Jan 17, 2022 reply Follow Share Listout the FD’s from table, R2(Game Likes, Phone No, Course Id, Sid, Email), then check are those in BCNF or not 2 votes 2 votes palashbehra5 commented Jan 17, 2022 reply Follow Share Shaik Masthan got it!!! very silly mistake, thought all of those attributes can work as a composite key. 1 votes 1 votes Please log in or register to add a comment.
0 votes 0 votes Answer should be- 4 3 for all different multi valued attribute and one for simple attribute. amitraj123 answered Jan 17, 2022 amitraj123 comment Share Follow See all 0 reply Please log in or register to add a comment.