Section 7
Arcs model an Exclusive OR
constraint. True or False?
True
(*)
False
Which of the following would
best be represented by an arc?
PARENT
(Girl, Bob)
DELIVERY
ADDRESS (Home, Office) (*)
STUDENT
(Grade A student, Average Student)
TEACHER
(Female, Bob)
All relationships participating
in an arc must be mandatory. True or False?
True
False
(*)
Every business has restrictions
on which attribute values and which relationships are allowed. These are known
as:
Entities.
Attributes
Constraints.
(*)
Relationships
Which of the following can be
added to a relationship?
An
optional attribute can be created
An
attribute
An arc
can be assigned (*)
A
composite attribute
Arcs are Mandatory in Data modeling. All ERD's must have at
least one Arc. True or False?
True
False
(*)
To visually represent
exclusivity between two or more relationships in an ERD you would most likely
use an ________.
Attribute
Relationship
UID
Arc (*)
Arcs are used to visually
represent _________ between two or more relationships in an ERD.
Sameness
Inheritance
Differences
Exclusivity
(*)
A particular problem may be
solved using either a Recursive Relationship or a Hierarchical Relationship,
though not at the same time. True or False?
True
(*)
False
A single relationship can be both
Recursive and Hierarchical at the same time. True or False?
True
False
(*)
Cascading UIDs are a feature often found in what type of
Relationship?
General
Relationship
Recursive
Relationship
Invalid
Relationship
Heirarchical
Relationship (*)
Business organizational charts
are often modeled as a Hierarchical relationship. True or False?
True
(*)
False
A Recursive Relationship is
represented on an ERD by a/an:
Pig's
Ear (*)
Crow's
Foot
Single
Toe
Dog's
Tail
A recursive relationship must be
Mandatory at both ends. True or False?
True
False
(*)
A Hierarchical relationship is a
series of relationships that reflect entities organized into successive levels.
True or False?
True
(*)
False
No comments:
Post a Comment