411 Quiz Ch 9

Front 1

A detailed model that captures the overall structure of data in an organization

Back 1

Conceptual Data Modeling

Front 2

Independent of any database management system (DBMS) or other implementation considerations

Back 2

Conceptual Data Modeling

Front 3

Primary deliverable is an __________ or ______________

Back 3

entity-relationship (E-R) diagram or class diagram

Front 4

Data model is derived from an intimate understanding of the business.

Back 4

Top-down

Front 5

Data model is derived by reviewing specifications and business documents.

Back 5

Bottom-up

Front 6

What are subjects/objects of the business?

Back 6

Data entities and descriptions

Front 7

What unique characteristics distinguish between subjects/objects of the same type?

Back 7

Primary keys

Front 8

What characteristics describe each subject/object

Back 8

Attributes and secondary keys

Front 9

How do you use the data?

Back 9

Security controls and user access privileges

Front 10

A detailed, logical representation of the entities, associations and data elements for an organization or business

Back 10

Entity-Relationship (E-R) Diagram

Front 11

Notation of E-R Diagram uses three main constructs

Back 11

Data entities
Relationships
Attributes

Front 12

Square

Back 12

Entity

Front 13

Triangle

Back 13

Relationship

Front 14

Circle

Back 14

Attribute

Front 15

Person, place, object, event or concept about which data is to be maintained

Back 15

Entity

Front 16

Association between the instances of one or more entity types

Back 16

Relationship

Front 17

named property or characteristic of an entity

Back 17

Attribute

Front 18

collection of entities with common characteristics

Back 18

Entity type

Front 19

single entity

Back 19

Entity instance

Front 20

Attribute (or combination of attributes) that uniquely identifies each instance of an entity type

Back 20

Candidate key

Front 21

Canidate Key
Identifier

Back 21

Identifier Attributes

Front 22

A candidate key that has been selected as the unique identifying characteristic for an entity type

Back 22

Identifier

Front 23

Oval with Line

Back 23

Identifier Attribute

Front 24

Multivalued Attributes Represented on E-R Diagram in two ways:

Back 24

double-lined ellipse
weak entity

Front 25

number of entity types that participate in a relationship

Back 25

Degree

Front 26

between two instances of one entity type

Back 26

Unary

Front 27

between the instances of two entity types

Back 27

Binary

Front 28

among the instances of three entity types

Back 28

Ternary

Front 29

The number of instances of entity B that can or must be associated with each instance of entity A

Back 29

Cardinality

Front 30

The minimum number of instances of entity B that may be associated with each instance of entity A

Back 30

Minimum Cardinality

Front 31

The maximum number of instances of entity B that may be associated with each instance of entity A

Back 31

Maximum Cardinality

Front 32

Specifies whether an instance must exist or can be absent in the relationship

Back 32

Mandatory vs. Optional Cardinalities

Front 33

An entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances

Back 33

Associative Entities

Front 34

An associative entity is:

Back 34

An entity
A relationship

Front 35

________________ is the preferred way of illustrating a relationship with attributes

Back 35

associative entity

Front 36

A relationship that itself is related to other entities via another relationship must be represented as an _______________________ .

Back 36

associative entity

Front 37

a subrouping of the entities in an entity type that shares common attributes or relationships distinct from other subtypes

Back 37

Subtype

Front 38

a generic entity type that has a relationship with one or more subtype

Back 38

Supertype

Front 39

an entity instance of the supertype must be an instance of one of the subtypes

Back 39

Total specialization

Front 40

an entity instance of the supertype may or may not be an instance of one of the subtypes

Back 40

Partial specialization

Front 41

an entity instance of the supertype can be an instance of only one subtype

Back 41

Disjoint

Front 42

an entity instance of the supertype may be an instance of multiple subtypes

Back 42

Overlap

Front 43

Specifications that preserve the integrity of the logical data model

Back 43

Business Rules

Front 44

Four types of Business Rules:

Back 44

Entity integrity
Referential integrity constraints
Domains
Triggering operations

Front 45

unique, non-null identifiers

Back 45

Entity integrity

Front 46

rules governing relationships

Back 46

Referential integrity constraints:

Front 47

valid values for attributes

Back 47

Domains

Front 48

other business rules regarding attribute values

Back 48

Triggering operations

Front 49

The set of all data types and ranges of values that an attribute can assume

Back 49

Domains

Front 50

Advantages of Domains

Back 50

Verify that the values for an attribute are valid
Ensure that various data manipulation operations are logical
Help conserve effort in describing attribute characteristics

Front 51

An assertion or rule that governs the validity of data manipulation operations such as insert, update and delete

Back 51

Triggering Operations

Front 52

statement of the business rule to be enforced by the trigger

Back 52

User rule

Front 53

data manipulation operation that initiates the operation

Back 53

Event

Front 54

name of entity being accessed or modified

Back 54

Event Name

Front 55

condition that causes the operation to be triggered

Back 55

Condition

Front 56

action taken when the operation is triggered

Back 56

Action