Database Design-Section 6 Quiz

Test: Section 6 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 6 Quiz
(Answer all questions in this section)

1.  Any Non-UID attribute must be dependent upon the entire UID. True or False?  Mark for Review
(1) Points


True (*)


False



Correct Correct


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


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.



Incorrect Incorrect. Refer to Section 6 Lesson 3.


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



Correct Correct


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



Incorrect Incorrect. Refer to Section 6 Lesson 2.


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



Incorrect Incorrect. Refer to Section 6 Lesson 2.


Page 1 of 3 Next Summary


Test: Section 6 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 6 Quiz
(Answer all questions in this section)

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



Correct Correct


7.  When all attributes are single-valued, the database model is said to conform to:  Mark for Review
(1) Points


3rd Normal Form


4th Normal Form


2nd Normal Form


1st Normal Form (*)



Correct Correct


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



Incorrect Incorrect. Refer to Section 6 Lesson 4.


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



Incorrect Incorrect. Refer to Section 6 Lesson 4.


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.



Incorrect Incorrect. Refer to Section 6 Lesson 4.


Previous Page 2 of 3 Next Summary


Test: Section 6 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 6 Quiz
(Answer all questions in this section)

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



Correct Correct


12.  A unique identifier can only be made up of one attribute. True or False?  Mark for Review
(1) Points


True


False (*)



Correct Correct


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


Simple


Candidate (*)



Incorrect Incorrect. Refer to Section 6 Lesson 1.


14.  A candidate UID that is not chosen to be the Primary UID is called:  Mark for Review
(1) Points


Simple


Secondary (*)


Artificial


Composite



Incorrect Incorrect. Refer to Section 6 Lesson 1.


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



Correct Correct


Previous Page 3 of 3 Summary


Test: Section 6 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 6 Quiz
(Answer all questions in this section)

1. Any Non-UID attribute must be dependent upon the entire UID. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


2. 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 LOCATION, and create a relationship to the original entity.


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



Correct Correct


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


DATE


STORE ID


STORE LOCATION (*)


CUSTOMER ID



Incorrect Incorrect. Refer to Section 6 Lesson 3.


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


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



Correct Correct


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



Incorrect Incorrect. Refer to Section 6 Lesson 2.


Page 1 of 3 Next Summary


Test: Section 6 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 6 Quiz
(Answer all questions in this section)

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


True


False (*)



Correct Correct


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



Correct Correct


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.



Incorrect Incorrect. Refer to Section 6 Lesson 4.


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



Correct Correct


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



Correct Correct


Previous Page 2 of 3 Next Summary


Test: Section 6 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 6 Quiz
(Answer all questions in this section)

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



Incorrect Incorrect. Refer to Section 6 Lesson 4.


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

(Choose all correct answers)


Last Name


Social Security Number (*)


Address


Employee ID (*)



Incorrect Incorrect. Refer to Section 6 Lesson 1.


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



Correct Correct


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



Incorrect Incorrect. Refer to Section 6 Lesson 1.


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



Correct Correct


Previous Page 3 of 3 Summary



Test: Section 6 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 6 Quiz
(Answer all questions in this section)

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



Correct Correct


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


True


False (*)



Correct Correct


3. When data is only stored in one place in a database, the database conforms to the rules of ___________. Mark for Review
(1) Points


Normalization (*)


Multiplication


Reduction


Normality



Correct Correct


4. When data is stored in more than one place in a database, the database violates the rules of ___________. Mark for Review
(1) Points


Replication


Normalcy


Decency


Normalization (*)



Correct Correct


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.



Incorrect Incorrect. Refer to Section 6 Lesson 4.


Page 1 of 3 Next Summary



Test: Section 6 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 6 Quiz
(Answer all questions in this section)

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



Correct Correct


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.



Incorrect Incorrect. Refer to Section 6 Lesson 4.


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



Correct Correct


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



Correct Correct


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

(Choose all correct answers)


Employee ID (*)


Last Name


Social Security Number (*)


Address



Incorrect Incorrect. Refer to Section 6 Lesson 1.


Previous Page 2 of 3 Next Summary



Test: Section 6 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 6 Quiz
(Answer all questions in this section)

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


True


False (*)



Correct Correct


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



Correct Correct


13. Any Non-UID attribute must be dependent upon the entire UID. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


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


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


Delete the attribute that was causing the violation.



Incorrect Incorrect. Refer to Section 6 Lesson 3.


15. 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 LOCATION, 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 ID, and create a relationship to the original entity. (*)



Correct Correct


Previous Page 3 of 3 Summary


Test: Section 6 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 6 Quiz
(Answer all questions in this section)

1. To resolve a 2nd Normal Form violation, we: Mark for Review
(1) Points


Delete the attribute that was causing the violation.


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.



Correct Correct


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


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.



Correct Correct


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


TEACHER ID


CLASS ID


SUBJECT


TEACHER NAME AND ADDRESS (*)



Incorrect Incorrect. Refer to Section 6 Lesson 3.


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



Correct Correct


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



Incorrect Incorrect. Refer to Section 6 Lesson 4.


Page 1 of 3 Next Summary


Test: Section 6 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 6 Quiz
(Answer all questions in this section)

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



Correct Correct


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



Correct Correct


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


Candidate (*)


Composite


Simple


Secondary



Correct Correct


9. People are not born with 'numbers', but a lot of systems assign student numbers, customer IDs, etc. ﾠThese are known as a/an ______________ UID. Mark for Review
(1) Points


Artificial (*)


Structured


Identification


Unrealistic



Correct Correct


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



Correct Correct


Previous Page 2 of 3 Next Summary


Test: Section 6 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 6 Quiz
(Answer all questions in this section)

11. 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, after UIDs are first sorted, the first one is called the Primary UID, the second is the Secondary UID, etc.


No, it is not possible to have more than one UID for an Entity.


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


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



Incorrect Incorrect. Refer to Section 6 Lesson 1.


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



Correct Correct


13. When data is stored in more than one place in a database, the database violates the rules of ___________. Mark for Review
(1) Points


Normalization (*)


Decency


Normalcy


Replication



Correct Correct


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



Correct Correct


15. When all attributes are single-valued, the database model is said to conform to: Mark for Review
(1) Points


1st Normal Form (*)


3rd Normal Form


4th Normal Form


2nd Normal Form



Correct Correct


Previous Page 3 of 3 Summary