Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Logics For Databases And Information Systems

Authors: Jan Chomicki ,Gunter Saake

1st Edition

1461375827, 978-1461375821

More Books

Students also viewed these Databases questions

Question

Compute the derivative f(x)=1/ax+bx

Answered: 1 week ago

Question

What is job enlargement ?

Answered: 1 week ago

Question

what is the most common cause of preterm birth in twin pregnancies?

Answered: 1 week ago