Section 6 Quiz Database Design Oracle

Section 6 Quiz

            (Answer all questions in this section)

1.         Examine the following Entity and decide which rule of Normal Form is being violated:

ENTITY: CLIENT

ATTRIBUTES:

    # CLIENT ID

    FIRST NAME

    LAST NAME

    STREET

    CITY

    ZIP CODE

 Mark for Review

(1) Points

            1st Normal Form.

            2nd Normal Form.

            3rd Normal Form.

            None of the above, the entity is fully normalised. (*)

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

3.         When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as:        Mark for Review

(1) Points

            Functional dependency

            Dependency

            Transitive dependency (*)

            Non-dependency

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

5.         Normalizing an Entity to 1st Normal Form is done by removing any attributes that contain muliple values. True or False?  Mark for Review

(1) Points

            True (*)

            False

6.         When all attributes are single-valued, the database model is said to conform to:      Mark for Review

(1) Points

            2nd Normal Form

            4th Normal Form

            1st Normal Form (*)

            3rd Normal Form

7.         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 1:M relationship. (*)

            Make the attribute optional

            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

8.         When data is only stored in one place in a database, the database conforms to the rules of ___________. Mark for Review

(1) Points

            Reduction

            Normality

            Multiplication

            Normalization (*)

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

10.       If an entity has no attribute suitable to be a Primary UID, we can create an artificial one. True or False?            Mark for Review

(1) Points

            True (*)

            False

11.       A unique identifier can only be made up of one attribute. True or False?     Mark for Review

(1) Points

            True

            False (*)

12.       An entity can only have one Primary UID. True or False?     Mark for Review

(1) Points

            True (*)

            False

13.       To resolve a 2nd Normal Form violation, we: Mark for Review

(1) Points

            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.

            Do nothing, an entity does not need to be in 2nd Normal Form.

            Delete the attribute that was causing the violation.

14.       Examine the following entity and decide how to make it conform to the rule of 2nd Normal Form:

ENTITY: RECEIPT

ATTRIBUTES:

   #CUSTOMER ID

   #STORE ID

   STORE LOCATION

   DATE

 Mark for Review

(1) Points

            Do nothing, it is already in 2nd Normal Form.

            Delete the attribute STORE ID

            Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE ID, and create a relationship to the original entity. (*)

            Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE LOCATION, and create a relationship to the original entity.

15.       Any Non-UID attribute must be dependent upon the entire UID. True or False?    Mark for Review

(1) Points

            True (*)

            False

1.         Which of the following would be suitable UIDs for the entity EMPLOYEE: (Choose Two)          Mark for Review

(1) Points

                                    (Choose all correct answers)  

            Social Security Number (*)

            Last Name

            Employee ID (*)

            Address

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

3.         A unique identifier can only be made up of one attribute. True or False?     Mark for Review

(1) Points

            True

            False (*)

4.         If an entity has no attribute suitable to be a Primary UID, we can create an artificial one. True or False?            Mark for Review

(1) Points

            True (*)

            False

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

 Mark for Review

(1) Points

            1st Normal Form. (*)

            2nd Normal Form.

            3rd Normal Form.

            None of the above, the entity is fully normalised.

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

7.         Examine the following Entity and decide which rule of Normal Form is being violated:

ENTITY: CLIENT

ATTRIBUTES:

    # CLIENT ID

    FIRST NAME

    LAST NAME

    STREET

    CITY

    ZIP CODE

 Mark for Review

(1) Points

            1st Normal Form.

            2nd Normal Form.

            3rd Normal Form.

            None of the above, the entity is fully normalised. (*)

8.         Examine the following Entity and decide which rule of Normal Form is being violated:

ENTITY: CLIENT ORDER

ATTRIBUTES:

    # CLIENT ID

    # ORDER ID

    FIRST NAME

    LAST NAME

    ORDER DATE

    CITY

    ZIP CODE

 Mark for Review

(1) Points

            1st Normal Form.

            2nd Normal Form. (*)

            3rd Normal Form.

            None of the above, the entity is fully normalised.

9.         Normalizing an Entity to 1st Normal Form is done by removing any attributes that contain muliple values. True or False?  Mark for Review

(1) Points

            True (*)

            False

10.       If an entity has a multi-valued attribute, to conform to the rule of 1st Normal Form we:     Mark for Review

(1) Points

            Do nothing, an entity does not have to be in 1st Normal Form

            Create an additional entity and relate it to the original entity with a M:M relationship.

            Make the attribute optional

            Create an additional entity and relate it to the original entity with a 1:M relationship. (*)

11.       An entity can have repeated values and still be in 1st Normal Form. True or False? Mark for Review

(1) Points

            True

            False (*)

12.       When data is only stored in one place in a database, the database conforms to the rules of ___________. Mark for Review

(1) Points

            Reduction

            Multiplication

            Normalization (*)

            Normality

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

            Delete the attribute that was causing the violation.

            Move the attribute that violates 2nd Normal Form to a new ERD.

            Move the attribute that violates 2nd Normal Form to a new entity with a relationship to the original entity. (*)

14.       Examine the following entity and decide how to make it conform to the rule of 2nd Normal Form:

ENTITY: RECEIPT

ATTRIBUTES:

   #CUSTOMER ID

   #STORE ID

   STORE LOCATION

   DATE

 Mark for Review

(1) Points

            Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE ID, and create a relationship to the original entity. (*)

            Do nothing, it is already in 2nd Normal Form.

            Delete the attribute STORE ID

            Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE LOCATION, and create a relationship to the original entity.

