1. Write a program to display all EName and their DName from the Emp_yourld and Dept_YourID...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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] 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]
Expert Answer:
Answer rating: 100% (QA)
Solution 1 Program to display all EName and the DName from EmpyourID and DeptYourId table DECLARE CU... View the full answer
Related Book For
Thermodynamics An Engineering Approach
ISBN: 978-0073398174
8th edition
Authors: Yunus A. Cengel, Michael A. Boles
Posted Date:
Students also viewed these programming questions
-
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...
-
A firm makes three types of furniture: beds, chairs and tables. The manufacturing times required to make them, the profit and capacity available at each work centre are given below; To make one unit...
-
Hanging Valley plc has issued share capital of 2m ordinary shares, nominal value 1.00. The board of the company has decided it needs to raise 1m, net of issue costs, to finance a new product. It has...
-
Yarman Inc. began business on January 1, 2017. Its pretax financial income for the first 2 years was as follows: 2007 240,000 2008 560,000 The following items caused the only differences between...
-
The stress-strain diagram of a material can be approximated by the two line segments. If a bar having a diameter of \(80 \mathrm{~mm}\) and a length of \(1.5 \mathrm{~m}\) is made from this material,...
-
Executives at Meds-R-Us have decided to build a new production facility for the companys best-selling high-blood-pressure drug. The problem they now face is determining the size of the facility (in...
-
A plane is heading directly south towards a runway at a speed of 210 km/h. Suddenly, the plane experiences a gust of wind 75 km/h due west. What direction should the pilot aim the plane in order to...
-
On February 1, 2014, Punto Company purchased 95% of the outstanding common stock of Sara Company and 85% of the outstanding common stock of Rob Company. Immediately before the two acquisitions,...
-
Able Co. received $25,000 from a customer on April 1 for services to be provided partially in April and the rest in May. At the end of April, 47% of the services were complete. What is the amount...
-
A zero - coupon bond with a face value of $ 1 , 0 0 0 has 7 years to maturity. If investors in this bond require a return of 4 . 1 % p . a . , what will be the price that this bond will trade at ?
-
Back to Assignment Attempts 3. Chapter 3, Problem 10 As part of a study of 386 children in several schools in northwestern Vermont, some of whom had and others had not exhibited symptoms of attention...
-
First City Real Estate executives wish to build a model to predict sales prices for residential properties. Such a model will be valuable when collaborating with potential sellers who might list...
-
Finance 1 Project Analysis Case Study Background and data You have been asked to consult for St. Thaddeus College, a small, Catholic, liberal arts, for- profit college in Gastonia that specializes in...
-
6. A firm is currently producing 3,000 units of output daily by employing 20 units of labor at a price of $100 per unit and 40 units of capital at a price of $40 per unit. The marginal product of the...
-
2. For the Asset Expansion project, a company has the following cash flows: Year 1 Year 0 -$40,000 $ Year 2 10,000 $ Year 3 Year 4 Year 5 12,000 $ 15,000 $ 100,000 $ Requirement: (20 marks) Q1. Using...
-
Would you use the adjacency matrix structure or the adjacency list structure in each of the following cases? Justify your choice. a. The graph has 10,000 vertices and 20,000 edges, and it is...
-
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...
-
An undamped single-degree-of-freedom system consists of a mass \(5 \mathrm{~kg}\) and a spring of stiffness \(2000 \mathrm{~N} / \mathrm{m}\). Find the response of the system using Eq. (2.21) when...
-
An undamped single-degree-of-freedom system consists of a mass \(10 \mathrm{~kg}\) and a spring of stiffness \(1000 \mathrm{~N} / \mathrm{m}\). Determine the response of the system using Eq. (2.21)...
-
Find the response of the system described in Problem 2.60 using Eq. (2.23). Data From Problem 2.60:- An undamped single-degree-of-freedom system consists of a mass \(10 \mathrm{~kg}\) and a spring of...
Study smarter with the SolutionInn App