Database Design Section 6

1.  If an entity has a multi-valued attribute, to conform to the rule of 1st Normal Form we:
Mark for Review (1) Points
Create an additional entity and relate it to the original entity with a M:M relationship.
Do nothing, an entity does not have to be in 1st Normal Form
Make the attribute optional
Create an additional entity and relate it to the original entity with a 1:M relationship. (*)
2.  To convert an entity with a multi valued attribute to 1st Normal Form, we create an additional entity and relate it to the original entity with a 1:1 relationship. True or False?
Mark for Review (1) Points
True
False (*)
3.  When data is only stored in one place in a database, the database conforms to the rules of ___________.
Mark for Review (1) Points

Multiplication
Reduction
Normalization (*)
Normality
4.  When data is stored in more than one place in a database, the database violates the rules of ___________.
Mark for Review (1) Points
Normalcy
Replication
Decency
Normalization (*)
5.  A transitive dependency exists when any attribute in an entity is dependent on any other non-UID attribute in that entity.
Mark for Review (1) Points
True (*)
False
6.  Examine the following Entity and decide which sets of attributes break the 3rd Normal Form rule:
ENTITY: TRAIN
ATTRIBUTES:
    TRAIN ID
    MAKE
    DRIVER ID
    DRIVER NAME
    DATE OF MANUFACTURE
Mark for Review (1) Points
TRAIN ID, MAKE
DRIVER ID, DRIVER NAME (*)
MAKE, DATE OF MANUFACTURE
None of the above, the entity is already in 3rd Normal Form.
7.  The Rule of 3rd Normal Form states that No Non-UID attribute can be dependent on another non-UID attribute. True or False?


Mark for Review (1) Points
True (*)
False
8.  As a database designer, you do not need to worry about where in the datamodel you store a particular attribute; as long as you get it onto the ERD, your job is done. True or False?
Mark for Review (1) Points
True
False(*)
9.  Examine the following entity and decide which attribute breaks the 2nd Normal Form rule:
ENTITY: CLASS
ATTRIBUTES:
   #CLASS ID
   #TEACHER ID
   SUBJECT
   TEACHER NAME
Mark for Review (1) Points
CLASS ID
TEACHER ID
TEACHER NAME (*)
SUBJECT
10.  Any Non-UID attribute must be dependent upon the entire UID. True or False?
Mark for Review (1) Points
True (*)
False
11.  To resolve a 2nd Normal Form violation, we:
Mark for Review (1) Points
Do nothing, an entity does not need to be in 2nd Normal Form.
Move the attribute that violates 2nd Normal Form to a new entity with a relationship to the original entity. (*)
Move the attribute that violates 2nd Normal Form to a new ERD.
Delete the attribute that was causing the violation
12.  An entity could have more than one attribute that would be a suitable Primary UID. True or False?
Mark for Review (1) Points
True (*)
False
13.  There is no limit to how many columns can make up an entity's UID. True or False?
Mark for Review (1) Points
True (*)
False
14.  Which of the following would be suitable UIDs for the entity EMPLOYEE: (Choose Two)

(Choose all correct answers)
Mark for Review (1) Points

Address Social Security Number (*)
Last Name Employee ID (*)
15.  The candidate UID that is chosen to identify an entity is called the Primary UID; other candidate UIDs are called Secondary UIDs.
Mark for Review (1) Points

No, each Entity can only have one UID, the secondary one.
No, it is not possible to have more than one UID for an Entity.
No, after UIDs are first sorted, the first one is called the Primary UID, the second is the Secondary UID, etc.
Yes, this is the way UID's are named. (*)