Data Normalization Quiz: Test Your Knowledge of 1NF and 2NF

📚 Quick Study Guide

🔍 First Normal Form (1NF): Eliminate repeating groups of data. Each column should contain atomic values, meaning they cannot be further subdivided. 📈 Second Normal Form (2NF): Must be in 1NF and eliminate redundant data. No non-prime attribute should be dependent on any proper subset of any candidate key. 🔑 Prime Attribute: An attribute that is part of a candidate key. 🧩 Non-Prime Attribute: An attribute that is not part of any candidate key. 📝 Functional Dependency: Attribute B is functionally dependent on attribute A if each value of A determines one and only one value of B.

🧪 Practice Quiz

1. Which of the following is the primary goal of 1NF?
   1. Eliminating all redundancy.
   2. Ensuring each column contains atomic values.
   3. Removing partial dependencies.
   4. Creating foreign keys.
2. A table is in 1NF but not in 2NF. What must be true about the table?
   1. It has no primary key.
   2. It has a composite primary key and a non-key attribute dependent on only part of the key.
   3. All attributes are functionally dependent on the entire key.
   4. It contains repeating groups of data.
3. What does it mean for an attribute to be 'atomic' in the context of 1NF?
   1. It is a primary key.
   2. It cannot be further subdivided.
   3. It is a foreign key.
   4. It must be an integer.
4. Which of the following must be true for a table to be in 2NF?
   1. It must be in 3NF.
   2. It must be in 1NF and have no partial dependencies.
   3. It must have a single-attribute primary key.
   4. It must not have any foreign keys.
5. Consider a table with attributes A, B, and C, where A is the primary key. If B is functionally dependent on A, and C is functionally dependent on B, is this table necessarily in 2NF?
   1. Yes, because all attributes are functionally dependent.
   2. No, because we don't know if it's in 1NF.
   3. Yes, because there are no partial dependencies on the primary key.
   4. No, because C is transitively dependent on A.
6. A table has a composite primary key consisting of attributes X and Y. Attribute Z is dependent on X only. Which normal form does this table violate?
   1. 1NF
   2. 2NF
   3. 3NF
   4. BCNF
7. Why is it important to normalize data?
   1. To increase the size of the database.
   2. To reduce data redundancy and improve data integrity.
   3. To complicate data retrieval.
   4. To eliminate the need for primary keys.