What is the primary purpose of the BCNF (Boyce-Codd Normal Form) in Database Normalization?
1
To reduce redundancy in data storage.
2
To ensure functional dependencies are preserved
3
To eliminate transitive dependencies
4
To enforce a unique primary key for each table