Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 4 40 pts The ACME Machine Shop is a small job shop that does machining of components for customers that assemble finished products The
Question 4 40 pts The ACME Machine Shop is a small job shop that does machining of components for customers that assemble finished products The customers give ACME engineering drawings of parts and request production of parts from ACME as needed. Given MACHINE, PART, SCHEDULE, and PROCESS PLAN relations write the SQL code that will generate answers to the following questions: a-List the instances of parts that use raw material RM302. b-List the instances of all parts, alphabetically ordered by part description List the instances of all parts that require machine M1 d-List the machines and their average, minimum, and maximum unit machining times. e-List the tooling that is used with each raw material without repetition in the tuple. +List all the part numbers that have operations with a setup time greater than 8 minutes Do List the material and the number of pieces of raw material that will be required for all the scheduled job releases on 4/5/21 MACHINE MACHINE IDMACHINE DESC M1 DEL Turret lathe M2 #5 Milwaukee M3 14 Cross Turret 2 M4 Bridgeport Saw M5 J&L Profiler MG Cincinnati Grinder IM Yamauchi Drill MADUSELLMACINELUCY M1 p&L Turret lathe M2 5 Milwaukee MS 4 Cross Turret M4 Bridgeport Saw MS V&L Profiler MO Cincinnati Grinder MZ Yamaguchi Drill MB Bridgeport Mill PART PART NO PART_DESC MATERIAL_ID PROCESS PLAN DRAWING NO 1002 Punch RM201 PP250 402 1010 Rod RM302 PP125 467 A 1011 Cam RM210 PP101 219 1015 Plate RM501 PP280 109 1020 Shaft RM302 PP180 345 1022 Mounting Bracket RM501 PP105 203
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started