2 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? Databases + – Nikhil Vaidya 1.2k views answer comment Share Follow Print See all 8 Comments 8 8 Comments reply Show 5 previous comments Hemant Parihar commented Jan 20, 2018 reply Follow flag 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 0 replyShare Nikhil Vaidya commented Jan 21, 2018 reply Follow flag The answer is BCNF but i don't know how they got it. So anyone know the perfect solution then plz post it. 0 0 replyShare Mk Utkarsh commented Jan 21, 2018 reply Follow flag It is BCNF i do same mistake every time I will post a well formed answer after some time 0 0 replyShare Please log in or register to add a comment.
