Relation Database Schema Flashcards

1
Q

Deletion Anomaly

A

Deleting data you were not supposed to delete

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

Insertion Anomaly

A

Inserting data before purpose has been accepted/set in stone / the inability to add data to the database due to the absence of other data.

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

Relation Definition

A

Tables / Collection of related data values / Set of tuples.

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

Relation Schema

A

Staff(StaffID, FirstName, Lastname, Email etc..)

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

s(Lectures) = {t1t2t3}

A

t1 = <732479,Ada,Loverance,G23,ComputerScience>
t2 = <…>

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

Tuples (atomic)

A

Each value in a tuple is atomic (one single value).

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

Super-key and Key

A

Used to identify rows.

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