Database Systems: A Practical Approach to Design,
Implementation, and Management (6th Edition, by
Thomas Connolly) - Complete Test Bank
a strong entity and its associated weak entity -answers
A(n) ________ is the relationship between a weak entity type and its owner. -answers
identifying relationship
An entity type name should be all of the following EXCEPT -answers as short as
possible
A property or characteristic of an entity type that is of interest to the organization is
called a(n): -answers attribute
An attribute that must have a value for every entity (or relationship) instance is a(n): -
answers required attribute
A person's name, birthday, and social security number are all examples of -answers
attributes
An attribute of an entity that must have a value for each entity instance is a(n): -answers
required attribute
An attribute that can be broken down into smaller parts is called a(n) ________ attribute
-answers composite
a composite attribute -answers The address attribute is
multivalued attribute -answers The skill attribute is
derived -answers The years employed attribute is
An attribute that can be calculated from related attribute values is called a(n) ________
attribute. -answers derived
The total quiz points for a student for an entire semester is a(n) ________ attribute -
answers derived
Which of the following criteria should be considered when selecting an identifier? -
answers Choose an identifier that is stable.
Choose an identifier that will not be null.
Choose an identifier that doesn't have large composite attributes. (All of the above)
,An attribute that uniquely identifies an entity and consists of a composite attribute is
called a(n): -answers composite identifier
An entity that associates the instances of one or more entity types and contains
attributes specific to the relationships is called a(n): -answers associative entity
Which of the following conditions should exist if an associative entity is to be created? -
answers All the relationships for the participating entities are many-to-many.
The new associative entity has independent meaning.
The new associative entity participates in independent relationships. (all of the above)
The number of entity types that participate in a relationship is called the: -answers
degree
A relationship between the instances of a single entity type is called a(n) ________
relationship -answers unary
A student can attend five classes, each with a different professor. Each professor has
30 students. The relationship of students to professors is a ________ relationship. -
answers many-to-many
Ternary -answers In the following diagram, what type of relationship is depicted?
It depicts a unary relationship.
It depicts a many-to-many relationship.
There is an associative entity.
(All of the above) -answers In the following diagram, which is true?
A ________ specifies the number of instances of one entity that can be associated with
each instance of another entity. -answers cardinality constraint
A simultaneous relationship among the instances of three entity types is called a(n)
________ relationship. -answers ternary
A person can marry at most one person. -answers In the figure shown below, which of
the following is true?
A relationship where the minimum and maximum cardinality are both one is a(n)
________ relationship. -answers mandatory one
A department can have more than one employee. -answers For the relationship
represented in the figure below, which of the following is true?
Each patient has one or more patient histories.
Each patient history belongs to one and only one patient. (both A and C) -answers In
the following diagram, which of the answers below is true?
,Each vendor can supply many parts to any number of warehouses, but need not supply
any parts. -answers In the figure shown below, which of the following business rules
would apply?
A value that indicates the date or time of a data value is called a(n): -answers time
stamp.
Each employee can supervise one to many employees -answers In the following
diagram, which answer is true?
A mutually exclusive relationship is one in which: -answers an entity instance can
participate in only one of several alternative relationships.
Most systems developers believe that data modeling is the least important part of the
systems development process. -answers FALSE
Data, rather than processes, are the most complex aspects of many modern information
systems -answers TRUE
The E-R model is used to construct a conceptual model. -answers TRUE
In an E-R diagram, strong entities are represented by double-walled rectangles. -
answers FALSE
In an E-R diagram, an associative entity is represented by a rounded rectangle. -
answers TRUE
Data modeling is about documenting rules and policies of an organization that govern
data. -answers TRUE
One of the roles of a database analyst is to identify and understand rules that govern
data. -answers TRUE
The purpose of data modeling is to document business rules about processes. -answers
FALSE
A business rule is a statement that defines or constrains some aspect of the business. -
answers TRUE
The intent of a business rule is to break down business structure -answers FALSE
Enforcement of business rules can be automated through the use of software tools that
can interpret the rules and enforce them. -answers TRUE
, When systems are automatically generated and maintained, quality is diminished. -
answers FALSE
A business rule is a statement of how a policy is enforced or conducted. -answers
FALSE
While business rules are not redundant, a business rule can refer to another business
rule. -answers TRUE
A business rule should be internally consistent. -answers TRUE
Business rules are formulated from a collection of business ramblings. -answers FALSE
Data names should always relate to business characteristics. -answers TRUE
Data names do not have to be unique. -answers FALSE
An example of a term would be the following sentence: "A student registers for a
course." -answers FALSE
A fact is an association between two or more terms. -answers TRUE
A good data definition is always accompanied by diagrams, such as the entity-
relationship diagram. -answers TRUE
An entity is a person, place, object, event, or concept in the user environment about
which the organization wishes to maintain data. -answers TRUE
A single occurrence of an entity is called an entity instance. -answers TRUE
The relationship between a weak entity type and its owner is an identifying relationship.
-answers TRUE
An entity type on which a strong entity is dependent is called a covariant entity. -
answers FALSE
An entity type name should always be a singular noun. -answers TRUE
The name used for an entity type should never be the same in other E-R diagrams on
which the entity appears. -answers FALSE
Some examples of attributes are: eye_color, weight, student_id, student. -answers
FALSE
A simple attribute can be broken down into smaller pieces. -answers FALSE
Implementation, and Management (6th Edition, by
Thomas Connolly) - Complete Test Bank
a strong entity and its associated weak entity -answers
A(n) ________ is the relationship between a weak entity type and its owner. -answers
identifying relationship
An entity type name should be all of the following EXCEPT -answers as short as
possible
A property or characteristic of an entity type that is of interest to the organization is
called a(n): -answers attribute
An attribute that must have a value for every entity (or relationship) instance is a(n): -
answers required attribute
A person's name, birthday, and social security number are all examples of -answers
attributes
An attribute of an entity that must have a value for each entity instance is a(n): -answers
required attribute
An attribute that can be broken down into smaller parts is called a(n) ________ attribute
-answers composite
a composite attribute -answers The address attribute is
multivalued attribute -answers The skill attribute is
derived -answers The years employed attribute is
An attribute that can be calculated from related attribute values is called a(n) ________
attribute. -answers derived
The total quiz points for a student for an entire semester is a(n) ________ attribute -
answers derived
Which of the following criteria should be considered when selecting an identifier? -
answers Choose an identifier that is stable.
Choose an identifier that will not be null.
Choose an identifier that doesn't have large composite attributes. (All of the above)
,An attribute that uniquely identifies an entity and consists of a composite attribute is
called a(n): -answers composite identifier
An entity that associates the instances of one or more entity types and contains
attributes specific to the relationships is called a(n): -answers associative entity
Which of the following conditions should exist if an associative entity is to be created? -
answers All the relationships for the participating entities are many-to-many.
The new associative entity has independent meaning.
The new associative entity participates in independent relationships. (all of the above)
The number of entity types that participate in a relationship is called the: -answers
degree
A relationship between the instances of a single entity type is called a(n) ________
relationship -answers unary
A student can attend five classes, each with a different professor. Each professor has
30 students. The relationship of students to professors is a ________ relationship. -
answers many-to-many
Ternary -answers In the following diagram, what type of relationship is depicted?
It depicts a unary relationship.
It depicts a many-to-many relationship.
There is an associative entity.
(All of the above) -answers In the following diagram, which is true?
A ________ specifies the number of instances of one entity that can be associated with
each instance of another entity. -answers cardinality constraint
A simultaneous relationship among the instances of three entity types is called a(n)
________ relationship. -answers ternary
A person can marry at most one person. -answers In the figure shown below, which of
the following is true?
A relationship where the minimum and maximum cardinality are both one is a(n)
________ relationship. -answers mandatory one
A department can have more than one employee. -answers For the relationship
represented in the figure below, which of the following is true?
Each patient has one or more patient histories.
Each patient history belongs to one and only one patient. (both A and C) -answers In
the following diagram, which of the answers below is true?
,Each vendor can supply many parts to any number of warehouses, but need not supply
any parts. -answers In the figure shown below, which of the following business rules
would apply?
A value that indicates the date or time of a data value is called a(n): -answers time
stamp.
Each employee can supervise one to many employees -answers In the following
diagram, which answer is true?
A mutually exclusive relationship is one in which: -answers an entity instance can
participate in only one of several alternative relationships.
Most systems developers believe that data modeling is the least important part of the
systems development process. -answers FALSE
Data, rather than processes, are the most complex aspects of many modern information
systems -answers TRUE
The E-R model is used to construct a conceptual model. -answers TRUE
In an E-R diagram, strong entities are represented by double-walled rectangles. -
answers FALSE
In an E-R diagram, an associative entity is represented by a rounded rectangle. -
answers TRUE
Data modeling is about documenting rules and policies of an organization that govern
data. -answers TRUE
One of the roles of a database analyst is to identify and understand rules that govern
data. -answers TRUE
The purpose of data modeling is to document business rules about processes. -answers
FALSE
A business rule is a statement that defines or constrains some aspect of the business. -
answers TRUE
The intent of a business rule is to break down business structure -answers FALSE
Enforcement of business rules can be automated through the use of software tools that
can interpret the rules and enforce them. -answers TRUE
, When systems are automatically generated and maintained, quality is diminished. -
answers FALSE
A business rule is a statement of how a policy is enforced or conducted. -answers
FALSE
While business rules are not redundant, a business rule can refer to another business
rule. -answers TRUE
A business rule should be internally consistent. -answers TRUE
Business rules are formulated from a collection of business ramblings. -answers FALSE
Data names should always relate to business characteristics. -answers TRUE
Data names do not have to be unique. -answers FALSE
An example of a term would be the following sentence: "A student registers for a
course." -answers FALSE
A fact is an association between two or more terms. -answers TRUE
A good data definition is always accompanied by diagrams, such as the entity-
relationship diagram. -answers TRUE
An entity is a person, place, object, event, or concept in the user environment about
which the organization wishes to maintain data. -answers TRUE
A single occurrence of an entity is called an entity instance. -answers TRUE
The relationship between a weak entity type and its owner is an identifying relationship.
-answers TRUE
An entity type on which a strong entity is dependent is called a covariant entity. -
answers FALSE
An entity type name should always be a singular noun. -answers TRUE
The name used for an entity type should never be the same in other E-R diagrams on
which the entity appears. -answers FALSE
Some examples of attributes are: eye_color, weight, student_id, student. -answers
FALSE
A simple attribute can be broken down into smaller pieces. -answers FALSE
