In database normalization, what type of functional dependency is characterized by a non-key attribute depending on another non-key attribute, violating 3NF?
Subject: Database Systems
Topic: Database Normalization
Options:
- Option A: Partial Dependency
- Option B: Transitive Dependency
- Option C: Trivial Dependency
- Option D: Multivalued Dependency
Correct Answer:
Option B: Transitive Dependency
Explanation:
A transitive dependency exists when a non-key attribute depends on another non-key attribute, which in turn depends on the primary key. Removing transitive dependencies puts the table in 3NF.