Assign #6 Dentist Tables (4)

Assign #7 Tables (4)

CIST 1220: SQL Assign #8

(40 Points)

[INSERTs/DELETEs/UPDATEs Chap 10]

For this assignment, use your Dentist Office tables you created in Assign #6. Use just the 4 Dentist Office tables

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 SQL Insert statements to hand in. Print out these SQL statements to hand them in.

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.

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.

DROP Table: Finally, remove the entire Procedures Table.

Courses CourseID CourseName ption reditHou Intro to Computers 4 ST 1001 Computer Concepts IST 1122 Hardware Maintainence Course Hardware Maintainence IST 1130 IST 1220 SQL Programming IST 1305Program Design and Development Intro to Programming IST 1401 IST 1510 Web Development I ST 2341 C# Programming I IST 2342|C# Programming 11 IST 2371 Java Programming I IST 2372 Java Programming II IST 2921 Analysis and Design IST 2931Systems Project IST 3273Java Programming III ing Systems plore how an Operating System works 4 ing about SQL Networking Fundamentals Intro to C# Programming rking Fundamentals evelop Web-pages using HTML Advanced C# Programming Intro to Java Intermediate Java Topics bject Oriented Analysis and Design apstone Project Class sing Java to build Web Applications