Question: Exercise 4: Consider Department and Instructor tables from University database. Create a procedure to Insert a line in Instructor table. Check if dept name is

Exercise 4: Consider Department and Instructor tables from University database. Create

Exercise 4: Consider Department and Instructor tables from University database. Create a procedure to Insert a line in Instructor table. Check if dept name is Physics, increase salary by 20%. Input parameters are ID, Name, dept_name, salary Department (dept name varchar(20), building varchar(15), budget numeric(12,2)) Instructor (ID varchar(5), name varchar(20), dept name varchar(20), salary numeric(8,2)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To create a procedure that inserts a record into the Instructor table and increases the salary by 20 ... 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 Databases Questions!

SQL (10 pts.) Database creation and querying exercise. The schema, DDL, and instance for the University database from the textbook are provided in Appendix A. The electronic form of the DDL and...

Problem 3 (Parts a-b are 3 points each, c-fare 4 points each; 22 points total) Here are some more challenging problems to try against the banking database. a) Generate a list of all cities that...

Please answer each query and display the output Query 1: Create a new table, FACULTY5, and populate it with faculties in department ID 5, using an existing table. Use faculty ID, name, and salary...

help with this database problem. University database code: drop table prereq; drop table time_slot; drop table advisor; drop table takes; drop table student; drop table teaches; drop table section;...

help with this database problem! University database code: drop table prereq; drop table time_slot; drop table advisor; drop table takes; drop table student; drop table teaches; drop table section;...

help with this database problem. University database code. drop table prereq; drop table time_slot; drop table advisor; drop table takes; drop table student; drop table teaches; drop table section;...

Database questions. Needs to be in SQL Oracle. 1. Find the names and ids of the students who have taken exactly one course in the Spring 2010 semester. 2. Find the names and ids of the students who...

Problem 4: Rank (6 points) A rank of a collection of records assigns a 1 to the top-most value it is in 1st place), a 2 to the second highest value (2nd place), and so forth. If multiple records have...

Problem 2 (Part a is 2 points, parts b-c are 3 points each; total is 8 points) Write SQL statements that define the following views. Make sure that all columns in each view's results have meaningful...

SQL script: USE [MASTER] Go CREATE DATABASE [Faculty] Go USE [Faculty] CREATE TABLE ProfRank ( ProfRankID INT CONSTRAINT ProfRank_PK PRIMARY KEY, ProfRankName NVARCHAR(30), Minimumm DECIMAL(8,2),...

Bill Lawrence has been an employee at Huntington Manufacturing for nearly fifteen years. During this time, he's steadily worked his way up from a frontline worker to management. Plaques and awards...

Explain how the Sampsons credit card decisions are related to their budget.

When actual inventory returns occur in a perpetual inventory system, which of the following happens? Multiple choice question. Credit the asset inventory account Debit the asset inventory account...

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...