Department 10 typically has 50 employees. a PL/SQL program to count the number of current employees...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Department 10 typically has 50 employees. a PL/SQL program to count the number of current employees in the department and how many employees need to be hired to bring the count to 50. Your solution MUST: (1) Declare a variable to hold the count of current employees (v_num_empl), a variable to hold the number to be hired (v_num_hire), and a constant to store the value 50 (c_max_empl). (2) Retrieve the count of employees currently in department 10. (3) Compute the difference using c_max_empl and v_num_empl and store the result in v_num_hire. (4) Display the current number of employees and the number of new hires needed. Include appropriate labels for the output. Use the employees table. Output: the current number of employees is 4 the number to hire is 46. Department 10 typically has 50 employees. a PL/SQL program to count the number of current employees in the department and how many employees need to be hired to bring the count to 50. Your solution MUST: (1) Declare a variable to hold the count of current employees (v_num_empl), a variable to hold the number to be hired (v_num_hire), and a constant to store the value 50 (c_max_empl). (2) Retrieve the count of employees currently in department 10. (3) Compute the difference using c_max_empl and v_num_empl and store the result in v_num_hire. (4) Display the current number of employees and the number of new hires needed. Include appropriate labels for the output. Use the employees table. Output: the current number of employees is 4 the number to hire is 46.
Expert Answer:
Answer rating: 100% (QA)
Here is a PLSQL program that counts the number of current employees in department 10 ... View the full answer
Related Book For
Database Systems Design Implementation and Management
ISBN: 978-1337627900
13th edition
Authors: Carlos Coronel, Steven Morris
Posted Date:
Students also viewed these databases questions
-
MV Corporation has debt with market value of $95 million, common equity with a book value of $95 million, and preferred stock worth $20 million outstanding. Its common equity trades at $49 per share,...
-
Write a program to count the number of times the words in an input text file occur. The WordCount Structure Define a C++ struct called WordCount that contains the following data members: An array of...
-
Write a program to count the number of times the words in an input text file occur. The WordCount Structure Define a C++ struct called WordCount that contains the following data members: An array of...
-
What conditions must be met for revenue to be recorded? Can pledges meet those conditions?
-
Let f(x) = (x 1)2 g(x) = e 2x and h(x) = 1 + in (1 2x) (a) Find the linearizations of f, g, and h at a = 0. What do you notice? How do you explain what happened? (b) Graph f, g, and h and their...
-
Trelan vansies property with a toy bass of $509 and a bou marked waine of 51 200 to a corporation in exchange be dock with a Lar market wilun of 1500 and $200 m cash ina transaction that quarles for...
-
A derivative security of European style with expiration in 1 year has this payoff: \(\max (0, \min (3 K-S, S-K))\), where \(K=10\) is the strike price and \(S\) is the price of the underlying stock...
-
A company has two products: standard and deluxe. The company expects to produce 34,300 standard units and 69,550 deluxe units. It uses activity- based costing and has prepared the following analysis...
-
Assignment 4 In this assignment you are provided information on an experiment and you are required to investigate and interpret the output which is provided below. Problem: Consider the...
-
Oasis Co., a U.S. shareholder, owns 100% of Shack Co. and 100% of Studio Co., both CFCs. Shack Co. has $300,000 of gross income, of which $50,000 is effectively connected income, and $30,000 is...
-
Choose TWO of the following statements and analyze the statement using a different theory for each statement. Describe how the leadership theory (one presented in this course) would either defend or...
-
Indicate whether each of the following statements is true or false by writing T or F in t he a nswer c olumn. Acts of an employee while performing duties of employment are considered the acts of the...
-
Indicate whether each of the following statements is true or false by writing T or F in t he a nswer c olumn. An employee who performs only mechanical acts under the employers direction and is...
-
Hughes purchased a new Lincoln Continental automobile from Al Greene, Inc., an authorized new car dealership. On the day of the sale, Hughes made a cash down payment and signed a purchase contract...
-
Ferguson contracted to buy a quantity of knitting yarn. After receipt he cut it and knitted it into sweaters. At this point, he discovered color variations from one piece to another. Ferguson refused...
-
A principal whose identity is not known to a third party who knows he or she is dealing with an agent. a. agent b. agency by necessity c. agency by ratifi cation d. apparent a uthority e. attorney in...
-
A cubic function y = f(x) satisfies the following data: f(x) 1 4 40 85 Determine the function f(x) and hence find f'(2) and "(2). 0 1 3 4
-
Archangel Corporation prepared the following variance report. Instructions Fill in the appropriate amounts or letters for the question marks in the report. ARCHANGEL CORPORATION Variance...
-
Create an ER diagram for a hardware store. Make sure that you cover (at least) store transactions, inventory, and personnel. Base your ER diagram on an appropriate set of business rules that you...
-
Using Table 11.4 as an example, create two alternative access plans.
-
Describe the difference between early and late binding. How does each of those affect the object-oriented data model? Give examples.
-
The median is less than 8 . An analysis of the data reveals that there are 10 minus signs and 8 plus signs. Use the sign test to test the given alternative hypothesis at the \(\alpha=0.05\) level of...
-
According to Colliers International, the median monthly parking rate in the United States for 2012 was \(\$ 164.80\). The data in Table 7 represent a random sample of monthly parking rates in...
-
Hypotheses: \(H_{0}: M_{D}=0\) versus \(H_{1}: M_{D}>0\) with \(n=14\) and \(T_{-}=-21\). Use the Wilcoxon matched-pairs signedranks test to test the given hypotheses at the \(\alpha=0.05\) level of...
Study smarter with the SolutionInn App