database design Flashcards
1
Q
entity definition
A
represents ONE real world object of importance in a DB
2
Q
relationship definition
A
describes how entities can be connected
3
Q
attribute definition
A
describes characteristics of an entity
4
Q
domain definition
A
set of all possible values an attribute can take
5
Q
table definiton
A
collection of records and fields
6
Q
record definition
A
a unique instance of data
7
Q
tuple definition
A
set of related data points in a unique instance
8
Q
primary key definition
A
single attribute used to uniquely identify a record
9
Q
candidate key
A
unique key that can be chosen as the primary key
10
Q
surrogate key
A
system generated unique id used as primary key
11
Q
A
