Chapter 2- Part 1 Flashcards
1
Q
Something of importance to a user that needs to be represented in a database
A
Entity
2
Q
A 2-dimentional table that has specific characteristics
A
Relation
3
Q
What do relation tables consist of?
A
Rows and Columns
4
Q
Relation Characteristic #1
A
Rows contain data about an entity
5
Q
Relation Characteristic #2
A
Columns contain data about attributes of the entity
6
Q
Relation Characteristic #3
A
Cells of the table hold a single value
7
Q
Relation Characteristic #4
A
All entries in a column are of the same kind
8
Q
Relation Characteristic #5
A
Each column has a unique name
9
Q
Relation Characteristic #6
A
The order of the columns is unimportant
10
Q
Relation Characteristic #7
A
The order of the row is unimportant
11
Q
Relation Characteristic #8
A
No two rows may be identical
