(Solved): Correct answer needed please! Download the "Assign \#8" file. It is a MS Word Document ...

Correct answer needed please!

Download the "Assign \#8" file. It is a MS Word Document file. Read the end of Chap 3 in your book!!!!! Build the required INSERT/UPDATE/DELETE queries and copy your SQL code to an MS Word file. Once you have all queries built and your code copied in an MS Word file, you are ready to submit. Then Submit this file for grading. For this assignment, use your Dentist Office tables you created in Assign \#7. Use just the 4 Dentist Office tables 1.) INSERT : Using SQL, Insert 4 rows of data to each of the Dentist Office tables that you created in Assign \#7. Just make up the data that you add. You should have at least $$16\mathrm{SQL}$$ Insert statements to hand in. Print out these SQL statements to hand them in. 2.) DELETE: Next, again using SQL, Delete the last 2 rows in each table from your Database. Use SQL Delete statements. Delete using a where clause based on the Primary key in each table. Print these SQL statements and hand them in. You should have at least 8 Delete statements. 3.) UPDATE: Lastly, change all the lastnames in your "Dentists" table to "Moore". Also change the firstname of the last row of data in each possible table, to "Frank". Change any zipcodes from CA to 90000 . You should have at least 3 update statements. 4.) DROP Table: Finally, remove the entire Procedures Table. CREATE TABLE Employees ( empID int NOT NULL PRIMARY KEY, firstName varchar(255), lastName varchar(255), address varchar(255), deptCode varchar(255), salary int, email varchar(255) ) CREATE TABLE Depts ( DeptId int NOT NULL PRIMARY KEY, DeptName varchar(255), DeptLocation varchar(255) ) CREATE TABLE Accounts ( accNo int NOT NULL PRIMARY KEY, owner varchar(255), address varchar(255), deptCode varchar(255), type varchar(255), balance int ) CREATE TABLE Dentist ( DentID char(4) NOT NULL PRIMARY KEY, FirstName varchar(30) NOT NULL, LastName varchar(30) NOT NULL, Email varchar(30), Office char(4) ) CREATE TABLE Patients ( PatID char(4) NOT NULL PRIMARY KEY, FirstName varchar(30) NOT NULL, LastName varchar(30) NOT NULL, Address varchar(60), Email varchar(10), InsCo varchar(30) ) CREATE TABLE Appointments ( AppDateTime dateTime NOT NULL, PatID char(4) NOT NULL FOREIGN KEY REFERENCES Patients(PatID), DentID char(4) NOT NULL FOREIGN KEY REFERENCES Dentists(DentID), ProcCode char(4) NOT NULL FOREIGN KEY REFERENCES Procedures(ProcCode), PRIMARY KEY (AppDateTime, PatID) ) CREATE TABLE Procedures ( ProcCode char(4) NOT NULL PRIMARY KEY, ProcName varchar(30) NOT NULL, ProcDesc varchar(30), Cost int )