Give example of insert operation that violates key constraint

2- Give example of delete operation that violates referential integrity constraint

3- Give example of update operation that violates entity integrity

4- Give example of insert operation that violates referential integrity constraint

5- Give example of valid insert operation

 

Transcribed Image Text:

Department Dept id 1 2 3 Student St id 5667 3451 1122 Grades St id 1122 5667 3451 Dept_name IS CS IT St name Ahmed Salem Magda Karim Hoda Hany C# D203 D203 N101 C# N101 D203 D445 DOB 5/10/1997 12/08/1999 21/11/1999 Grade 90 89 78 Course Cname Networks Database Data Mining Address El marwa El hamra El rawda Dept_id 1 3 3 Hours 5 4 3 Department Dept id 1 2 3 Student St id 5667 3451 1122 Grades St id 1122 5667 3451 Dept_name IS CS IT St name Ahmed Salem Magda Karim Hoda Hany C# D203 D203 N101 C# N101 D203 D445 DOB 5/10/1997 12/08/1999 21/11/1999 Grade 90 89 78 Course Cname Networks Database Data Mining Address El marwa El hamra El rawda Dept_id 1 3 3 Hours 5 4 3

Answer rating: 100% (QA)

1 Example of an insert operation that violates a key constraint Lets consider a table named Students with a primary key constraint on the StudentID co... View the full answer