Hoffer For Fuller Exam 1 Chap 3

Front 1

Business rule

Back 1

A statement that defines or constrains some aspect of the business. It is intended to assert business structure or to control or influence behavior of the business

Front 2

Data names should be...

Back 2

1) related to business characteristics
2) meaningful
3) unique
4) readable
5) composed of words taken from an approved list
6) repeatable
7) follow s standard syntax

Front 3

Term

Back 3

a word or phrase that has a specific meaning for the business

Front 4

Fact

Back 4

an association between two or more terms

Front 5

Entity-Relationship mode (E-R model)

Back 5

a logical representation of the data for an organization or for a business area using entities for categories of data and relationships for associations between entities

Front 6

Entity-relationship diagram (E-R diagram or ERD)

Back 6

a graphical representation of an entity-relationship model

Front 7

Entity

Back 7

a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data

Front 8

Entity type

Back 8

a collection of entities that share common properties or characteristics

Front 9

Entity instance

Back 9

a single occurrence of an entity type

Front 10

Strong entity type

Back 10

an entity that exists independently of other entity types

Front 11

Weak entity type

Back 11

an entity type whose existence depends on some other entity type

Front 12

Identifying owner (owner)

Back 12

the entity type on which the weak entity type depends

Front 13

identifying relationship

Back 13

the relationship between a weak entity type and its owner

Front 14

Attribute

Back 14

a property or characteristic of an entity or relationship type that is of interest to the organization

Front 15

Required attribute

Back 15

an attribute that must have a value for every entity (or relationship) instance with which it is associated

Front 16

Optional attribute

Back 16

an attribute that may not have a value for every entity (or relationship) instance with which it is associated

Front 17

Composite attribute

Back 17

an attribute that has meaningful component parts (attributes)

Front 18

Simple ( or atomic) attribute

Back 18

an attribute that cannot be broken down into smaller components that are meaningful to the organization

Front 19

Multivalued attribute

Back 19

an attribute that may take on more than one value for a given entity (or relationship) instance

Front 20

Derived attribute

Back 20

an attribute whose values can be calculated form related attribute values

Front 21

Identifier

Back 21

an attribute ( or combination of attributes) whose value distinguishes instances of an entity type

Front 22

Composite identifier

Back 22

an identifier that consists of a composite attribute

Front 23

Relationship type

Back 23

a meaningful association between ( or among) entity types

Front 24

Relationship instance

Back 24

an association between (or among) entity instances where each relationship instance associates exactly one entity instance from each participating entity type

Front 25

Associative entity

Back 25

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

Front 26

Degree

Back 26

the number of entity types that participate in a relationship

Front 27

Unary relatinship

Back 27

a relationship between instances of a single entity type

Front 28

Binary relationship

Back 28

a relationship between the instances of two entity types

Front 29

Ternary relationship

Back 29

a simultaneous relationship among the instances of three entity types

Front 30

Cardinality constraint

Back 30

specifies the number of instances of one entity that can )(or must be associated with each instance of another entity

Front 31

Minimum cardinality

Back 31

the minimum number of instances of one entity that may be associated with each instance of another entity

Front 32

Maximum cardinality

Back 32

the maximum number of instances of one entity that may be associated with each instance of another entity

Front 33

Time stamp

Back 33

a time value that is associated with a data value, often indicated when some event occurred that affected the data value