Question: Please submit 1 .doc file of your SQL statements and a screen shot of a result set showing the data you inserted, updated, or deleted.

Please submit 1 .doc file of your SQL statements and a screen shot of a result set showing the data you inserted, updated, or deleted.

I want to change the data in the Movies database according to the following requirements.

1. Add 5 new movies. These movies should have accurate information as specified in IMDB.

2. Delete 3 actors whom you dislike.

3. 20th Century Fox Studio has been purchased by Universal. Make the appropriate deletes and updates to show this change in the database.

Please submit 1 .doc file of your SQL statements and a screen

tblDirector DirectorlD tblCast CastID CastFilmID CastActorlD CastCharacterName FilmID FilmCountrylD tblLanguage Language|D tblActor ActorlD ActorName ActorDOB ActorGender FilmRunTimeMinutes FilmOscarWins tblCertificate CertificatelD CertificateName tblCountry tblStudid StudiolD CountrylD CountryName

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Complete the following tasks using your AP Database. Please submit 1 .doc file of your SQL statements and a screen shot of a result set showing the data you inserted, updated, or deleted. I want to...

Please submit 1 .doc file of your SQL statements and a screen shot of a result set showing the data you inserted, updated, or deleted. I want to change the data in the Movies database according to...

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

I would like to have the entries for chapter 5 of the Smithville computer case (short version) see attachment Instructions City of Smithville Short Version Computerized Cumulative Problem For use...

Working on the City of Smithville Short version. I need the journal entries for Chapters 5, 6, and 9 (including Budgetary) ASAP. Thank you for your help. Instructions City of Smithville Short Version...

Can I have with chap 6 and 9 journal entries of Smithville Project Project attached Instructions City of Smithville Short Version Computerized Cumulative Problem For use with McGraw-Hill/Irwin...

I need Chapter 5 and Chapter 6 solutions to the "City of Bingham" continuous accounting problem from the 16e "Accounting for governmental & nonprofit entities" book. Instructions are posted...

Write a culturally sensitive and diversity health care plan for a very diverse low-income population. How can you ensure staff uses ethical, team-based approach? What kind of barriers might the...

Suppose p1 = 0 and p2 = 1. Find and graph the probability distribution for the total number inside. Find the expectation and the variance. Unbeknownst to the experimenter, a cell contains two...

true or false: Test checks are routine checks carried out during the audit

what are the factors that shape your organization external competitiveness to recruit and retain employees

How can you build on or depart from what is already being done in another community?

What are some of the possible scenes from our future?

2. Review the material on coping mechanisms. How might you substitute positive coping strategies for negative ones? Are your preferred coping strategies of a particular type (e.g., emotional,...