## Sweta Kumari is teaching live on Unacademy Plus

For a database relation R(a,b,c,d) where the domains of a, b, c and d include only atomic values, only the following functional dependencies and those that can be inferred from them hold a->cb-> d The relation is in Select the 'False' statement from the following statements about Normal Forms: (A) Lossless preserving decomposition into 3NF is always possible (B) Lossless preserving decomposition into BCNFis always possible (C) Any Relation with two attributes is in BCNF (D) BCNF is strongerthan 3NF UGC 2015 ISRO 2018 GATE 1998 Which normal form is considered adequate for normal relational Relations produced from E- R Model ill alwaysdatabase design? be in UGC 2018 If every non-key attribute is functionally dependent on the primary key, then the relation is in UGC 2017 Consider a schema R(MNPQ) and functional dependencies M N, P Q. Then the decomposition of R into R1 (MN) and R2(PQ) is_ UGC 2017

For a database relation R(a,b,c,d) where the domains of a, b, c and d include only atomic values, only the following functional dependencies and those that can be inferred from them hold a->cb-> d The relation is in 1NF but not 2NF Candidate Key is ab. Since all a,b,c,d are atomic so the relation is in 1 NF. a-c (Prime derives Non-Prime.) b->d (Prime derives Non-Prime.) Since, there are partial dependencies it is not in 2NF. Select the 'False' statement from the following statements about Normal Forms: (A) Lossless preserving decomposition into 3NF is always possible (B) Lossless preserving decomposition into BCNF is always possible (C) Any Relation with two attributes is in BCNF (D) BCNF is strongerthan 3NF UGC 2015 GATE 1998 Which normal form is considered adequate for normal relational database design? 3NF is sufficient because most of the 3NF tables are free of insertion, update, and deletion anomalies. Moreover, 3NF always ensures functional dependency preserving and lossless. ISRO 2018 Relations produced from E- R Model will always be in If every non-key attribute is functionally dependent on the primary key, then the relation is in 2NF 1NF UGC 2017 UGC 2018 UGC 2017 Consider a schema R(MNPQ) and functional dependencies M N, P Q. Then the decomposition of R into R1 (MN) and R2(PQ) is Schema R(MNPQ) is decomposed into R1(MN) M N is preserved and R2(PQ) P Q is also preserved, dependency will be preserved and there will be no loss of any dependency