Chapter 7 The Relational Data Model Flashcards
1
Q
atomic value:
A
each value in the domain is indivisible as far as the relational model is concernedattribute: principle storage unit in a database
2
Q
column:
A
see attribute
3
Q
degree:
A
number of attributes in a table
4
Q
domain:
A
the original sets of atomic values used to model data; a set of acceptable values that a column is allowed to contain
5
Q
field:
A
see attribute
6
Q
file:
A
see relation
7
Q
record:
A
contains fields that are related; see tuple
8
Q
relation:
A
a subset of the Cartesian product of a list of domains characterized by a name; the technical term for table or file
9
Q
row:
A
see tuple
10
Q
structured query language (SQL):
A
the standard database access language
11
Q
table:
A
see relation
12
Q
tuple:
A
a technical term for row or record
