Chapter 3 Flashcards
(9 cards)
1
Q
Relation
A
flat file (set of rows)
2
Q
Row
A
(Tuples) Data elements in each row represent certain facts to a real-world entity or relationship
3
Q
Column
A
Specifies how to interpret data values in each row
4
Q
Domain
A
Data that specifies the types of values that can appear in each column
Set of atomic values
5
Q
Degree
A
Degree of a relation is the number of attributes n of its relation schema
6
Q
Relation(Relation State)
A
resembles a table of values (typically contains a set of rows)
7
Q
Tuple
A
A n-tuple is an ordered list of n values
8
Q
Cartesian product
A
all possible combinations of values from underlying domains
9
Q
Summary
A
Table-Relation Column Header-Attribute All possible Column Values-Domain Row-Tuple Table Definition-Schema of Relation Populated Table-State of Relation
