Question: Write a stored procedure called Add Crew Member that accepts a movie id, crew id, position name, and wage. Ensure the wage is between $8,000

Write a stored procedure called Add Crew Member that accepts a movie id, crew id, position name, and wage. Ensure the wage is between $8,000 and $80,000. Add the person to the movie (Movie Crew) and update the budget of the movie by the person's wage. Be sure that the statements succeed or fail as a group and validate the success of each DML statement before proceeding to the next step. (Note: Assume each position name is unique in the Position table.

Step by Step Solution

★★★★★

3.49 Rating (152 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

CREATE PROCEDURE AddCrewMember MovieId int CrewId int Positio... View full answer

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 Accounting Questions!

As a movie stunt coordinator, you need to be sure a stunt will be safe before it is performed. If a stunt-woman is to run horizontally off the roof of a three-story building and land on a foam pad...

Movie attendance dropped 8 percent as ticket prices rose a little more than 5 percent. What is the price elasticity of demand for movie tickets could price elasticity be somewhat overestimated from...

Name some products or services that your social group uses a lot. State whether you agree or disagree with the notion that these products help to form group bonds. Support your argument with examples...

Code three calls to the procedure created in exercise 1: a. passed by position with @Vendor Var = 'Z'% and no balance range b. passed by with @Vendor Var omitted and a balance range from $200 to...

Create a stored procedure named sp Balance Range that accepts three optional parameters. The procedure should return a result set consisting of Vendor Name, Invoice Number, and Balance for each...

1. Create a view named LargeSlip using the data in the MarinaNum, SlipNum, RentalFee, BoatName, and OwnerNum columns in the MarinaSlip table for those slips with lengths of 40 feet. Display the data...

This assignment reviews object-oriented programming concepts such as classes, methods, constructors, accessor methods, and access modifiers. It makes use of an array of objects as a class data...

1. Create a view named PenguinBooks. It consists of the book code, book title, book type, and book price for every book published by Penguin USA. Display the data in the view. 2. Create a view named...

Create a stored Procedure called PreferenceDistribution() The result should count the number of votes casted, if the candidate got more than 50% of the vote, it should win the election. The round...

1. Create a stored procedure that takes a countrys name as the input parameter and outputs the details of customers in it (customer_id, first_name, last_name). 2. Create a stored procedure that takes...

The CEO of Sweet Holdings Limited recently said the company is targeting growth in the rest of Africa over the next 5 years in an effort to diversify revenue streams across a wider range of...

Hazel Corp. has just signed up for a lockbox. Management expects the lockbox to reduce the mail float by 2.1 days. Hazel Corp.s remittances average $37,000 a day and the average check is $125. The...

Partnering with communities for land claims and timber supply agreements aligns with which strategic change type? a . Adaptation b . Revolution c . Reconstruction d . Evolution

The foreman in the welding department wanted to know what value of allowance to use for a particular section of the shop. A work sampling study was authorized. Only two activity categories were...

1) Let = 25 and = 3. What percentage of the data is in the interval ( 13, 37 ) ? 2)You have a club that consists of 12 men and 13 women. They will choose a VP and secretary from the women and will...

(a) Explain the meaning of a Poisson process, and use your explanation to argue what the distribution of the sum of two independent Poisson random variables must be. You do not need to prove anything...

Q) Abdullahs mother is a wonderful cook and her specialty is baking. Abdullah is a good student and he wants to implement his knowledge. One day while enjoying homemade oven fresh cookies with her...

In which of the following zones within a lake would you expect to find a fish that specializes in eating the remains of dead organisms? Group of answer choices Profundal zone. Limnetic zone. Littoral...

Database stored procedure question Given the database table below, write a stored procedure called SP GetBCStationInfo This stored procedure will accept a single argument that represents the format...

Write a stored procedure called sp_update_movie_year that take in the following parameters: movie number movie year First, the stored procedure needs to check whether there is a record corresponding...

4. (7 marks) Write a stored procedure called AddCrewMember that accepts a movie id, crew id, position name, and wage. Ensure the wage is between $8,000 and $80,000. Add the person to the movie...

2. Write a stored procedure called update_discounts that updates the product table and increases the discount_percent by 5 percentage points (for example, from 30 to 35) for all products which have a...

Relational Database Design and SQL For each question, write the SQL statements required to generate the required results. 1. Create a stored procedure called store_information which takes one input...

Relational Database Design and SQL Please answer as soon as possible For each question, write the SQL statements required to generate the required results. 1. Create a stored procedure called...