Answer Oracle Design Quiz 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

1. This diagram could also be expressed as a supertype/subtype construction. True or False?

True
False

2. If the entity CD has the attributes: #number, *title, *producer, *year, o store name, o store address, this entity is in 3rd Normal Form (”no non-UID attribute can be dependent on another non-UID attribute). True or False?

True
False

3. Which of the following can be added to a relationship?

an attribute
an arc can be assigned
a composite attribute
an optional attribute can be created

4. Which of the following would best be represented by an arc?

STUDENT (senior, junior)
STUDENT (graduating, non-graduating)
STUDENT (will-attend-university, will-not-attend-university)
STUDENT ( University, Trade School)

5. All parts of a UID are mandatory. True or False?

True
False

6. Which of the following is the definition for Third Normal Form?

All attributes are single valued
An attribute must be dependent upon entity’s entire unique identifier
No non-UID attribute can be dependent on another non-UID attribute
All attributes are uniquely doubled and independent

7. To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________.

Arc
UID
Subtype
Supertype

8. Secondary UID’s are

not permitted in data modeling
mandatory in data modeling
useful as an alternative means identifying instances of an entity
always comprised of numbers

Test: Quiz: Hierarchies and Recursive Relationships

1. Which of the following would be a good Unique Identifier for its Entity? (Choose Two)

Identification Number for Person
Birthdate for Baby Which Includes Hour, Minute, and Seconds
Order date for Order
Vehicle Type Number for Car

2. A relationship can be both recursive and hierachal at the same time. True or False?

True
False

3. A recursive rationship should not be part of a UID. True or False?

True
False

4. In this simple diagram, what comprises the unique identifier for the student class entity?

student id and class id
student id, class id and course id
course id
student id and course id

Test: Quiz: Modeling Historical Data

1. Which of the following scenarios should be modeled so that historical data is kept? (Choose two)

LIBRARY and BOOK
STUDENT and AGE
STUDENT and GRADE
LIBRARY and NUMBER OF STAFF

2. Modeling historical data can produce a unique identifier that includes a date. True or False?

True
False

3. Audit trail attributes cannot be placed in the entities they are auditing, they must be placed in separate, new entities, created just for that purpose. True or False?

True
False

4. Historical data should always be kept. True or False?

True
False

 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