Database Design-Section 7 Quiz

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

Section 7 Quiz
(Answer all questions in this section)

1. A single relationship can be both Recursive and Hierarchical at the same time. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


2. A Recursive Relationship is represented on an ERD by a/an: Mark for Review
(1) Points


Single Toe


Dog's Tail


Crow's Foot


Pig's Ear (*)



Incorrect Incorrect. Refer to Section 7 Lesson 2.


3. A relationship between an entity and itself is called a/an: Mark for Review
(1) Points


Invalid Relationship


Heirarchical Relationship


Recursive Relationship (*)


General Relationship



Incorrect Incorrect. Refer to Section 7 Lesson 2.


4. Business organizational charts are often modeled as a Hierarchical relationship. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


5. A recursive relationship must be Mandatory at both ends. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


Page 1 of 3 Next Summary


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

Section 7 Quiz
(Answer all questions in this section)

6. Cascading UIDs are a feature often found in what type of Relationship? Mark for Review
(1) Points


Recursive Relationship


Invalid Relationship


Heirarchical Relationship (*)


General Relationship



Incorrect Incorrect. Refer to Section 7 Lesson 2.


7. A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


8. All relationships participating in an arc must be mandatory. True or False? Mark for Review
(1) Points


True


False (*)



Incorrect Incorrect. Refer to Section 7 Lesson 1.


9. Which of the following can be added to a relationship? Mark for Review
(1) Points


An arc can be assigned (*)


An optional attribute can be created


An attribute


A composite attribute



Incorrect Incorrect. Refer to Section 7 Lesson 1.


10. To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________. Mark for Review
(1) Points


Arc (*)


Relationship


Attribute


UID



Correct Correct


Previous Page 2 of 3 Next Summary


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

Section 7 Quiz
(Answer all questions in this section)

11. Which of the following would best be represented by an arc? Mark for Review
(1) Points


STUDENT (Grade A student, Average Student)


STUDENT ( University, Technical College) (*)


STUDENT (graduating, female)


STUDENT (senior, male)



Correct Correct


12. An arc can often be modeled as Supertype and Subtypes. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


13. Which of the following would best be represented by an arc? Mark for Review
(1) Points


PARENT (Girl, Bob)


DELIVERY ADDRESS (Home, Office) (*)


TEACHER (Female, Bob)


STUDENT (Grade A student, Average Student)



Incorrect Incorrect. Refer to Section 7 Lesson 1.


14. Arcs are Mandatory in Data modeling. All ERD's must have at least one Arc. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


15. Arcs are used to visually represent _________ between two or more relationships in an ERD. Mark for Review
(1) Points


Inheritance


Exclusivity (*)


Sameness


Differences



Incorrect Incorrect. Refer to Section 7 Lesson 1.


Previous Page 3 of 3 Summary


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

Section 7 Quiz
(Answer all questions in this section)

1. An arc can often be modeled as Supertype and Subtypes. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


2. Which of the following would best be represented by an arc? Mark for Review
(1) Points


STUDENT (graduating, female)


STUDENT (senior, male)


STUDENT (Grade A student, Average Student)


STUDENT ( University, Technical College) (*)



Correct Correct


3. To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________. Mark for Review
(1) Points


Attribute


Arc (*)


UID


Relationship



Correct Correct


4. Which of the following would best be represented by an arc? Mark for Review
(1) Points


STUDENT (Grade A student, Average Student)


TEACHER (Female, Bob)


DELIVERY ADDRESS (Home, Office) (*)


PARENT (Girl, Bob)



Correct Correct


5. Arcs are used to visually represent _________ between two or more relationships in an ERD. Mark for Review
(1) Points


Sameness


Inheritance


Differences


Exclusivity (*)



Correct Correct


Page 1 of 3 Next Summary


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

Section 7 Quiz
(Answer all questions in this section)

6. Arcs model an Exclusive OR constraint. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


7. Which of the following can be added to a relationship? Mark for Review
(1) Points


An arc can be assigned (*)


An attribute


An optional attribute can be created


A composite attribute



Correct Correct


8. Every business has restrictions on which attribute values and which relationships are allowed. These are known as: Mark for Review
(1) Points


Entities.


Attributes


Relationships


Constraints. (*)



Incorrect Incorrect. Refer to Section 7 Lesson 1.


9. A recursive relationship must be Mandatory at both ends. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


10. A Recursive Relationship is represented on an ERD by a/an: Mark for Review
(1) Points


Pig's Ear (*)


Single Toe


Crow's Foot


Dog's Tail



Correct Correct


Previous Page 2 of 3 Next Summary


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

Section 7 Quiz
(Answer all questions in this section)

11. A single relationship can be both Recursive and Hierarchical at the same time. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


12. Cascading UIDs are a feature often found in what type of Relationship? Mark for Review
(1) Points


General Relationship


Heirarchical Relationship (*)


Invalid Relationship


Recursive Relationship



Correct Correct


13. A relationship between an entity and itself is called a/an: Mark for Review
(1) Points


Recursive Relationship (*)


Invalid Relationship


Heirarchical Relationship


General Relationship



Correct Correct


14. A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


15. Business organizational charts are often modeled as a Hierarchical relationship. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


Previous Page 3 of 3 Summary