INMT 342 Exam 2 Normalization
questions n answers rated A+
Normalization is the process of - correct answer ✔✔ grouping attributes together into tables
Normalization validates and improves logical database design to satisfy - correct answer ✔✔
certain constraints and avoid duplication of data
normalization decomposition of tables to remove - correct answer ✔✔ anomalies and create
two or more well- structured tables
Well structured tables avoid - correct answer ✔✔ Insertion Anomalies
Update Anomalies Deletion Anomalies
functional dependencies - correct answer ✔✔ The value of one attribute determines the value
of another attribute
Steps to normalization - correct answer ✔✔ Remove multivalued attributes
remove partial dependencies
remove transitive dependencies
first normal form - correct answer ✔✔ -Primary key is identified
- no multivalued attributes
-Repeating groups are eliminated
questions n answers rated A+
Normalization is the process of - correct answer ✔✔ grouping attributes together into tables
Normalization validates and improves logical database design to satisfy - correct answer ✔✔
certain constraints and avoid duplication of data
normalization decomposition of tables to remove - correct answer ✔✔ anomalies and create
two or more well- structured tables
Well structured tables avoid - correct answer ✔✔ Insertion Anomalies
Update Anomalies Deletion Anomalies
functional dependencies - correct answer ✔✔ The value of one attribute determines the value
of another attribute
Steps to normalization - correct answer ✔✔ Remove multivalued attributes
remove partial dependencies
remove transitive dependencies
first normal form - correct answer ✔✔ -Primary key is identified
- no multivalued attributes
-Repeating groups are eliminated