15.       Any Non-UID attribute must be dependent upon the entire UID. True or False?   

Mark for Review

(1) Points

            True (*)

            False

1.         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 (*)

2.         Examine the following Entity and decide which rule of Normal Form is being violated:

ENTITY: CLIENT

ATTRIBUTES:

    # CLIENT ID

    FIRST NAME

    LAST NAME

    STREET

    CITY

    ZIP CODE

 Mark for Review

(1) Points

            1st Normal Form.

            2nd Normal Form.

            3rd Normal Form.

            None of the above, the entity is fully normalised. (*)

3.         When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as:        Mark for Review

(1) Points

            Transitive dependency (*)

            Functional dependency

            Dependency

            Non-dependency

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

5.         An entity can only have one Primary UID. True or False?     Mark for Review

(1) Points

            True (*)

            False

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

            Yes, this is the way UID's are named. (*)

            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.

7.         Where an entity has more than one attribute suitable to be the Primary UID, these are known as _____________ UIDs.           Mark for Review

(1) Points

            Composite

            Simple

            Secondary

            Candidate (*)

8.         Which of the following would be suitable UIDs for the entity EMPLOYEE: (Choose Two)          Mark for Review

(1) Points

                                    (Choose all correct answers)  

            Address

            Employee ID (*)

            Social Security Number (*)

            Last Name

9.         Any Non-UID attribute must be dependent upon the entire UID. True or False?    Mark for Review

(1) Points

            True (*)

            False

10. What is the rule of Second Normal Form?           Mark for Review

(1) Points

            No non-UID attributes can be dependent on any part of the UID.

            Some non-UID attributes can be dependent on the entire UID.

            All non-UID attributes must be dependent upon the entire UID. (*)

            None of the above

11.       Examine the following entity and decide how to make it conform to the rule of 2nd Normal Form:

ENTITY: RECEIPT

ATTRIBUTES:

   #CUSTOMER ID

   #STORE ID

   STORE LOCATION

   DATE

 Mark for Review

(1) Points

            Delete the attribute STORE ID

            Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE LOCATION, and create a relationship to the original entity.

            Do nothing, it is already in 2nd Normal Form.

            Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE ID, and create a relationship to the original entity. (*)

12.       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 (*)

13.       An entity ORDER has the attributes Order ID, Order Date, Product id, Customer ID. This entity is in 1st Normal Form. True or False?        Mark for Review

(1) Points

            True

            False (*)

14.       An entity can have repeated values and still be in 1st Normal Form. True or False? Mark for Review

(1) Points

            True

            False (*)

15.       Normalizing an Entity to 1st Normal Form is done by removing any attributes that contain muliple values. True or False?  Mark for Review

(1) Points

            True (*)

            False

1.         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, 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.

            No, each Entity can only have one UID, the secondary one.

            Yes, this is the way UID's are named. (*)

2.         Where an entity has more than one attribute suitable to be the Primary UID, these are known as _____________ UIDs.           Mark for Review

(1) Points

            Secondary

            Composite

            Candidate (*)

            Simple

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

(1) Points

            True (*)

            False

4.         A candidate UID that is not chosen to be the Primary UID is called:           Mark for Review

(1) Points

            Composite

            Secondary (*)

            Simple

            Artificial

5.         What is the rule of Second Normal Form?     Mark for Review

(1) Points

            No non-UID attributes can be dependent on any part of the UID.

            Some non-UID attributes can be dependent on the entire UID.

            All non-UID attributes must be dependent upon the entire UID. (*)

            None of the above

6.         Examine the following entity and decide which attribute breaks the 2nd Normal Form rule:

ENTITY: RECEIPT

ATTRIBUTES:

   #CUSTOMER ID

   #STORE ID

   STORE LOCATION

   DATE

 Mark for Review

(1) Points

            STORE LOCATION (*)

            CUSTOMER ID

            DATE

            STORE ID

7.         When is an entity in 2nd Normal Form?         Mark for Review

(1) Points

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

            None of the Above.

8.         When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as:        Mark for Review

(1) Points

            Non-dependency

            Functional dependency

            Dependency

            Transitive dependency (*)

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

 Mark for Review

(1) Points

            1st Normal Form. (*)

            2nd Normal Form.

            3rd Normal Form.

            None of the above, the entity is fully normalised.

10.       Examine the following Entity and decide which rule of Normal Form is being violated:

ENTITY: CLIENT

ATTRIBUTES:

    # CLIENT ID

    FIRST NAME

    LAST NAME

    STREET

    CITY

    ZIP CODE

 Mark for Review

(1) Points

            1st Normal Form.

            2nd Normal Form.

            3rd Normal Form.

            None of the above, the entity is fully normalised. (*)

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

12.       Normalizing an Entity to 1st Normal Form is done by removing any attributes that contain muliple values. True or False?  Mark for Review

(1) Points

            True (*)

            False

13.       If an entity has a multi-valued attribute, to conform to the rule of 1st Normal Form we:     Mark for Review

(1) Points

            Make the attribute optional

            Do nothing, an entity does not have to be in 1st Normal Form

            Create an additional entity and relate it to the original entity with a M:M relationship.

            Create an additional entity and relate it to the original entity with a 1:M relationship. (*)

14.       When data is only stored in one place in a database, the database conforms to the rules of ___________. Mark for Review

(1) Points

            Multiplication

            Normality

            Reduction

            Normalization (*)

15.       An entity ORDER has the attributes Order ID, Order Date, Product id, Customer ID. This entity is in 1st Normal Form. True or False?        Mark for Review

(1) Points

            True

            False (*)