Databases Design Section 7

1.  Cascading UIDs are a feature often found in what type of Relationship?
Mark for Review (1) Point
Heirarchical Relationship (*)
Recursive Relationship
Invalid Relationship
General Relationship
2.  A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False?
Mark for Review (1) Point
True (*)
False
3.  A relationship between an entity and itself is called a/an:
Mark for Review (1) Point
General Relationship
Invalid Relationship
Recursive Relationship (*)
Heirarchical Relationship
4.  A single relationship can be both Recursive and Hierarchical at the same time. True or False?
Mark for Review (1) Point
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) Point
True (*)
False
6.  Business organizational charts are often modeled as a Hierarchical relationship. True or False?
Mark for Review (1) Point
True (*)
False
7.  A recursive relationship must be Mandatory at both ends. True or False?
Mark for Review (1) Point
True
False(*)
8.  Arcs are used to visually represent _________ between two or more relationships in an ERD.
Mark for Review (1) Point
Sameness Differences
Exclusivity (*) Inheritance
9.  Which of the following would best be represented by an arc?
Mark for Review (1) Point
STUDENT (graduating, female)
STUDENT (senior, male)
STUDENT (Grade A student, Average Student)

STUDENT ( University, Technical College) (*)
10.  An arc can often be modeled as Supertype and Subtypes. True or False?
Mark for Review (1) Point
True (*)
False
11.  Which of the following would best be represented by an arc?

Mark for Review (1) Point
TEACHER (Female, Bob) DELIVERY ADDRESS (Home, Office) (*)
STUDENT (Grade A student, Average Student) PARENT (Girl, Bob)
12.  Arcs model an Exclusive OR constraint. True or False?
Mark for Review (1) Point
True (*)
False
13.  Every business has restrictions on which attribute values and which relationships are allowed. These are known as:
Mark for Review (1) Point
Attributes
Entities.
Relationships
Constraints. (*)
14.  All relationships participating in an arc must be mandatory. True or False?
Mark for Review (1) Point
True
False (*)
15.  Arcs are Mandatory in Data modeling. All ERD's must have at least one Arc. True or False?
Mark for Review (1) Point
True
False (*)

1.  A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False?
Mark for Review (1) Point
True(*)
False
2.  Business organizational charts are often modeled as a Hierarchical relationship. True or False?
Mark for Review (1) Point
True(*)
False
3.  A single relationship can be both Recursive and Hierarchical at the same time. True or False?
Mark for Review (1) Point
True
False(*)
4.  A Recursive Relationship is represented on an ERD by a/an:
 Mark for Review (1) Point
Pig’s Ear(*)
Single Toe
Crow’s Foot
Dog’s Tail
5.  Cascading UIDs are a feature often found in what type of Relationship?
Mark for Review (1) Point

Invalid Relationship
General Relationship
Heirarchical Relationship(*)
Recursive Relationship

6.  A relationship between an entity and itself is called a/an:
Mark for Review (1) Point
Invalid Relationship
General Relationship
Heirarchical Relationship
Recursive Relationship(*)
7.  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) Point
True
False(*)
8.  Arcs model an Exclusive OR constraint. True or False?
Mark for Review (1) Point
True(*)
False
9.  Every business has restrictions on which attribute values and which relationships are allowed. These are known as:
Mark for Review (1) Point
Constraints. (*)
Relationships
Entities
Attributes
10.  Which of the following would best be represented by an arc?
Mark for Review (1) Point
TEACHER (Female, Bob) PARENT (Girl, Bob)
DELIVERY ADDRESS (Home, Office) (*) STUDENT (Grade A student, Average Student)
11.  Arcs are used to visually represent _________ between two or more relationships in an ERD.
Mark for Review (1) Point
Inheritance
Exclusivity (*)
Differences
Sameness
12.  All relationships participating in an arc must be mandatory. True or False?
Mark for Review (1) Point
True
False(*)
13.  Which of the following would best be represented by an arc?

STUDENT ( University, Technical College) (*)
14.  Which of the following can be added to a relationship?
An arc can be assigned (*)
15.  An arc can often be modeled as Supertype and Subtypes. True or False?

Mark for Review (1) Point
True(*)
False