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

Do you believe that it is still feasible to improve cloud security after a data breach has already taken place? Do you believe that extra measures could be done to stop something similar from occurring?
When it comes to protecting minors online, are present laws adequate? If not, what additional options should be considered by governments?
Please provide more information regarding the true nature of the data breach being discussed right now.
Do the regulations that are already in place provide sufficient safeguards to prevent children less than 16 years old from being hurt online? In the event that this is not the case, what further steps may governments possibly contemplate taking?
Do those who work in information technology worry about whether or not email encryption is moral?
Ms Jane bought 2 cakes from your shop (1kg Fruit Cake and 1kg Chiffon Cake), which were delivered to her address this afternoon. Write Ms Jane a confirmation email to ensure that her order was received correctly and in good condition.
Let me explain if you've never heard of a distributed denial-of-service attack.
After a data breach has happened, is it feasible to still have an impact on the cloud's security? Is there anything further that can be done to stop this from taking place, or is there nothing else that can be done?
Do you feel that it is possible to make an impact on the security of the cloud after a data breach has already occurred? Do you think there are any additional steps that might be taken to prevent something like this from happening?
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?