DD & DP Final Exam Review: Essential Concepts and
Strategies
Normalization - correct answer ✔✔When data is stored in more than one place in a database, the
database violates the rules of ___________.
Employee ID, Social Security Number - correct answer ✔✔Which would be suitable UIDs for the entity
EMPLOYEE:
Attributes, Relationships - correct answer ✔✔A UID can be made up from.....
Exclusivity - correct answer ✔✔Arcs are used to visually represent _________ between two or more
relationships in an ERD.
Hierarchical - correct answer ✔✔Cascading UIDs are a feature often found in what type of Relationship?
Tables - correct answer ✔✔The transformation from an ER diagram to a physical design involves
changing terminology. Entities in the ER diagram become __________ :
The Primary Key - correct answer ✔✔A barrred Relationship will result in a Foreign Key column that also
is part of:
Intersection table - correct answer ✔✔To resolve a many to many relationship in a physical model you
create a(n) ___________________?
Pig's Ear - correct answer ✔✔A Recursive Relationship is represented on an ERD by a/an:
one - correct answer ✔✔You can only insert _____ row at a time using an INSERT statement with a
VALUES clause?
Strategies
Normalization - correct answer ✔✔When data is stored in more than one place in a database, the
database violates the rules of ___________.
Employee ID, Social Security Number - correct answer ✔✔Which would be suitable UIDs for the entity
EMPLOYEE:
Attributes, Relationships - correct answer ✔✔A UID can be made up from.....
Exclusivity - correct answer ✔✔Arcs are used to visually represent _________ between two or more
relationships in an ERD.
Hierarchical - correct answer ✔✔Cascading UIDs are a feature often found in what type of Relationship?
Tables - correct answer ✔✔The transformation from an ER diagram to a physical design involves
changing terminology. Entities in the ER diagram become __________ :
The Primary Key - correct answer ✔✔A barrred Relationship will result in a Foreign Key column that also
is part of:
Intersection table - correct answer ✔✔To resolve a many to many relationship in a physical model you
create a(n) ___________________?
Pig's Ear - correct answer ✔✔A Recursive Relationship is represented on an ERD by a/an:
one - correct answer ✔✔You can only insert _____ row at a time using an INSERT statement with a
VALUES clause?
