W2 L2 - Relational Databases
0.0(0)
Studied by 0 people
Call Kai
Learn
Practice Test
Spaced Repetition
Match
Flashcards
Knowt PlayCard Sorting
1/3
There's no tags or description
Looks like no tags are added yet.
Last updated 11:23 AM on 4/23/25
Name | Mastery | Learn | Test | Matching | Spaced | Call with Kai |
|---|
No analytics yet
Send a link to your students to track their progress
4 Terms
1
New cards
Relational Schema
Block of code which describes a relation
You must define the PK and FK of each relation
Also define the ON DELETE and whether an attribute is UNIQUE
2
New cards
Foreign Keys
Involves important PK from one attribute to another, or creating a new table with PKs of tables in relation
3
New cards
ON DELETE…
Default - Deletion / update rejected
CASCADE - Delete all tuples that refer to delete tuples
SET NULL / DEFAULT - Sets foreign key value of referencing tuple to null / default
4
New cards
Domain vs Key Constraints
Domain:
Type and valid range of value
Eg: Age must be an int between 0-100
Key:
Ensures uniqueness of rows
Eg: Student_ID must be unique
Note 
Flashcards (178)