INMT 342 Exam 2 Normalization Questions and Answers

INMT 342 Exam 2 Normalization
Normalization is the process of - answergrouping attributes together into tables

Normalization validates and improves logical database design to satisfy - answercertain
constraints and avoid duplication of data

normalization decomposition of tables to remove - answeranomalies and create two or
more well- structured tables

Well structured tables avoid - answerInsertion Anomalies
Update Anomalies Deletion Anomalies

functional dependencies - answerThe value of one attribute determines the value of
another attribute

Steps to normalization - answerRemove multivalued attributes
remove partial dependencies
remove transitive dependencies

first normal form - answer-Primary key is identified
- no multivalued attributes
-Repeating groups are eliminated

second normal form - answeris already in 1NF and every non key attribute is fully
functionally dependent on the primary key

fully functionally dependent on the primary key means - answerevery non key attribute
must be determined by the ENTIRE primary key not by only part of the primary key

how can we create 2NF - answerBy breaking the original table into two related tables on
the basis of functional dependency

Transitive dependency - answerwhen a non key attribute is functionally dependent on
another non-key attribute

third normal form - answerNon-key attributes are not allowed to define other non-key
attributes.