(1) Points
(Choose all correct answers)
Entities
Attributes (*)
Synonyms
Relationships (*)
Correct Correct
2. A unique identifier can only be made up of one attribute. True or False? Mark for Review
(1) Points
True
False (*)
Correct Correct
3. 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 (*)
Social Security Number (*)
Address
Last Name
Correct Correct
4. An entity can only have one Primary UID. True or False? Mark for Review
(1) Points
True (*)
False
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 (*)
Correct Correct
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. When data is stored in more than one place in a database, the database violates the rules of ___________. Mark for Review
(1) Points
Decency
Normalcy
Replication
Normalization (*)
Correct Correct
8. 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
9. 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.
10. 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.
Correct Correct
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
Correct Correct
12. 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 (*)
Dependency
Non-dependency
Functional dependency
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. 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.
Correct Correct
15. 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
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 (*)
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
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
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
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
0 komentar:
Posting Komentar