INMT 342 Exam 2 Questions and Correct
Solutions
normalization - Answer-the process of grouping attributes together into tables
it helps to validate and improve logical database design to satisfy constraints and avoid duplication of
data
what do well structured tables avoid? - Answer-insertion anomalies
update anomalies
deletion anomalies
redundancy
functional dependency - Answer-the value of one attributes determines the value of other attributes
a well-structured table has a single functional dependency; an individual's SSN can tell about every
attribute in the table
normalization: 0 normal form - Answer-data is not in table format
, identifier is not defined or bad
table has multi-valued attributes
normalization: 1 normal form - Answer-good identifier
no multi-valued attributes (fill in blanks or separate lists)
partial functional dependency - Answer-the value of non-key fields are functionally dependent on only
part of the primary key field
multiple primary keys that each tell different things about the table; need to be split up
normalization: 2 normal form - Answer-already in 1st normal form
has no partial functional dependencies
go from 1NF to 2NF by breaking the original table into two related tables (functional dependency)
every non-key field must be dependent on the entire primary key
transitive dependency - Answer-the value of non-key fields are functionally dependent on other non-
key fields
ex: salary class field determines what goes in salary field
normalization: 3 normal form - Answer-already in 2nd normal form
no transitive dependencies
Solutions
normalization - Answer-the process of grouping attributes together into tables
it helps to validate and improve logical database design to satisfy constraints and avoid duplication of
data
what do well structured tables avoid? - Answer-insertion anomalies
update anomalies
deletion anomalies
redundancy
functional dependency - Answer-the value of one attributes determines the value of other attributes
a well-structured table has a single functional dependency; an individual's SSN can tell about every
attribute in the table
normalization: 0 normal form - Answer-data is not in table format
, identifier is not defined or bad
table has multi-valued attributes
normalization: 1 normal form - Answer-good identifier
no multi-valued attributes (fill in blanks or separate lists)
partial functional dependency - Answer-the value of non-key fields are functionally dependent on only
part of the primary key field
multiple primary keys that each tell different things about the table; need to be split up
normalization: 2 normal form - Answer-already in 1st normal form
has no partial functional dependencies
go from 1NF to 2NF by breaking the original table into two related tables (functional dependency)
every non-key field must be dependent on the entire primary key
transitive dependency - Answer-the value of non-key fields are functionally dependent on other non-
key fields
ex: salary class field determines what goes in salary field
normalization: 3 normal form - Answer-already in 2nd normal form
no transitive dependencies
