Modern Database Management, 13th Edition, TEST BANK By Jeff Hoffer, Ramesh Venkataraman, Heikki Topi |
Modern Database Management, 13th Edition, TEST BANK By Jeff Hoffer, Ramesh Venkataraman, Heikki Topi |
All for this textbook (3)
Written for
Modern Database Management, 13th Edition
All documents for this subject (25)
Seller
Follow
kushboopatel6867
Content preview
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller kushboopatel6867. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $17.99. You're not tied to anything after your purchase.
