UNA CIS 622 Chapter 8

Binary

A ________ relationship is a relationship between instances of two entity types and is the most common type of relationship encountered in data modeling. Binary Secondary Primary Ternary

Sinks

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 Attributes Classes Relationships

Abstract

A(n) ________ class is a class that has no direct instances but whose descendants may have direct instances. Abstract Object Associative Concrete

Conceptual

A(n) ________ data model is a detailed model that captures the overall structure of organizational data that is independent of any database management system or other implementation considerations. Conceptual Physical Logical Entity

User rule

A(n) ________ is a concise statement of the business rule to be enforced by the triggering operation. Action Event Condition User rule

Composite attribute

A(n) ________ is an attribute that has meaningful component parts. Composite attribute Optional attribute Derived attribute Required attribute

Optional attribute

A(n) ________ is an attribute that may not have a value for every entity instance. Required attribute Optional attribute Composite attribute Derived attribute

Multi-valued attribute

A(n) ________ is an attribute that may take on more than one value for each entity instance. Identifier Multi-valued attribute Single-valued attribute Candidate key

Derived attribute

A(n) ________ is an attribute whose value can be computed from related attribute values. Required attribute Optional attribute Composite attribute Derived attribute

Type

An entity ________ is a collection of entities that share common properties or characteristics. Subject Relationship Type Object

Type

An entity ________ is a collection of entities that share common properties or characteristics. Type Subject Object Relationship

Type; instances

An entity ________ is described just once in a data model, whereas many ________ of that may be represented by data stored in the database. Type; classes Instance; types Class; objects Type; instances

Data

During requirements structuring, a ________ model represents conceptual data requirements for a particular system. Business Data Project Relationship

Data

During requirements structuring, a ________ model represents conceptual data requirements for a particular system. Relationship Data Project Business

Name

Each entity type in an E-R model is given a ________ because it represents a class or set, it is singular. Name Class Degree Type

Four

How many types of business rules are there in conceptual data modeling? Four Three One Two

Attributes and secondary keys

On what basis are objects referenced, selected, qualified, sorted, and categorized? Attributes and secondary keys Entities Primary keys Index

Similar

Similar attributes of different entity types should use ________ but distinguishing names. Duplicate Similar Different Unique

Association

The ________ defines the number of instances of entity B that can (or must) be associated with each instance of entity A. Association Cardinality Identifier Relationship

Cardinality

The ________ defines the number of instances of entity B that can (or must) be associated with each instance of entity A. Relationship Association Identifier Cardinality

Degree

The ________ of a relationship is the number of entity types that participate in that relationship. Degree Object Identifier Measure

Class diagram

The ________ shows the static structure of an object-oriented model: the object classes, their internal structure, and the relationships in which they participate. Object class Class diagram Data model Object diagram

Polymorphism

The fact that the same operation may apply to two or more classes in different ways is known as ________. Abstract operation Aggregation Polymorphism Composition

Entity-relationship

The most common format used for data modeling is ________ diagramming. Entity-relationship Entity-class Entity-subject Entity-object

Logical

The term ________ data model means a conceptual data model with some additional properties associated with the most popular type of database technology like relational databases. Physical Logical Industry-specific Universal

Two

There is/are ________ principal type(s) of packaged data model(s). Five Two One Three

Referential integrity constraints

Which business rule specifies rules concerning the relationships between entity types? Triggering operations Domains Referential integrity constraints Entity integrity

Business

________ rules are specifications that preserve the integrity of the logical data model. Disjoint Overlap Total specialization Business

Attributes

A domain is the set of all data types and ranges of values that ________ may assume. Entities Attributes Instances Events

Composition

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 ________. Polymorphism Aggregation Method Composition

Event

Event entity types should be named for the result of the ________, not the activity or process of the event. Entity Object Class Event