Chapter 5 - MISY 5300
1NF (First Normal Form) - answerable is in this form when it does not contain repeating
groups, each column contains atomic values and no duplicate records
2NF - answeris a progression beyond 1NF that organizes the columns into smaller
relation, no partial dependencies
3NF - answerinclude rules of 2NF but also exclude transitive dependencies. - No
transitive dependencies exist
4NF - answerall requirements meet of 3NF
Further data integrity rules have been applied to remove all potential data modification
anomalies
algoirthm - answerdefined set of steps to solve a problem
atomic value - answeris a piece of data that cannot be meaningfully divided.
Boyce-Codd Normal Form (BCNF) - answerA special type of third normal form (3NF) in
which every determinant is a candidate key
candidate key - answerAn attribute, or combination of attributes, that uniquely identifies
a row in a relation.
Codd's 12 rules - answerdefines what is required from a DBMS in order for it to be
considered relational
Codd's relational model of data - answerthe original normalization process
composite key - answerAn identifier consisting of a combination of
two or more fields that is used when more than one column is necessary to make a row
unique in a table; also, an index with more than one key field.
data modification anomalies - answerstoring info from multiple topics in one list creates
problems when entering, updating and deleting information. Three types, insertion,
update and delete anomalies
Deletion Anomaly - answer- unintended loss of data due to deletion of other data
- Ex: If a professor retires, data with his name deletes creating data deleted about
current students
field - answerattribute, column
1NF (First Normal Form) - answerable is in this form when it does not contain repeating
groups, each column contains atomic values and no duplicate records
2NF - answeris a progression beyond 1NF that organizes the columns into smaller
relation, no partial dependencies
3NF - answerinclude rules of 2NF but also exclude transitive dependencies. - No
transitive dependencies exist
4NF - answerall requirements meet of 3NF
Further data integrity rules have been applied to remove all potential data modification
anomalies
algoirthm - answerdefined set of steps to solve a problem
atomic value - answeris a piece of data that cannot be meaningfully divided.
Boyce-Codd Normal Form (BCNF) - answerA special type of third normal form (3NF) in
which every determinant is a candidate key
candidate key - answerAn attribute, or combination of attributes, that uniquely identifies
a row in a relation.
Codd's 12 rules - answerdefines what is required from a DBMS in order for it to be
considered relational
Codd's relational model of data - answerthe original normalization process
composite key - answerAn identifier consisting of a combination of
two or more fields that is used when more than one column is necessary to make a row
unique in a table; also, an index with more than one key field.
data modification anomalies - answerstoring info from multiple topics in one list creates
problems when entering, updating and deleting information. Three types, insertion,
update and delete anomalies
Deletion Anomaly - answer- unintended loss of data due to deletion of other data
- Ex: If a professor retires, data with his name deletes creating data deleted about
current students
field - answerattribute, column
