Suppose there are 408 work hours per year, create a view to display employee hourly rate. EMP
Fantastic news! We've Found the answer you've been seeking!
Question:
Suppose there are 408 work hours per year, create a view to display employee hourly rate.
EMP TABLE ?
EMP_PROJ ?
PROJ ?
DEPT ?
Transcribed Image Text:
3 Suppose there are 408 work hours per year, create a view to display employee hourly rate. 4 Find out the total labor cost per employee, per project. 7 Assume each employee has a cap of 100 hours per project, develop a trigger to track overtime hours when employee exceed the cap for the project. 8 If the overtime pay is twice of regular hourly rate, modify the query from question 4 and add the factor of overtime. EMPNO 1000 Steven 1007 Diana 2002 FNAME 2060 Pat William 2000 Jennifer Fay 1760 Jonathan Taylor 1740 Ellen 1444 Peter LNAME Download CSV King 731 Fondren Houston, TX 638Voss Bellaire, TX 3321 Castle Spring, TX 561 Rice Houston, TX 890 Stone Houston, TX 450 Berry Bellaire, TX 980 Fire Oak Humble, TX Vargas 975 Dallas, Houston TX M Lorentz Abel Gietz ADDRESS Whalen SEX M F F LL. M TI M F LL SALARY 30000 Programmer 24000 15000 60000 65000 65000 28000 20000 POSITION Clerk Sales Representative Manager Manager Manager Clerk Sales Representative DEPTNO 60 20 80 20 60 80 60 80 EMPNO 1000 30 PROJNO 1000 2002 10 1444 1760 1760 50 2060 20 10 20 1740 50 40 HOURSPENT 32.5 7.5 40 20 Ln 5 10 15 12 PROJNO 10 20 30 40 50 PROJNAME Product X Product Y Computerization Productz Mobile Apps DEPTNUM 20 20 60 se 60 DEPTNO 20 60 80 DEPTNAME Marketing IT Sales MGR 1760 1740 2060 3 Suppose there are 408 work hours per year, create a view to display employee hourly rate. 4 Find out the total labor cost per employee, per project. 7 Assume each employee has a cap of 100 hours per project, develop a trigger to track overtime hours when employee exceed the cap for the project. 8 If the overtime pay is twice of regular hourly rate, modify the query from question 4 and add the factor of overtime. EMPNO 1000 Steven 1007 Diana 2002 FNAME 2060 Pat William 2000 Jennifer Fay 1760 Jonathan Taylor 1740 Ellen 1444 Peter LNAME Download CSV King 731 Fondren Houston, TX 638Voss Bellaire, TX 3321 Castle Spring, TX 561 Rice Houston, TX 890 Stone Houston, TX 450 Berry Bellaire, TX 980 Fire Oak Humble, TX Vargas 975 Dallas, Houston TX M Lorentz Abel Gietz ADDRESS Whalen SEX M F F LL. M TI M F LL SALARY 30000 Programmer 24000 15000 60000 65000 65000 28000 20000 POSITION Clerk Sales Representative Manager Manager Manager Clerk Sales Representative DEPTNO 60 20 80 20 60 80 60 80 EMPNO 1000 30 PROJNO 1000 2002 10 1444 1760 1760 50 2060 20 10 20 1740 50 40 HOURSPENT 32.5 7.5 40 20 Ln 5 10 15 12 PROJNO 10 20 30 40 50 PROJNAME Product X Product Y Computerization Productz Mobile Apps DEPTNUM 20 20 60 se 60 DEPTNO 20 60 80 DEPTNAME Marketing IT Sales MGR 1760 1740 2060
Expert Answer:
Answer rating: 100% (QA)
CREATE TABLE DEPARTMENT Dname varchar25 not null Dnumber int not null Mgrssn char9 not null Mgrstartdate date primary key dnumber UNIQUE dname CREATE ... View the full answer
Related Book For
Concepts of Database Management
ISBN: 978-111182591
7th edition
Authors: Philip J. Pratt, Joseph J. Adamski
Posted Date:
Students also viewed these programming questions
-
Suppose that in an electric display sign there are three light bulbs in the first row and four light bulbs in the second row. Let X denote the number of bulbs in the first row that will be burned out...
-
Create a view consisting of the Employee and Department tables without the address, DOB, and sex attributes.
-
Suppose that work hours in New Zombie are 200 In year 1 and productivity is $8 per hour worked. What is New Zombies real GDP? If work hours increase to 210 in year 2 and productivity rises to $10 per...
-
Find the struggles faced by business (printed t-shirts) with suppliers? Explain what would be the communication plan for each stakeholder and how you'll implement the decision you have taken?
-
A glycerin pump is powered by a 5-kW electric motor. The pressure differential between the outlet and the inlet of the pump at full load is measured to be 211 kPa. If the flow ratethrough the pump is...
-
The Art League is a not-for-profit organization dedicated to promoting the arts within the community. There are two programs conducted by the Art League: (1) exhibition and sales of members' art...
-
Discuss the relationship between investment risk and the expected rate of return on an investment. Explain why accounting information is useful in evaluating the risk/return trade-off inherent in all...
-
Indicate which of the following current assets and current liabilities are operating accounts (0) and thus included in the adjustment of net income to cash flow from operating activities and which...
-
Mike has previously made $12 million of lifetime gifts. In the current year, he gifts $3 million to his spouse, $1 million to his son, and $500,000 to his church. How much gift tax must be paid on...
-
Consider the following income tax footnote information for Oracle for the fiscal year ended May 31, 2019 (fiscal year 2019). The following is a geographical breakdown of income before the provision...
-
two companies A and B injected 24 million in a failed enterprise. If the company looses were in the ratio of 2/5 : 3/10 respectively, how much did company A lose ad company B lose.
-
Distinguish between computer hardware and software.
-
Explain the importance of the following principles when running parallel search methods: task distribution load balancing tree ordering
-
This case study is based on car dealerships. How representative is this of other industries?
-
What elements are generally included in an EDP system?
-
Calculate the optical efficiency on November 13 of an evacuated tube collector array at noon and \(2 \mathrm{p} . \mathrm{m}\). if the direct normal insolation is \(600 \mathrm{~W} / \mathrm{m}^{2}\)...
-
Please estimate required rates of return (WACC) for the cash flows originating in Argentina, Brazil, and Chile from a local perspective and from a US $ perspective.
-
An access route is being constructed across a field (Figure Q8). Apart from a relatively firm strip of ground alongside the field's longer side AB, the ground is generally marshy. The route can...
-
What is an integrity constraint? When does a database have integrity?
-
When users update and retrieve data, what tasks does a DBMS perform that are hidden from the users?
-
Create a view named OrdTot. It consists of the order number and order total for each order currently on file. (The order total is the sum of the number ordered multiplied by the quoted price on each...
-
A column arrangement similar to Figure \(15-2\) is used for organic liquids. A large reservoir of water is under the column. The water is stirred and solute concentration in the water is constant....
-
For the same system as in Problem 15.D1, the high concentration \(\mathrm{C}_{\mathrm{A}, 0}=1.2 \mathrm{~kg} / \mathrm{m}^{3}\) and \(\mathrm{C}_{\mathrm{A}, \mathrm{L}}=0.9701 \mathrm{~kg} /...
-
What is the Fickian diffusivity of chlorobenzene in liquid bromobenzene at \(300 \mathrm{~K}\) when the mole fraction of chlorobenzene is 0.0332 ? Assume that the diffusivity follows an Arrhenius...
Study smarter with the SolutionInn App