Consider the relation given below and ind the maximum normal form applicable to them
i. R(A, B) WITH productions { A –> B }
ii. R(A, B) WITH productions { B –> A }
iii. R(A, B) WITH productions {A —> B, B –> A }
iv. R(A, B, C) WITH productions {A –>B, B –> A, AB –> C }
a) i, ii and iii are in 3NF and iv is in BCNF
b) i and ii are in BCNF and iii and iv are in 3NF
c) All are in 3NF
d) All are in BCNF
Answer: d
Explanation: One of the more desirable normal forms that we can obtain is Boyce–Codd normal form (BCNF). It eliminates all redundancy that can be discovered based on functional dependencies.
Related Posts
Empdt1(empcode, name, street, city, state, pincode).
For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation inWhich forms are based on the concept of functional dependency:
Which forms has a relation that possesses data about an individual entity:
Which forms simplifies and ensures that there are minimal data aggregates and repetitive groups:
Which is a bottom-up approach to database design that design by examining the relationship between attributes:
Functional Dependencies are the types of constraints that are based on______
Which-one ofthe following statements about normal forms is FALSE?
Join The Discussion