2 votes 2 votes Consider the relation R(ABCD) with dependencies F:{A->B, B->C , C->D ,D->A}. if decomposed into R1(ABC) and R2(BD), then the relation R1(ABC) is in ________ Normal Form and what will be the keys of R1? Nikhil Vaidya asked Jan 20, 2018 • edited Jan 23, 2018 by Nikhil Vaidya Nikhil Vaidya 484 views answer comment Share Follow See all 8 Comments See all 8 8 Comments reply Show 5 previous comments Hemant Parihar commented Jan 20, 2018 reply Follow Share A, B, C, D are the keys, already the given relation is BCNF. And we further decompose it. Both R1 and R2 are BCNF. Moreover the decomposition is lossless and FD's preserving. 0 votes 0 votes Nikhil Vaidya commented Jan 21, 2018 reply Follow Share The answer is BCNF but i don't know how they got it. So anyone know the perfect solution then plz post it. 0 votes 0 votes Mk Utkarsh commented Jan 21, 2018 reply Follow Share It is BCNF i do same mistake every time I will post a well formed answer after some time 0 votes 0 votes Please log in or register to add a comment.
