Write an SQL statement to create a view named ProjectInfoView that displays the ProjectName, Department (of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Write an SQL statement to create a view named ProjectInfoView that displays the ProjectName, Department (of the project), FirstName, LastName, and Hours Worked of the employees who worked on the project. After the view is created, write an SQL SELECT statement to query the view and attach the screenshot of the result in the report. Write a stored procedure ProjectEmpSearch that takes the project name as the input and returns the first name, last name, and hours worked of the employees who worked on the project by using ProjectInfoView. Call the procedure using the project name '2019 Q3 Production Plan'. Attach the screenshot of the procedure call result in the report. Write a function dbo.ProjectCost that takes the project name and hourly rate as the input and returns the project labor cost (multiply the hourly rate by the total hours worked on the project), by using Projectinfo View. Use an SQL statement to call the function to display the labor cost of each project with 35.0 as the hourly rate. Give an appropriate column name to the computed results and remove duplicate rows if applicable. Attach the screenshot of the function call result in the report. Write an SQL statement to create a view named ProjectInfoView that displays the ProjectName, Department (of the project), FirstName, LastName, and Hours Worked of the employees who worked on the project. After the view is created, write an SQL SELECT statement to query the view and attach the screenshot of the result in the report. Write a stored procedure ProjectEmpSearch that takes the project name as the input and returns the first name, last name, and hours worked of the employees who worked on the project by using ProjectInfoView. Call the procedure using the project name '2019 Q3 Production Plan'. Attach the screenshot of the procedure call result in the report. Write a function dbo.ProjectCost that takes the project name and hourly rate as the input and returns the project labor cost (multiply the hourly rate by the total hours worked on the project), by using Projectinfo View. Use an SQL statement to call the function to display the labor cost of each project with 35.0 as the hourly rate. Give an appropriate column name to the computed results and remove duplicate rows if applicable. Attach the screenshot of the function call result in the report.
Expert Answer:
Answer rating: 100% (QA)
Create View ProjectInfoView code CREATE VIEW ProjectInfoView AS SELECT PProjectName PDepartment EFir... View the full answer
Related Book For
Posted Date:
Students also viewed these databases questions
-
Jarrod Lo devised a web of lies for three years, tricking several victims many of whom he met through social media and dating apps into signing up for mobile line contracts. He took on the persona of...
-
Construct a synthetic one-year zero-coupon bond using the information. All bonds are free of default risk and have face value equal to $100. The annual coupon of 12% is paid in semi-annual...
-
The owner of Colonial Adventure Tours would like you to complete the following tasks to help him maintain his database. In the following exercises, you will use the data in the Colonial Adventure...
-
Q6). Suppose the ski patrol lowers a rescue sled and victim, having a total mass of 95.0 kg, down a 60 slope at constant speed, as shown in Figure 1 below. The coefficient of friction u between the...
-
An ASTM cast iron has minimum ultimate strengths of 30 kpsi in tension and 100 kpsi in compression. Find the factors of safety using the MNS, BCM, and MM theories for each of the following stress...
-
For 20Y2, Macklin Inc. reported a significant increase in net income. At the end of the year, John Mayer, the president, is presented with the following condensed comparative income statement:...
-
The table at the left shows the sample ages of students in a class. Find the mean, median, and mode of the ages. Are there any outliers? Which measure of central tendency best describes a typical...
-
1. How many Style A shades can be loaded into a 40-foot container? 2. How many Style B shades can be loaded into a 40-foot container? 3. How many Style C shades can be loaded into a 40-foot...
-
Rose is considering investing $5,500 dollars at the end of each year for the next 40 years. Assuming she anticipates receiving a rate of return of 6.2% compounded annually, what will be the value of...
-
Howies Bakery is one of the most popular bakeries in town, and the favorite at Howies is French bread. Each day of the week, Howies bakes a number of loaves of French bread, more or less according to...
-
It is so nice to hear that you have daily communication. I am sure the parents are so thankful for finding out daily what has been done and what is expected at home. Most of my teachers do weekly but...
-
1. What will the annual payments be on a six-year loan of $12,500 at 13 percent interest rate? 2. You've just found the perfect home. However, in order to buy it, you'll need to take out a $15,000,...
-
Green Company constructed a machine at a total cost of $63.50 million. Construction was completed at the end of 2020 and the machine was placed in service at the beginning of 2021. The machine was...
-
A benzene pipeline that is 100 ft and runs horizontally arises a leak 43 feet from the high- pressure end. It is thought that the size of the leak is 0.1 inch. The pressure at the beginning of the...
-
4. A plumber uses a rope to drag a heavy box 12 m across the shop. The rope makes an angle of 35 with the horizontal and the force applied is 280 N. How much work is done by the plumber?
-
Consider an ideal op-amp network depicted in Figure P7.3. (a) What are the terminal voltages (v_,v+) and currents (i,i+) of the inverting and non- inverting terminals, respectively. (b) Express the...
-
Let F(x, y, z) = xi + yj + zk. Evaluate the integral of F along each of the following paths. (a) c(t) = (3t, 3t, 3t), 0 t 1 (b) c(t) = (2 cos(t), 2 sin(t), 0), (c) c(t) = (2 sin(t), 0, 2 cos(t)), 0 ...
-
Draw the major product for each of the following reactions: (a) (b) (c) 1) 9-BBN 2) H2O2, NaOH 1) Disiamylborane 2) H20, NaOH
-
The computer will stop processing the loop in Review Question 6 when the intCount variable contains the number _____________________. a. 11 b. 12 c. 13 d. 14
-
What is the result of the following expression: 96 Mod 30? a. 3 b. 3.2 c. 6 d. None of the above.
-
Create a Windows Forms application. Use the following names for the project and solution, respectively: Hales Project and Hales Solution. Save the application in the VB2017\Chap04 folder. Change the...
-
Using the results of Problem 2.6, determine the invariants \(U_{i}\) and \(V_{i}\) for the AS/3501 lamina, where \(i=1,2,3,4\). Problem 2.6 Find all components of the stiffness and compliance...
-
Show how the Mohr's circles in Figure 2.17 can be used to interpret the transformed lamina stiffness \(\bar{Q}_{12}\). FIGURE 2.17 40 'n Q11 In- n> Q11 20 -U-
-
Using the results of Problem 2.6 or Problem 2.16, compare the transformed lamina stiffnesses for AS/3501 carbon/epoxy plies oriented at \(+45^{\circ}\) and \(-45^{\circ}\). Problem 2.6 Using the...
Study smarter with the SolutionInn App