Question: 1. Write a program to display all EName and their DName from the Emp_yourld and Dept_YourID table using cursor with simple loop. Calculate and

1. Write a program to display all EName and their DName from the Emp_yourld and Dept_YourID table using cursor with simple loop. Calculate and Display house allowances given to the employees as per the given conditions. [5.5 Marks] Department IT HR BUS House Allowances 5% of salary 6% of salary 10% of salary 2. Write a program using a cursor with while loop to update the salary of employees in Emp_YourlD table, as per the Department Number. [6.5 Marks] Department Number 10 11 12 Increase of salary 300 200 250 Display the EName, Salary of all employees who are working in Dept No 12 only. 3. Write a Program that will allow the user to enter Employee Id and will display the Employee Name using Emp Yourld table. Include proper named exceptions if query returns more than one rows and if employee record is not available in the table. [4 Marks] 4. Write a program to display the Employee Name of the employee who is earning maximum salary in the given department number using the Emp_YourID table. Use your programming skills to enter the department number from the keyboard, using the given tables. Include a user-defined exception handler that handles the condition where value of department Number is more than 200 is not allowed, It should displays the message as 'Number is out of range'. [4 Marks]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Solution 1 Program to display all EName and the DName from EmpyourID and DeptYourId table DECLARE CU... 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 Programming Questions!

Caramel Corp. is an all-equity financed company. It has 10 million shares outstanding. The current share price is $50. Peter, an experienced corporate raider, believes that Caramel has substantial...

Bovens (2005) highlights a number of types of accountability that public and nonprofit sector employees may face, including: Organizational accountability : Accountability to superiors in...

The Julian calendar was a reform of the Roman calendar introduced by Julius Caesar in 46 BC (708 AUC). It took effect in 45 BC (709AUC). It was the predominant calendar in most of Europe, and in...

Law enforcement has employed some very controversial tactics, from the "Stop and Frisk" in New York, to ketamine injections for combative subjects. Locate two examples where the police have succeeded...

WRITE SQL QUERIES FOR THE FOLLOWING QUESTIONS WHICH IS BASED ON EMPLOYEES TABLE Below is a sample of searched CASE statement. It finds the average salary of the employees in the Employees table,...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Part 1 All code in Part 1 goes into one file called part1.c 1) Write a function that accepts two int pointers. The function should be named shiftLeft. There is no returrn value The first parameter is...

//ALL USING JAVA package questin1; import java.util.ArrayList; /** * Remove Oatmeal from the ArrayList. * Add the name of your favorite breakfast food to the ArrayList. * Add Cornflakes to the...

CSIS 112: Lab \# 3 WePaintHouses LLC: Employee HR Information Great news! You did such a wonderful job creating the painting estimator program that you have been hired by WePaintHouses LLC ance...

The frequency distribution shows the ages for a sample of 100 employees. Find the expected frequencies for each class to determine if the employee ages are normally distributed. Class boundaries...

You want to go to a park, eat at a restaurant, and see a movie. There are 3 parks, 4 restaurants, and 6 movie choices. How many different possible combinations are there? A 32.244,33.656 different...

Shay's net earnings per month are $ 4 , 0 0 0 . Shay's total monthly expenses are $ 3 , 0 0 0 . The biggest expense is rent at $ 1 , 5 0 0 . If Shay takes on a roommate who pays $ 5 0 0 per month, by...

You just won the TVM Lottery. You will receive $1 million today plus another 10 annual payments that increase by $600,000 per year. Thus, in one year, you receive $1.6 million. In two years, you get...

You are given the expected return and standard deviation of Asset 1 and Asset 2: E(R1) = 10%, 1 = 10% E(R2) = 14%, 2 = 16% The correlation between the two assets is p = 0.2. a. Calculate the expected...

A bond is currently selling in the market for $1,098.62. It has a coupon of 9% and a 20-year maturity. Using annual compounding, calculate the yield to maturity on this bond.

The estimated volatility of a domestic asset is d = 15 percent (annualized standard deviation of returns). A foreign asset has a volatility of f = 18 percent, and a correlation of p = 0.5 with the...

If managers are compensated, in part, on the basis of a bonus based on accounting earnings, they are likely to object to any tax plans that reduce reported earnings. What actions could the firm take...

Expansion into new markets exposes companies to differing market demands, R&D capabilities, functional skills, organizational processes, and managerial practices. In other words, expansion offers the...

Refrigerant-22 absorbs heat from a cooled space at 50F as it flows through an evaporator of a refrigeration system. R-22 enters the evaporator at 10F at a rate of 0.08 lbm/s with a quality of 0.3 and...

Air is compressed by a 15-kW compressor from P1 to P2. The air temperature is maintained constant at 25C during this process as a result of heat transfer to the surrounding medium at 20C. Determine...

Repeat Prob. 11-56 for a heat exchanger pressure of 0.55 MPa. Prob. 11-56 Consider a two-stage cascade refrigeration system operating between the pressure limits of 0.8 and 0.14 MPa. Each stage...

Your friend Sam has been asked to prepare appetizers for the university reception. She has an unlimited amount of ingredients and 6 hours in which to prepare them. Sam can make 300 mini-sandwiches or...

Suppose you have a comparative advantage at baking cookies, and the other volunteer has a comparative advantage at baking cupcakes. Make a proposal to the volunteer about how to split up the baking....

Eleanor and her little sister Joanna are responsible for two chores on their familys farm: gathering eggs and collecting milk. Eleanor can gather 9 dozen eggs or collect 3 gallons of milk per week....