Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Spr18Assign8 -Compatibility Mode -Saved to my Mac a Search in Document Home Insert Design Layout References Mailings Review View Share Emphasis Heading1 Styles For this
Spr18Assign8 -Compatibility Mode -Saved to my Mac a Search in Document Home Insert Design Layout References Mailings Review View Share Emphasis Heading1 Styles For this assignment, use your Dentist Office tables you created in Assign #6. Use just the 4 Dentist Office tables L) 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 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 Deletoe 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. Page 1 of 2 185 words E [] Focus 119%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started