DATABASE DESIGN ENGLISH SECTION 7

Section 7 Quiz
                (Answer all questions in this section)

1.            Which of the following would best be represented by an arc?    Mark for Review
(1) Points
                STUDENT (senior, male)
                STUDENT (Grade A student, Average Student)
                STUDENT (graduating, female)
                STUDENT ( University, Technical College) (*)

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

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

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

5.            Which of the following would best be represented by an arc?    Mark for Review
(1) Points
                TEACHER (Female, Bob)
                PARENT (Girl, Bob)
                DELIVERY ADDRESS (Home, Office) (*)
                STUDENT (Grade A student, Average Student)

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

7.            Every business has restrictions on which attribute values and which relationships are allowed. These are known as:           Mark for Review
(1) Points
                Constraints. (*)
                Relationships
                Entities.
                Attributes

8.            Arcs are used to visually represent _________ between two or more relationships in an ERD.   Mark for Review
(1) Points
                Differences
                Inheritance
                Sameness
                Exclusivity (*)

9.            Cascading UIDs are a feature often found in what type of Relationship? Mark for Review
(1) Points
                Invalid Relationship
                Recursive Relationship
                General Relationship
                Heirarchical Relationship (*)

10.          A relationship between an entity and itself is called a/an:             Mark for Review
(1) Points
                Recursive Relationship (*)
                Invalid Relationship
                Heirarchical Relationship
                General Relationship

11.          A Recursive Relationship is represented on an ERD by a/an:         Mark for Review
(1) Points
                Single Toe
                Pig's Ear (*)
                Crow's Foot
                Dog's Tail

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

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

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

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

1.            A particular problem may be solved using either a Recursive Relationship or a Hierarchical Relationship, though not at the same time. True or False?       Mark for Review
(1) Points
                True (*)
                False

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

3.            A Recursive Relationship is represented on an ERD by a/an:         Mark for Review
(1) Points
                Single Toe
                Dog's Tail
                Pig's Ear (*)
                Crow's Foot

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

5.            A relationship between an entity and itself is called a/an:             Mark for Review
(1) Points
                General Relationship
                Recursive Relationship (*)
                Heirarchical Relationship
                Invalid Relationship

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

7.            Cascading UIDs are a feature often found in what type of Relationship? Mark for Review
(1) Points
                Recursive Relationship
                General Relationship
                Invalid Relationship
                Heirarchical Relationship (*)

8. Which of the following would best be represented by an arc?                Mark for Review
(1) Points
                STUDENT (senior, male)
                STUDENT ( University, Technical College) (*)
                STUDENT (Grade A student, Average Student)
                STUDENT (graduating, female)

9.            To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________.         Mark for Review
(1) Points
                Relationship
                Arc (*)
                UID
                Attribute

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

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

12.          Arcs are used to visually represent _________ between two or more relationships in an ERD.   Mark for Review
(1) Points
                Sameness
                Differences
                Exclusivity (*)
                Inheritance

13.          Which of the following can be added to a relationship?  Mark for Review
(1) Points
                An optional attribute can be created
                A composite attribute
                An attribute
                An arc can be assigned (*)

14.          Which of the following would best be represented by an arc?    Mark for Review
(1) Points
                TEACHER (Female, Bob)
                STUDENT (Grade A student, Average Student)
                DELIVERY ADDRESS (Home, Office) (*)
                PARENT (Girl, Bob)

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

1.            A relationship between an entity and itself is called a/an:             Mark for Review
(1) Points
                Invalid Relationship
                Recursive Relationship (*)
                General Relationship
                Heirarchical Relationship

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

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

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

5.            A particular problem may be solved using either a Recursive Relationship or a Hierarchical Relationship, though not at the same time. True or False?       Mark for Review
(1) Points
                True (*)
                False

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

7.            A Recursive Relationship is represented on an ERD by a/an:         Mark for Review
(1) Points
                Single Toe
                Pig's Ear (*)
                Crow's Foot
                Dog's Tail

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

9.            Every business has restrictions on which attribute values and which relationships are allowed. These are known as:           Mark for Review
(1) Points
                Attributes
                Constraints. (*)
                Entities.
                Relationships

10.          Which of the following would best be represented by an arc?    Mark for Review
(1) Points
                TEACHER (Female, Bob)
                DELIVERY ADDRESS (Home, Office) (*)
                PARENT (Girl, Bob)
                STUDENT (Grade A student, Average Student)

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

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

13.          To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________.         Mark for Review
(1) Points
                Attribute
                Relationship
                UID
                Arc (*)

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

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

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

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

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

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)

5.            To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________.         Mark for Review
(1) Points
                UID
                Arc (*)
                Attribute
                Relationship

6.            Which of the following would best be represented by an arc?    Mark for Review
(1) Points
                STUDENT (graduating, female)
                STUDENT ( University, Technical College) (*)
                STUDENT (Grade A student, Average Student)
                STUDENT (senior, male)

7.            Arcs are used to visually represent _________ between two or more relationships in an ERD.   Mark for Review
(1) Points
                Exclusivity (*)
                Differences
                Inheritance
                Sameness

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

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

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

11.          Cascading UIDs are a feature often found in what type of Relationship? Mark for Review
(1) Points
                Recursive Relationship
                General Relationship
                Heirarchical Relationship (*)
                Invalid Relationship

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

13.          A Recursive Relationship is represented on an ERD by a/an:         Mark for Review
(1) Points
                Crow's Foot
                Single Toe
                Pig's Ear (*)
                Dog's Tail

14.          A particular problem may be solved using either a Recursive Relationship or a Hierarchical Relationship, though not at the same time. True or False?       Mark for Review
(1) Points
                True (*)
                False

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

                False