Question: I need help with queries for these instructions. Database diagram attached from SQL Server Management Studio. a. Create an Update Stored Procedure that will update

I need help with queries for these instructions. Database diagram attached from SQL Server Management Studio.

I need help with queries for these instructions. Database diagram attached from a. Create an Update Stored Procedure that will update one record in the Person Table based on the personID, do not update the pwd, or roleID fields with this stored procedure.

b. Create a Delete Stored Procedure that will delete one record in the Person Table based on the personID, in addition delete all rows in all the association tables based that contain this personID

c. Create an Insert Stored Procedure that will insert a new row into the Person Table as well into the appropriate junction tables

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!

S10_Chap7_RQ_WPC-Database Lab This assignment is from the Kroenke book Chap 7 Review Questions (RQ). Create a new folder, WPC-Database, in the Projects folder, found in the SQL Server Management...

On SQL, Using Sport Database: IF DB_ID (N'Sports') IS NOT NULL DROP DATABASE Sports; GO CREATE DATABASE Sports; GO USE Sports; CREATE TABLE Patient ( PatientNum CHAR(4) PRIMARY KEY, LastName...

This practice lab provides you the opportunity to create tables, primary keys and foreign keys with the use of SQL commands. The lab will utilize the FLIX2YOU problem. (In Microsoft SQL studio) In...

Use the following tables and sample data for your answers to the questions in this assignment. (Please note that the tables have already been normalized.) Use MS SQL Server Management Studio to write...

Database Design and Development Homework \ # 4 1 1 ) ( 4 0 points ) Create a stored procedure in the TOM schema that meets the following specifications. - The procedure should be named spScheduleProd...

I need help on all parts, But mainly Part 4 (Enter Data) and (Update and List Data) PART II. CONCEPTUAL DATABASE MODEL (50%) GeoTab Company has contacted you to create a database for their conference...

| 4: Project Objectives After implementing the term project, students will practice: design and implement class in C# Explain the fundamental concepts of OOP Practice team work on projects and write...

This case study assignment is based on (but not same as) the Queen Anne Curiosity Shop (QACS) Case Questions at the end of Chapters 7 and 8. Since there are important differences between the...

On January 1, 2010, Gordon Company purchased 150,000 of the 200,000 issued and outstanding voting shares of Kevin Company for $1,200,000 in cash. Both companies have a December 31 year-end. As of...

We are already measuring total factor productivity. Measuring partial productivities would be of no value do you agree? Comment briefly

How much will the each semiannual coupon payment be of a 2 5 - year $ 5 , 0 0 0 bond with a 4 % coupon rate?

Question 1 5 5 pts Activities that bring cash in are called Origins Sources of cash Sales Operations Cash inflow

=+3 In what ways can an MNE improve or change its approach to IHRM?

=+2 How can HR managers develop the high level of competency in IHRM needed to meet these challenges?

=+j Describe the likely future of the IHRM department and profession.