ch 8 quiz
A(n) ________ is an attribute that has meaningful component parts.
Composite attribute
The ________ is a logical grouping of objects that have the same (or similar) attributes, relationships, and behaviors; also called class.
Object class
A(n) ________ is an operation that does not have any side effects; it accesses the state of an object but does not alter the state
Query operation
A(n) ________ is an attribute that must have a value forevery entity instance
Required attribute
The ________ rule specifies that each entity instance of the super-type must be a member of some subtype of the relationship.
Total specialization Business
An entity ________ is described just once in a data model, whereas many ________ of that may be represented by data stored in the database
Type; instances
A part-of relationship in which parts belong to only one whole object, and the parts live and die with the whole object is called ________
composition
A common mistake many people make when they are just learning to draw E-R diagrams, especially if they already know how to do data flow diagramming, is to confuse data entities with ________ and relationships with data flows
sinks
A ________ is an entity type that is meaningful to the organization and that shares common attributes or relationships distinct from other sub-grouping
subtype
A(n) ________ is an assertion or rule that governs the validity of data manipulation operations such as insert, update, and delete.
triggering operation
An entity has its own identity that distinguishes it from each other entity
true
One situation in which a relationship must be turned into an associative entity is when the associative entity has other relationships with entities besides the relationship that caused its creation.
true
A(n) ________ is a named property or characteristic of an entity that is of interest to the organization.
attribute
The ________ defines the number of instances of entity B that can (or must) be associated with each instance of entity A.
cardinality
A(n) ________ is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data.
entity
The most common format used for data modeling is ________ diagramming.
entity-relationship
An aggregation is an association between the instances of one or more entity types that is of interest to the organization
false
An object type is a collection of entities that share common properties or characteristics.
false
Projects with purchased models take less time and cost more because the initial discovery steps are no longer necessary, leaving only iterative tailoring and refinement to the local situation.
false
The disjoint rule specifies that if an entity instance of the supertype is a member of one subtype, it can simultaneously be a member of any other subtype
false
how many types of business rules are there in conceptual data modeling
four
An entity ________ is a single occurrence of an entity type.
instance
which business rule specifies rules concerning the relationships between entity types
referential integrity constraints
Similar attributes of different entity types should use ________ but distinguishing names
similar
The ________ of a relationship is the number of entity types that participate in that relationship
degree
A(n) ________ is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data
entity
A(n) ________ has a well-defined role in the application domain, and it has state (data), behavior, and identity characteristics.
object
The ________ rule specifies that an entity instance of the super type does not have to belong to any subtype.
partial specialization
