I need answers for questions 9,10

achine Shop is a small job shop that does machining of components for custom- shed products. The customers give ACME engineering drawings of parts ers that assemble fii machinino to organize some basic information on the customers' parts and their machining requirements and request usedastl production of parts from ACME as needed. The manager of the machine shop has try t as well as scheduling information based on orders. The tables and uirements are shown here. The meaning of the tables is as follows: PART-The parts produced by ACME PROCESS PLAN The MACHINE-The machines used to manufacture the parts operations that must be performed to manufacture the parts LE A set of production schedules for part manufacture CREATE TABLE PART [PART No] CHAR(41, PART DESC) CHAR (20). MATERIAL ID) [PROCESS_PLAN ID] CHAR (10), [ DRAW ING-NO] CONSTRAINT (INDEX1) PRINARY KEY (PART NO) CREATE TABLE PROCESS PLAN [PROCESS PLAN ID) CHAR (10), CHAR (10), CHAR (10), SMALLINT CHAR(20), CHAR(5), CHAR(5) SHALLINT OP DESc] [MACHINE ID] ITOOLING ID) STD SU NIN STD UNIT NACH NIN CONSTRAINT [INDEX2) PRIMARY KEY (PROCESS PLAN ID, OP NO)): CREATE TABLE MACHINE (IMACHINE ID] MACHINE DESC) CHAR(5). CHAR (20), CONSTRAINT [INDEX3] PRIMARY KEY (MACHINE ID)): CREATE TABLE SCHEDULE ISCHEDULE ID] PART NO] stor_srzE] S_RELEASE DATE [S-COMPLETION-DATE) CONSTRAINT [INDEX4) PRIMARY KEY CHAR(5). CHAR(4). SHALLINT DATE, DATE, SCHEDULE-ID)); MACHINE M1 Turret lathe M3 M4 MS M6 M7 Milwaukee 4 Cross Turret Bnidgeport Saw UL Profiler Cincinn ati Grinder Yamaguchi Drill Bridgeport Mil PART PART NO PART DESC MATERIAL ID PROCESS PLAN ID DRAWING NO PP250 RM302PP125 PP101 RM501PP280 PP180 PP105 RM201 RM210 RM302 1002 1010 1011 Cam Plate Shatt Mounting Bracket RM501 109 1022 SCHEDULE SCHEDULE ID PART NO S LOT SIZE S RELEASE DATE S COMPLETION DATE S210 S211 S212 S213 S214 1011 1015 1022 20 15 4/1/06 4/1/06 4/206 4/3/06 4/5/06 4/6/06 12 4/2/06 PROCESS PLAN STD-UHITIMC 2 15 1 cut round stock M4 2 profile cam M5 3 drill pin hole M7 -1| cut bar stock TM14 M2 T210 T50 T101 T400 T25 T102 T210 PP101 PP101 PP101 PP105 plane slot 3 drill mounting M7 1 cut round stock M4 2 20 PP125 PP125 PP125 PPI80 21 turn round stockM 202 3 finish grind M6 1) cut round stock | M4C-T-IT210 turn round stock N11 -T215 cut round stock M4210 2 turn stock 3 taper angleM3 /. // M1 T215 30 PP250 PP250 4 finish g 1cut plate stock 2 mill surface M8 PP280 PP280 drill holes T101 (a) Create the database and tables in Access DBMS (b) Write the SQL code that will generate answers to the following questions: 57 The Relational Database Model (8) List the tooling that is used with each raw material without repetition in the tuple. (9) List the schedule release date. part number that will be machined, and machine ID (10) List the part number and machine ID that will be used in production on schedule (II) List just the machine ID (without duplication) that will be used by schedules released (12) Using a query/subquery, list all the part numbers that have operations with a setup (13) List the material ID and the number of pieces of raw material that will be required that will he used by schedule release date descending. release date 4/1/06. on 4/1/06. time greater than 8 minutes. for all the scheduled job releases on 4/1/06