code.

Add the Question Number before each response statement$($s$)$

as a $\frac{?}{?}**$ comment text $*/$

Lab # $2$

Review of Basic SQL command

Statement purpose

To review the basic of SQL statements $($create$,$ load data, select,

delete, and update$)$

Activity Outcomes

Students will be able to use SQL statement to create tables, insert,

delete, update, and select statements.

Instructor Note

Implement all the questions below and submit, for each question, the

code and its execution result $($as a readable screenshot$)$ displayed by

Oracle. The contents of the screenshot MUST be in a readable font

size.

Answer the following questions.

Apply the following updates $($some of the updates will violate

integrity constraints$)$ on the table created in lab $1.$ Document clearly

which updates succeeded and which failed, and the kind of integrity

constraint violation that caused it to fail:

Insert a record $(\text{'}$Services$\text{'},1,\text{'}123456789\text{'},\text{'}11-$AUG$-2012\text{'})$ into

DEPARTMENT.

Insert a record $(\text{'}$Purchasing$\text{'},3,\text{'}990110110\text{'},\text{'}02-$FEB$-2013\text{'})$ into

DEPARTMENT.

Insert a record $(\text{'}$Customers$\text{'},12,\text{'}333445555\text{'},\text{'}14-$JAN$-2013\text{'})$

into DEPARTMENT.

Update the Dnumber of the DEP$\_$LOCATIONS record with

Dlocation$=$'Seattle' to $9.$

Update the Salary of the EMPLOYEE record with

$SSN=444444444$ to $55000.$

Insert a record $(\text{'}$Jane$\text{'},\text{'}$B$\text{'},$ 'Smith', $\text{'}666666606\text{'},\text{'}01-$MAR$-1980\text{'},$

$\text{'}3556$ W Second Street,Miami,FL$\text{'},\text{'}$F$\text{'},85000,\text{'}666666603\text{'},5)$

into EMPLOYEE.

Update the hours of the WORKS$\_$ON record with Pno$=1$ for the

employee with $SSN={?}^{\text{'}}{666884444}^{-}$to $25.$

Delete the EMPLOYEE record with $Ssn=\text{'}432765098\text{'}.$

Delete the DEPARTMENT record with DNUMBER $=9.$

Delete all the dependents of employee with $Ssn=\text{'}666666608\text{'}$

Submit your answers in Blackboard.

AA

Ims.uj$.$edu.sa