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 concerned.
2
Q
Attribute
A
Principle storage unit in a database (a column, also known as a field)
3
Q
Column
A
An attribute (principle storage unit in a database. Also known as a field)
4
Q
Degree
A
Number of attributes in a table
5
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.
6
Q
Relation (table)
A
A subset of the Cartesian product of a list of domains characterized by a name; the technical term for table or file.
7
Q
Record (tuple, row)
A
Contains fields that are related
8
Q
Structured Query Language (SQL)
A
The standard database access language
9
Q
Tuple
A
A technical term for record or row.
