INMT 342 Exam 2 questions and
answers graded A+ updated
normalization - correct 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? - correct answer ✔✔ insertion anomalies
update anomalies
deletion anomalies
redundancy
functional dependency - correct 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 - correct answer ✔✔ data is not in table format
identifier is not defined or bad
table has multi-valued attributes
normalization: 1 normal form - correct answer ✔✔ good identifier
no multi-valued attributes (fill in blanks or separate lists)
, partial functional dependency - correct 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 - correct 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 - correct 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 - correct answer ✔✔ already in 2nd normal form
no transitive dependencies
go from 2NF to 3NF by breaking the original table into two related tables (functional
dependency)
every non-key field must be dependent on only the primary key
denormalization - correct answer ✔✔ the process of transforming normalized tables into non-
normalized physical record specifications
answers graded A+ updated
normalization - correct 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? - correct answer ✔✔ insertion anomalies
update anomalies
deletion anomalies
redundancy
functional dependency - correct 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 - correct answer ✔✔ data is not in table format
identifier is not defined or bad
table has multi-valued attributes
normalization: 1 normal form - correct answer ✔✔ good identifier
no multi-valued attributes (fill in blanks or separate lists)
, partial functional dependency - correct 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 - correct 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 - correct 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 - correct answer ✔✔ already in 2nd normal form
no transitive dependencies
go from 2NF to 3NF by breaking the original table into two related tables (functional
dependency)
every non-key field must be dependent on only the primary key
denormalization - correct answer ✔✔ the process of transforming normalized tables into non-
normalized physical record specifications
