Constraint Violations
0.0(0)
Studied by 0 people
Learn
Practice Test
Spaced Repetition
Match
FlashcardsCard Sorting
1/4
There's no tags or description
Looks like no tags are added yet.
Study Analytics
Name | Mastery | Learn | Test | Matching | Spaced |
|---|
No study sessions yet.
5 Terms
1
New cards
Referential Integrity Constraint Violation
Occurs when a foreign key value has no matching primary key value in the referenced table
2
New cards
Key Constraint Violation
Occurs when duplicate values are inserted into a primary key or unique key column
3
New cards
Domain Constraint Violation
Occurs when a value doesn't match the defined data type, format, or range for that column
4
New cards
Entity Integrity Constraint Violation
Occurs when a primary key contains NULL values
5
New cards
Semantic Integrity Constraints
Based on application semantics
Not expressible by model alone
Example: "max 56h/week for all employee projects"
SQL-99 uses triggers and assertions
Note 
Flashcards (82)