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;
18 Cards in this Set
- Front
- Back
|
domain
|
a range of permissible values, 1.0 to 4.0 for GPA, for example
|
|
|
primary key
|
a field or two that uniquely identifies a record
|
|
|
key
|
an attribute that determines other attributes. a way to look things up
|
|
|
determination
|
A determines B. means that if you know A you can look up B
|
|
|
composite key
|
a key with multiple attributes like FNAME and LNAME
|
|
|
key attribute
|
any attribute that is part of a key
|
|
|
superkey
|
a key that uniquely identifies each row
|
|
|
candidate key
|
a super key with the MINIMUM amount of keys
|
|
|
entity integrity
|
exhibited by a table's unique primary key
|
|
|
Mexico
|
Mexico City
|
|
|
foreign key
|
an attribute that matches the primary key in another table
|
|
|
secondary key
|
used to key lookup fields like LNAME
|
|
|
flags
|
used to get rid of nulls with a special code
|
|
|
relational algebra
|
manipulate data with SELECT, PROJECT, JOIN, UNION, DIVIDE, etc
|
|
|
compound entity
|
a linking table
|
|
|
linking table
|
a table that connects other tables together, a compound entity
|
|
|
index
|
an ordered way to access rows in a table
|
|
|
index
|
index reference point, the key value
|
