I meed the Answer for questions 6 ,7,8,9,10,11,12,13

achine Shop is a small job shop that does machining of components for custom- ftished products. The customers give ACME engineering drawings of parts machinino to organize some basic information on the customers' parts and their machining requirements and request usedastl poduction 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 n requirements are shown here. The meaning of the tables is as follows: PART-The parts produced by ACME PROCESS PLAN MACHINE-The machines used to manufacture the parts The 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). [ DRAWING-NO] CONSTRAINT (INDEX1) PRINARY KEY (PART NO) CREATE TABLE PROCESS PLAN [PROCESS PLAN ID) [OP_NO] 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 [MACHINE ID] MACHINE DESC) CHAR (10) CHAR (10), CHAR(10) SMALLINT CHAR(20), CHAR(5), CHAR(5) SHALLINT CHAR(5). CHAR(20), CONSTRAINT [INDEX3] PRIMARY KEY (MACHINE ID)): CREATE TABLE SCHEDULE ISCHEDULE ID] PART NO] S-LOT-SIZE] S_RELEASE DATE [s_COMPLETION DATE) CONSTRAINT [INDEX4) PRIMARY KEY CHAR(5). CHAR(4). SHALLINT DATE, DATE SCHEDULE-ID)); MACHINE M1 M2 M3 M4 M5 M6 M7 J&L Turret lathe 6 Milwaukee 4 Cross Turret Bndgeport Saw U&L Profiler Cincinn ati Grinder Yamaguchi Dril Bridge port Mil