Section 6 Quiz (Answer all questions in this section)

1. A candidate UID that is not chosen to be the Primary UID is called:
Composite
Secondary (*)
Simple
Artificial


2. Where an entity has more than one attribute suitable to be the Primary UID, these are known as _____________ UIDs.
Secondary
Simple
Candidate (*)
Composite


3. If an entity has no attribute suitable to be a Primary UID, we can create an artificial one. True or False?
True (*)
False


4. There is no limit to how many columns can make up an entity's UID. True or False?
True (*)
False


5. An entity can have repeated values and still be in 1st Normal Form. True or False?
True
False (*)


6. When data is only stored in one place in a database, the database conforms to the rules of ___________.
Multiplication
Normality
Normalization (*)
Reduction


7. If an entity has a multi-valued attribute, to conform to the rule of 1st Normal Form we
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.
Create an additional entity and relate it to the original entity with a M:M relationship.


8. When all attributes are single-valued, the database model is said to conform to:
2nd Normal Form
4th Normal Form
1st Normal Form (*)
3rd Normal Form


9. When is an entity in 2nd Normal Form?
When all non-UID attributes are dependent upon the entire UID. (*)
When attributes with repeating or multi-values are present.
When no attritibutes are mutually independent and all are fully dependent on the primary ke
None of the Above.


10. To resolve a 2nd Normal Form violation, we:
Move the attribute that violates 2nd Normal Form to a new entity with a relationship to the original entity. (*)
Do nothing, an entity does not need to be in 2nd Normal Form.
Move the attribute that violates 2nd Normal Form to a new ERD.
Delete the attribute that was causing the violation.
(Answer all questions in this section)


11. Any Non-UID attribute must be dependent upon the entire UID. True or False?
True (*)
False


12. A transitive dependency exists when any attribute in an entity is dependent on any other non-UID attribute in that entity.
True (*)
False


13. Examine the following Entity and decide which rule of Normal Form is being violated:
ENTITY: CLIENT
ATTRIBUTES:
    # CLIENT ID
    FIRST NAME
    LAST NAME
    ORDER ID
    STREET
    ZIP CODE

1st Normal Form. (*)
2nd Normal Form.
3rd Normal Form.
None of the above, the entity is fully normalised.


14. 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

TRAIN ID, MAKE
DRIVER ID, DRIVER NAME (*)
MAKE, DATE OF MANUFACTURE
None of the above, the entity is already in 3rd Normal Form.


15. When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as:
Transitive dependency (*)
Non-dependency
Dependency
Functional dependency

Lanjutan... Database Design Section 7 Quiz

Download Source Code Program