4 votes 4 votes Consider a relation R(ABCD) is decomposed into R1(AC), R2(BD) based on some set of functional dependencies then R1 and R2 definitely be in _______________ Normal Form. Databases databases database-normalization + – Parshu gate asked Nov 13, 2017 • retagged May 27, 2021 by Shiva Sagar Rao Parshu gate 764 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
3 votes 3 votes BCNF.... hs_yadav answered Nov 13, 2017 hs_yadav comment Share Follow See all 2 Comments See all 2 2 Comments reply Parshu gate commented Nov 13, 2017 reply Follow Share @hs how is it BCNF? 0 votes 0 votes hs_yadav commented Nov 13, 2017 reply Follow Share @parshu let discuss all the possible FDs...R1(A->C /C->A/AC->A/AC->C).. a relation would be in BCNF if left side of all the non-trivial Fds are 'Keys'....(1.A->C it represent A is prime key..C->A in this case C would be prime keys..AC->C or AC->A are trivial(always valid)... similerly for R2.. 0 votes 0 votes Please log in or register to add a comment.
1 votes 1 votes if a relation with two attribute then it always is in BCNF . given relation R1(BC) AND R2(AD) BOTH have two attribute hence it is in BCNF. 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 Decomposition of Relation R is lossy, as there is no common attribute between R1 and R2. So, We don't decompose them further. But if we talk about R1(AC) and R2(BD) independently without considering about R. Then R1 and R2 will be in BCNF( Every relation with 2 attributes will be in BCNF). @Parshu gate : Can you please provide source of this question and answer.? Varun Raj Akula answered Mar 8, 2022 Varun Raj Akula comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes BCNF ... BCNF (Boyce Codd Normal Form) :: # A relation R is in BCNF whenever a non – trivial functional dependency X → A holds in R, where X is the super-key of R.... ## A binary relation is always in BCNF. A binary relation contains only two attributes.... ## Functional dependency that is possible from a binary relation is one.... Every relation with two attributes is in BCNF.… 33 answered Mar 8, 2022 33 comment Share Follow See all 0 reply Please log in or register to add a comment.