Database design functional dependencies and Normalization GATE (1994-2006)- PYQ (Q2.1 to Q2.25)
2.1 [GATE 1994 : 1 Mark] Question:State True or False with reason:There is always a decomposition into Boyce-Codd Normal Form (BCNF) that is lossless and dependency preserving. Answer: False solution:BCNF में हमेशा Lossless decomposition मिल जाता है, लेकिन Dependency Preserving हर बार नहीं मिलता। Example: R(A,B,C) with AB->C and C->A. ये 3NF में है लेकिन
