Database Management Ch. 5

Front 1

Functional dependence

Back 1

Describing which fields are determined by which other fields

Front 2

Primary key rules

Back 2

1) All columns in R are functionally dependent on A
2) No sub-collection of the columns in A also has property 1

Front 3

candidate key

Back 3

column or collection of columns on which all columns are functionally dependent

Front 4

Alternate keys

Back 4

Keys that are candidates for being a primary key, but are not chosen

Front 5

repeating group

Back 5

multiple entries for a single record

Front 6

unnormalized relation

Back 6

contains a repeating group

Front 7

first normal form

Back 7

does not contain repeating groups

Front 8

nonkey column

Back 8

not part of the primary key

Front 9

partial dependency

Back 9

dependencies only on part of the primary key, not the entire thing

Front 10

second normal form

Back 10

first normal form, no partial dependencies

Front 11

determinant

Back 11

column that determines another column

Front 12

third normal form

Back 12

second normal form and the only determinants are candidate keys

Front 13

fourth normal form

Back 13

third normal form and no multivalued dependnecies

Front 14

multivalued dependencies

Back 14

each value for A is associated with a specific group of values for B and this group of values is independent of any values for C

Front 15

Normal Form list

Back 15

First - No repeating groups
Second - no nonkey column dependent only on part of the primary key
Third - Only determinants are candidate keys
Fourth - no multivalued dependencies

Front 16

interrelation constraint

Back 16

a condition that involves 2 or more relationships