Relation Database Schema Flashcards
1
Q
Deletion Anomaly
A
Deleting data you were not supposed to delete
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.
3
Q
Relation Definition
A
Tables / Collection of related data values / Set of tuples.
4
Q
Relation Schema
A
Staff(StaffID, FirstName, Lastname, Email etc..)
5
Q
s(Lectures) = {t1t2t3}
A
t1 = <732479,Ada,Loverance,G23,ComputerScience>
t2 = <…>
6
Q
Tuples (atomic)
A
Each value in a tuple is atomic (one single value).
7
Q
Super-key and Key
A
Used to identify rows.
