Please Help, I'm desperate! Manufacturing Athletic Gear (MAG) is a company that produces a variety of exercise bicycles andother fitness equipment. You are writing queries that will form the basis of several reports that theusers have requested from the system. The data that you will be working with is a small subset of thedata that were generated for use while developing and testing the system. Your queries must matchthe requirements given to ensure that correct results will be produced when applied to the full set oflive data.MAG ERDSCHEDULEPARTSch NumSch_Create_DateSch_Need_DateSch_Plan_QtySch_Actual_QtyPart_Num+Part_NumPart_DesciptPart_QOHJOBEQUIPMENTWORKERWork NumWork FNameWork_LNameWork_TitleWork_WageJob NumWork_NumEquip_NumPart_NumJob_Hours_WorkedJob_Qty_ProducedJob_StartTimeEqup_NumEquip_TypeEquip_Startup_CostEquip_Hourly_Run_Cost 4. Write a query to display the worker name (first and last names separated with a single space),part description, average labor cost per unit, and times produced. The average labor cost perunit is the calculated by averaging the labor cost per unit for all jobs in which that workerproduced that part. The labor cost per unit for a job is calculated as the worker's hourly wagemultiplied by the number of hours that a job ran, divided by the quantity of the part producedduring that job. The number of times produced is simply the number of jobs in which thatworker produced that part. Limit the results to only ones where the times produced is greaterthan 2. Sort the result by the average labor cost per unit in ascending order.Result:WorkerPart_Num Part DescriptAvg Labor Cost per Unit Times ProducedAlex Reiger38321/2in. threaded pedal bar$0.174Louie DePalma 13059Handlebar, left, RDAP$0.313Jeff Bennett7463Molded left fanguard$0.334Latka Gravas7462Molded right fanguard$0.464Blaine Nardo8384Solid molded chain guard$0.965Elaine Nardo13587RDAP handlebar subassembly $1.3335. Write a query to display the worker number, last name, and first name of the worker thatworked the long job ever run on a reamer.Result:WORK NUM WORK_FNAME WORK_LNAME31009JeffSanders

Manufacturing Athletic Gear (MAG) is a company that produces a variety of exercise bicycles and…

Worker Part_Num Part Descript Avg Labor Cost per Unit Times Produced Alex Reiger 3832 1/2in. threaded pedal bar $0.17 4 Louie DePalma 13059 Handlebar, left, RDAP $0.31 3 Jeff Bennett 7463 Molded left fanguard $0.33 4 Latka Gravas 7462 Molded right fanguard $0.46 4 Elaine Nardo 8384 Solid molded chain guard $0.96 5 Blaine Nardo 13587 RDAP handlebar subassembly $1.33 3 Vrite a query to display the worker number, last name, and first name of the worker that vorked the long job ever run on a reamer. esult: WORK_NUM WORK_FNAME WORK LNAME 31009 Jeff Sanders

Worker Part_Num Part Descript Avg Labor Cost per Unit Times Produced Alex Reiger 3832 1/2in. threaded pedal bar $0.17 4 Louie DePalma 13059 Handlebar, left, RDAP $0.31 3 Jeff Bennett 7463 Molded left fanguard $0.33 4 Latka Gravas 7462 Molded right fanguard $0.46 4 Elaine Nardo 8384 Solid molded chain guard $0.96 5 Blaine Nardo 13587 RDAP handlebar subassembly $1.33 3 Vrite a query to display the worker number, last name, and first name of the worker that vorked the long job ever run on a reamer. esult: WORK_NUM WORK_FNAME WORK LNAME 31009 Jeff Sanders

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

I can't see the pictures!!
Please provide more information regarding the true nature of the data breach being discussed right now.
How can you be sure that the information you save on the cloud is secure at all times? Is there any way that we can be certain that they won't sustain any injuries?
What other options does the Department of Homeland Security have to reassure the public in the event of a national emergency?
Are children under 16 safe from internet hazards with current safeguards? If this isn't true, what can government authorities do?
Can reliable information be found online, and if so, how can you be sure of its veracity?
Consider all of the information that is currently saved on the hard disc of your computer right now. Do you need to have a quick look at confidential information that's saved on your computer? What are some of the possible implications that might arise as a result of this information being lost or stolen? What preventative measures can you take to keep your electrical gadget safe?
Do you believe the government and law enforcement organizations should have access to user accounts on social media platforms like Facebook in order to investigate potential unlawful activity? What precisely is happening here?
What caused these new online crimes? I need to know where you got your information in order to reply properly?
It is discussed in great length in this article not only what causes but also its impact on society and the many solutions to cyberbullying the problem.
What is the procedure for doing a forensic inquiry on a social networking site?