Normalization in Database Design complete study guide
Normalization - Technique for creating suitable database relations.
Suitable Relations - Relations with minimal attributes and logical grouping.
Data Redundancy - Unnecessary duplication of data in a database.
Update Anomalies - Inconsistencies arising from redundant data updates.
Lossless-Join Property - Reconstruct original relation from smaller relations.
Dependency Preservation - Maintaining constraints in smaller relations.
Functional Dependency - Relationship where one attribute determines another.
Determinant - Attribute on the left side of a functional dependency.
Full Functional Dependency - Dependency where no proper subset can determine the
attribute.
Partial Dependency - Dependency on a proper subset of attributes.
Transitive Dependency - Dependency where A determines B, and B determines C.
Primary Key - Unique identifier for a record in a relation.
Minimal Attributes - Least number of attributes needed for data requirements.
