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