Normalization (P2)

Question 1

Normalization

Answer 1

When larger tables in a database are divided into smaller tables to improve data integrity and reduce data redundancy.

Question 2

3 outlined reasons to use normalization

Answer 2

• Reduced data redundancy (saves up memory space)
• Reduced table complexity (Makes querying less error-prone)
• Makes sure data is stored logically (Makes querying more efficient)

Question 3

1NF - 5 characteristics

Answer 3

• Eliminate duplicate attributes
• Eliminate attributes with multiple values (only atomic attributes)
• Create separate tables for each group of related data
• Ensure that there is a primary/composite key
• Ensure that all records are unique

Question 4

2NF - 2 characteristics

Answer 4

• Meets all requirements for 1NF
• Eliminates partial dependency

Question 5

3NF - 2 characteristics

Answer 5

• Meet all requirements for 2NF
• Eliminates transitive dependency

Question 6

Partial Dependency

Answer 6

When a non-prime attribute is dependent on only part of a composite key

Question 7

Transitive Dependency

Answer 7

When a non-prime attribute is dependent on another non-prime attribute which is dependent on the primary key

Question 8

How to fix partial dependency, transitive dependency and what is similar in both solutions?

Answer 8

Partial dependency? 🔄 Split off attributes that depend on part of a composite key.

Transitive dependency? 🔁 Split off attributes that depend on another non-key attribute.

In both cases? ✅ Use foreign keys to keep the relationships intact.