Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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
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
icon
Related questions
Question

Please Help, I'm desperate!

Manufacturing Athletic Gear (MAG) is a company that produces a variety of exercise bicycles and other fitness equipment. You are writing queries that will form the basis of several reports that the users have requested from the system. The data that you will be working with is a small subset of the data that were generated for use while developing and testing the system. Your queries must match the requirements given to ensure that correct results will be produced when applied to the full set of live data. MAG ERD SCHEDULE PART Sch Num Sch_Create_Date Sch_Need_Date Sch_Plan_Qty Sch_Actual_Qty Part_Num +Part_Num Part_Descipt Part_QOH JOB EQUIPMENT WORKER Work Num Work FName Work_LName Work_Title Work_Wage Job Num Work_Num Equip_Num Part_Num Job_Hours_Worked Job_Qty_Produced Job_StartTime Equp_Num Equip_Type Equip_Startup_Cost Equip_Hourly_Run_Cost
Transcribed Image Text:Manufacturing Athletic Gear (MAG) is a company that produces a variety of exercise bicycles and other fitness equipment. You are writing queries that will form the basis of several reports that the users have requested from the system. The data that you will be working with is a small subset of the data that were generated for use while developing and testing the system. Your queries must match the requirements given to ensure that correct results will be produced when applied to the full set of live data. MAG ERD SCHEDULE PART Sch Num Sch_Create_Date Sch_Need_Date Sch_Plan_Qty Sch_Actual_Qty Part_Num +Part_Num Part_Descipt Part_QOH JOB EQUIPMENT WORKER Work Num Work FName Work_LName Work_Title Work_Wage Job Num Work_Num Equip_Num Part_Num Job_Hours_Worked Job_Qty_Produced Job_StartTime Equp_Num Equip_Type Equip_Startup_Cost Equip_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 per unit is the calculated by averaging the labor cost per unit for all jobs in which that worker produced that part. The labor cost per unit for a job is calculated as the worker's hourly wage multiplied by the number of hours that a job ran, divided by the quantity of the part produced during that job. The number of times produced is simply the number of jobs in which that worker produced that part. Limit the results to only ones where the times produced is greater than 2. Sort the result by the average labor cost per unit in ascending order. Result: 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 Blaine Nardo 8384 Solid molded chain guard $0.96 5 Elaine Nardo 13587 RDAP handlebar subassembly $1.33 3 5. Write a query to display the worker number, last name, and first name of the worker that worked the long job ever run on a reamer. Result: WORK NUM WORK_FNAME WORK_LNAME 31009 Jeff Sanders
Transcribed Image Text: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 per unit is the calculated by averaging the labor cost per unit for all jobs in which that worker produced that part. The labor cost per unit for a job is calculated as the worker's hourly wage multiplied by the number of hours that a job ran, divided by the quantity of the part produced during that job. The number of times produced is simply the number of jobs in which that worker produced that part. Limit the results to only ones where the times produced is greater than 2. Sort the result by the average labor cost per unit in ascending order. Result: 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 Blaine Nardo 8384 Solid molded chain guard $0.96 5 Elaine Nardo 13587 RDAP handlebar subassembly $1.33 3 5. Write a query to display the worker number, last name, and first name of the worker that worked the long job ever run on a reamer. Result: WORK NUM WORK_FNAME WORK_LNAME 31009 Jeff Sanders
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Threats
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS