CNIT 272 Final Exam
Minimization - Answer-A Primary Key having the fewest number of attributes to make it unique is called.
Identifying Relationship - Answer-If the child entity requires the primary key of the parent entity for its
unique identity, then you create ______.
Non-Identifying Relationship - Answer-If each child record has a unique identifier of its own, then the
relationship is know as a _______.
Independent Entity - Answer-Entities that have no foreign keys in their pk.
Dependent Entity - Answer-Entities that have foreign keys in their pk.
Associative Entity - Answer-An entity that is created as the result of a many-to-many relationship.
Update Anomalies - Answer-Abnormalities or problems introduced by insert, delete, and update
(change) actions.
Index - Answer-An auxiliary file to improve performance.
, First Normal Form - Answer-Previous normal forms (If there are any) and no recurring attribute values
are allowed in an entity (each attribute has one value per instance)
Second Normal Form - Answer-An entity that is in any previous normal forms and every non-primary key
attribute is fully functionally dependent on the full primary key.
EACH non-key attribute carries a fact about the entire key of the entity in which it resides.
Third Normal Form - Answer-In 2NF and EACH non-key attribute depends on the key (the whole key) of
that entity and...
NOT on any non-key attribute in the same entity.
NOT on any attribute in another entity.
These dependency issues are called Transitive Dependencies
Functional Dependence - Answer-A requirement that a non-key requires the pk.
Determinant - Answer-A requirement that the pk determines the non-key attributes.
Domain - Answer-Representative of all possible valid values. (Datatype, size, range, default value, etc.)
Referential Integrity - Answer-Enforces parent-child existence constraints, table relationships must
always be consistent.
Minimization - Answer-A Primary Key having the fewest number of attributes to make it unique is called.
Identifying Relationship - Answer-If the child entity requires the primary key of the parent entity for its
unique identity, then you create ______.
Non-Identifying Relationship - Answer-If each child record has a unique identifier of its own, then the
relationship is know as a _______.
Independent Entity - Answer-Entities that have no foreign keys in their pk.
Dependent Entity - Answer-Entities that have foreign keys in their pk.
Associative Entity - Answer-An entity that is created as the result of a many-to-many relationship.
Update Anomalies - Answer-Abnormalities or problems introduced by insert, delete, and update
(change) actions.
Index - Answer-An auxiliary file to improve performance.
, First Normal Form - Answer-Previous normal forms (If there are any) and no recurring attribute values
are allowed in an entity (each attribute has one value per instance)
Second Normal Form - Answer-An entity that is in any previous normal forms and every non-primary key
attribute is fully functionally dependent on the full primary key.
EACH non-key attribute carries a fact about the entire key of the entity in which it resides.
Third Normal Form - Answer-In 2NF and EACH non-key attribute depends on the key (the whole key) of
that entity and...
NOT on any non-key attribute in the same entity.
NOT on any attribute in another entity.
These dependency issues are called Transitive Dependencies
Functional Dependence - Answer-A requirement that a non-key requires the pk.
Determinant - Answer-A requirement that the pk determines the non-key attributes.
Domain - Answer-Representative of all possible valid values. (Datatype, size, range, default value, etc.)
Referential Integrity - Answer-Enforces parent-child existence constraints, table relationships must
always be consistent.
