Chapter 3 Flashcards

1
Q

Superpkey

A

Any key that uniquely identifies each row

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

Candidate key

A

A superkey without unnecessary attributes

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

Entity Integrity

A

When each row in a table is uniquely identified by a primary key

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

Referential Integrity

A

When a foreign key contains a value that corresponds to an existing tuple in another relation

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

Secondary key

A

A key that is used strictly for data retrieving purposes

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

Natural join

A

links tables by selecting only the rows with common values in their common attributes

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

Data dictionary

A

Detailed description of all tables found within the user/designer-created database

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

System catalog

A

Contains metadata. Can be described as a detailed system data dictionary that describes all objects within the database

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

Composite entity AKA bridge entity and associative entity

A

Used to linked tables that originally had a many to many relationship

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

Attribute domain

A

A specific range of values in a column

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