Modern Database Management, 13th Edition, TEST BANK By
Jeff Hoffer, Ramesh Venkataraman, Heikki Topi |
A ________ is a statement that defines or constrains some aspect of the business. -
ANSWER:business rule
A ________ is an association between two or more terms. - ANSWER:fact
A ________ may be associated with any data value that changes over time when we
need to maintain a history of those data values. - ANSWER:time stamp
A ________ relationship occurs between two instances of a single entity type. -
ANSWER:unary
A ________ specifies the number of instances of one entity that can be associated
with each instance of another entity. - ANSWER:cardinality constraint
A business rule is a statement of how a policy is enforced or conducted - ANSWER:F
A business rule is a statement that defines or constrains some aspect of the business.
- ANSWER:T
A business rule should be internally consistent. - ANSWER:T
A cardinality constraint tells what kinds of properties are associated with an entity. -
ANSWER:F
A fact is an association between two or more terms. - ANSWER:T
A good data definition is always accompanied by diagrams, such as the entity-
relationship diagram - ANSWER:T
A logical representation of the data for an organization or for a business area is
called a(n) ________. - ANSWER:entity-relationship model
A meaningful relationship between entity types is called a(n) ________. -
ANSWER:relationship type
A multivalued attribute may take on more than one value for a particular entity
instance. - ANSWER:T
A property or characteristic of an entity is a(n) ________. - ANSWER:attribute
, A relationship instance is an association between entity instances where each
relationship instance includes exactly one entity from each participating entity type. -
ANSWER:F
A relationship name is a ________. - ANSWER:verb phrase
A simple attribute can be broken down into smaller pieces. - ANSWER:F
A simultaneous relationship among the instances of three entity types is called a
________ relationship. - ANSWER:ternary
A single occurrence of an entity is called an entity instance. - ANSWER:T
A single occurrence of an entity type is called an entity ________. -
ANSWER:instance
A ternary relationship is equivalent to three binary relationships. - ANSWER:F
A time stamp is a time value that is associated with a data value. - ANSWER:T
A weak entity type is related to its owner by a(n) ________ - ANSWER:identify
relationship
A(n) ________ entity type exists independently of other entity types. -
ANSWER:strong
A(n) ________ is an attribute that uniquely identifies individual instances of an entity
type. - ANSWER:identifier
An affirmative entity is also called a relationship entity. - ANSWER:F
An attribute that can be broken down into component parts is called a(n) ________
attribute. - ANSWER:composite
An attribute whose value can be calculated from a related attribute is called a(n)
________ attribute. - ANSWER:derived
An attribute whose values can be calculated from related attribute values is called a
derived attribute. - ANSWER:T
An entity is a person, place, object, event, or concept in the user environment about
which the organization wishes to maintain data. - ANSWER:T
An entity type name should always be a singular noun. - ANSWER:T
An entity type on which a strong entity is dependent is called a covariant entity. -
ANSWER:F
Jeff Hoffer, Ramesh Venkataraman, Heikki Topi |
A ________ is a statement that defines or constrains some aspect of the business. -
ANSWER:business rule
A ________ is an association between two or more terms. - ANSWER:fact
A ________ may be associated with any data value that changes over time when we
need to maintain a history of those data values. - ANSWER:time stamp
A ________ relationship occurs between two instances of a single entity type. -
ANSWER:unary
A ________ specifies the number of instances of one entity that can be associated
with each instance of another entity. - ANSWER:cardinality constraint
A business rule is a statement of how a policy is enforced or conducted - ANSWER:F
A business rule is a statement that defines or constrains some aspect of the business.
- ANSWER:T
A business rule should be internally consistent. - ANSWER:T
A cardinality constraint tells what kinds of properties are associated with an entity. -
ANSWER:F
A fact is an association between two or more terms. - ANSWER:T
A good data definition is always accompanied by diagrams, such as the entity-
relationship diagram - ANSWER:T
A logical representation of the data for an organization or for a business area is
called a(n) ________. - ANSWER:entity-relationship model
A meaningful relationship between entity types is called a(n) ________. -
ANSWER:relationship type
A multivalued attribute may take on more than one value for a particular entity
instance. - ANSWER:T
A property or characteristic of an entity is a(n) ________. - ANSWER:attribute
, A relationship instance is an association between entity instances where each
relationship instance includes exactly one entity from each participating entity type. -
ANSWER:F
A relationship name is a ________. - ANSWER:verb phrase
A simple attribute can be broken down into smaller pieces. - ANSWER:F
A simultaneous relationship among the instances of three entity types is called a
________ relationship. - ANSWER:ternary
A single occurrence of an entity is called an entity instance. - ANSWER:T
A single occurrence of an entity type is called an entity ________. -
ANSWER:instance
A ternary relationship is equivalent to three binary relationships. - ANSWER:F
A time stamp is a time value that is associated with a data value. - ANSWER:T
A weak entity type is related to its owner by a(n) ________ - ANSWER:identify
relationship
A(n) ________ entity type exists independently of other entity types. -
ANSWER:strong
A(n) ________ is an attribute that uniquely identifies individual instances of an entity
type. - ANSWER:identifier
An affirmative entity is also called a relationship entity. - ANSWER:F
An attribute that can be broken down into component parts is called a(n) ________
attribute. - ANSWER:composite
An attribute whose value can be calculated from a related attribute is called a(n)
________ attribute. - ANSWER:derived
An attribute whose values can be calculated from related attribute values is called a
derived attribute. - ANSWER:T
An entity is a person, place, object, event, or concept in the user environment about
which the organization wishes to maintain data. - ANSWER:T
An entity type name should always be a singular noun. - ANSWER:T
An entity type on which a strong entity is dependent is called a covariant entity. -
ANSWER:F
