Databases Flashcards

1
Q

schema

A

structural descriptions of relations in a database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

instance

A

actual database contents at any given point in time

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

key

A

an attribute of a relation where every value of that attribute is unique. (id is usually a key. College, on the other hand is not likely a key because it’s not unique.)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly