In$-$Class Exercise : Exercise $1$

According to the data provided above by the Company's DB tables, Examine the execution of the following queries impact on the Integrity Constraint and their Referential Integrity. This includes $($Domain Constraints, Key Constraints, Entity Integrity, & Referential Integrity constraints$)$:

Insert $$'Ibrahim','Saud', NULL,$\text{'}1/2/1960\text{'},$'Khobar',$\text{'}$M$\text{'},12821,2,3>$ into Employee.

Insert $$'Salem','Rayan',$5,\text{'}4/12/1982\text{'},$'Dammam',$\text{'}$M$\text{'},11010,5,7>$ into Employee.

Insert $$'Reem','Khalid',$9,\text{'}13/8/1984\text{'},$'Dammam',$\text{'}$F$\text{'},12312,4,9>$ into Employee.

Insert $$'Mai','Sami', $10,\text{'}3/5/1985\text{'},$'Dammam',$\text{'}$F$\text{'},\text{'}10500,1,3>$ into Emplovee.

Employee Table:

$\backslash$table$[[$FName$,$LName,SSN$,$BDate,Address,Gender,Salary,SuperSSN,DNO$],[$AbdulAzeez$,$Omar,$1,1958-10-1300$:$0$dots,Dammam,M$,9800\mathrm{.}0000,$NULL,$1],[$Saad$,$Fahad,$2,1941-06-2700$:$0$dots,Khobar,M$,1200\mathrm{.}0000,1,2],[$Mohammad$,$Adel,$3,1962-03-1100$:$0$dots,Jubail,M$,8423\mathrm{.}0000,2,1],[$Khalid$,$Yousef,$4,1958-02-2200$:$0$dots,Dharan,$M,9800\mathrm{.}0000,1,4],[$Bassam$,$Najeeb,$5,1961-02-2000$:$0$dots,Khobar,$M,9633\mathrm{.}0000,3,3],[$Hamad$,$Fahad,$6,1941-04-3000$:$0$dots,Dammam,$M,8392\mathrm{.}0000,1,6],[$Suliman$,$Saad,$7,1958-10-0100$:$0...,$Riyadh,M$,1200\mathrm{.}0000,2,7],[$Nawaf$,$Ali,$8,2008-11-0800$:$0...,$Jeddah,$M,1230\mathrm{.}0000,4,3]]$

$36$

CIS$321$: Databogse Concepts & Design