Test Bank - Database Systems: Design, Implementation, and
Management (13th Edition) by Coronel & Morris COMPLETE
QUESTIONS AND CORRECT DETAILED ANSWERS (VERIFIED
ANSWERS) |ALREADY GRADED A+||BRAND NEW!!!!
Data modeling may be data characteristics are important in the design of
the most important part programs and other systems components.
of the systems
development process
because:
The logical representation entity-relationship model.
of an organization's data
is called a(n):
The common types of strong entities, weak entities, and associative entities(all of
entities are: the above)
In an E-R diagram, there two
are business
rule(s) for every
relationship.
An attribute that can be derived
calculated from related
attribute values is called a(n)
________ attribute.
The total quiz points for a derived
student for an entire
semester is a(n)
________________ attribu
te
Choose an identifier that
Which of the following criteria
is stable. Choose an
should be considered when
identifier that will not be
selecting an identifier?
null.
Choose an identifier that doesn't have large composite attributes.
, (All of the above)
composite identifier
An attribute that uniquely
identifies an entity and
consists of a composite
attribute is called a(n):
associative entity
An entity that associates the
instances of one or more
entity types and contains
attributes specific to the
relationships is called a(n):
All the relationships for
Which of the following
the participating entities
conditions should exist if an
are many-to-many. The
associative entity is to be
new associative entity has
created?
independent meaning.
The new associative
entity participates in
independent
relationships. (all of the
above)
,The number of entity types degree
that participate in a
relationship is called the:
A relationship between the unary
instances of a single entity
type is called a(n) ________
relationship
A student can attend five many-to-many
classes, each with a different
professor. Each professor
has 30 students. The
relationship of students to
professors is a
___________ relationship.
In the following diagram, what
type of relationship is depicted?
Ternary
It depicts a unary relationship. In the following diagram, which is true?
It depicts a many-to-many
relationship. There is an
associative entity.
(All of the above)
A ___ specifies the number of cardinality constraint
instances
of one entity that can be
associated with each
instance of another
entity.
A simultaneous relationship ternary
among the instances of three
entity types is called a(n)
_ _ relationship.
In the figure shown below,
which of the following is true?
A person can marry at most
one person.
A relationship where the mandatory one
minimum and maximum
, cardinality are both one is a(n)
_ _ relationship.
For the relationship represented
A department can have more in the figure below, which of the
than one employee. following is true?
Each patient has one or more In the following diagram,
patient histories. which of the answers below is
Each patient history true?
belongs to one and only
one patient. (both A and
C)
Each vendor can supply many In the figure shown below,
parts to any number of which of the following
warehouses, but need not business rules would
supply any parts. apply?
A value that indicates the time stamp.
date or time of a data value is
called a(n):
In the following diagram,
Each employee can supervise which answer is true?
one to many employees
Management (13th Edition) by Coronel & Morris COMPLETE
QUESTIONS AND CORRECT DETAILED ANSWERS (VERIFIED
ANSWERS) |ALREADY GRADED A+||BRAND NEW!!!!
Data modeling may be data characteristics are important in the design of
the most important part programs and other systems components.
of the systems
development process
because:
The logical representation entity-relationship model.
of an organization's data
is called a(n):
The common types of strong entities, weak entities, and associative entities(all of
entities are: the above)
In an E-R diagram, there two
are business
rule(s) for every
relationship.
An attribute that can be derived
calculated from related
attribute values is called a(n)
________ attribute.
The total quiz points for a derived
student for an entire
semester is a(n)
________________ attribu
te
Choose an identifier that
Which of the following criteria
is stable. Choose an
should be considered when
identifier that will not be
selecting an identifier?
null.
Choose an identifier that doesn't have large composite attributes.
, (All of the above)
composite identifier
An attribute that uniquely
identifies an entity and
consists of a composite
attribute is called a(n):
associative entity
An entity that associates the
instances of one or more
entity types and contains
attributes specific to the
relationships is called a(n):
All the relationships for
Which of the following
the participating entities
conditions should exist if an
are many-to-many. The
associative entity is to be
new associative entity has
created?
independent meaning.
The new associative
entity participates in
independent
relationships. (all of the
above)
,The number of entity types degree
that participate in a
relationship is called the:
A relationship between the unary
instances of a single entity
type is called a(n) ________
relationship
A student can attend five many-to-many
classes, each with a different
professor. Each professor
has 30 students. The
relationship of students to
professors is a
___________ relationship.
In the following diagram, what
type of relationship is depicted?
Ternary
It depicts a unary relationship. In the following diagram, which is true?
It depicts a many-to-many
relationship. There is an
associative entity.
(All of the above)
A ___ specifies the number of cardinality constraint
instances
of one entity that can be
associated with each
instance of another
entity.
A simultaneous relationship ternary
among the instances of three
entity types is called a(n)
_ _ relationship.
In the figure shown below,
which of the following is true?
A person can marry at most
one person.
A relationship where the mandatory one
minimum and maximum
, cardinality are both one is a(n)
_ _ relationship.
For the relationship represented
A department can have more in the figure below, which of the
than one employee. following is true?
Each patient has one or more In the following diagram,
patient histories. which of the answers below is
Each patient history true?
belongs to one and only
one patient. (both A and
C)
Each vendor can supply many In the figure shown below,
parts to any number of which of the following
warehouses, but need not business rules would
supply any parts. apply?
A value that indicates the time stamp.
date or time of a data value is
called a(n):
In the following diagram,
Each employee can supervise which answer is true?
one to many employees
