Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
28 Cards in this Set
- Front
- Back
|
denormalization
|
process of splitting or combining normalized relations into physial tables based on affinity of use of rows and fields
|
|
|
normalization
|
eliminating redundancy
|
|
|
physical table
|
named set of rows and columns that specify the fields in each rows of the table
|
|
|
physical file
|
a named set of table rows stored in a contiguous section of secondary memory
|
|
|
file organization
|
a technique for physically arranging files
|
|
|
recursive foreign key
|
foreign key in a relation that references the primary key values of that same relation
|
|
|
synonyms
|
two different names that are used for the same attribute
|
|
|
pointer
|
field of data that can be used to locate a related field or row of data
|
|
|
sequential file organization
|
rows in the file are stored in sequence according to a primary key value
|
|
|
second normal form (2NF)
|
relation for which every nonprimary key attribute is functionally dependent on the whole primary key
|
|
|
third normal form (3NF)
|
relation that is in second normal form that has no functional (transitive) dependencies between two (or more) nonprimary key attributes
|
|
|
calculated (or computer derived) field
|
field that can be derived from other databse fields
|
|
|
data type
|
coding scheme recognized by system software for representing organizational data
|
|
|
default value
|
value a field will assume unless an explicit value is entered for that field
|
|
|
field
|
smallest unit of named application data recognized by system software
|
|
|
foreign key
|
e
|
|
|
functional dependency
|
f
|
|
|
hashed file organization
|
g
|
|
|
homonym
|
h
|
|
|
index
|
i
|
|
|
indexed file organization
|
j
|
|
|
null value
|
k
|
|
|
primary key
|
l
|
|
|
referential integrity
|
m
|
|
|
relation
|
n
|
|
|
relational database model
|
o
|
|
|
secondary key
|
p
|
|
|
well-structured relation (or table)
|
q
|
