Sign up now
to enroll in courses, follow best educators, interact with the community and track your progress.
Download
GATE 1998, UGC 2015, UGC 2017, UGC 2018, ISRO 2018 on Normalization (in Hindi)
256 plays

More
This course will cover Normalization in Databases with 25 Previous Year Questions plus some practice questions from beginning level to expert.

Sweta Kumari is teaching live on Unacademy Plus

Sweta Kumari
YouTuber (channel : GATE NoteBook) | Verified Educator | 2+ year Online Teaching Experience

U
Unacademy user
AT
@Mohit Malviya We took 6C6 as only six guests are left for that side. The other 5 have already ​sat on the other side of the table.
S
thnkss sweta mam..stay blessed dear..
If every non-prime attribute is functionally dependent on the primary key, then the relation is in 3NF. please reply
  1. 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


  2. 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