I only need assistsnce with 5,6, and 7. preferably 6 & 7

data is provided

4. Create a table named productSupplier with the following attributes, data types, and constraints: a. productId, integer, 7 characters, not null b. supplierld, integer, 7 characters, not null c. primary key is the productId and supplierld fields d. foreign key on column productId references table product column ID e. foreign key on column supplierld references table supplier column ID 5. Insert data in file product.sql into table product 6. Insert data in file employeeSupplier.sql into table employeeSupplier 7. Insert data in file productSupplier.sql into table productSupplier 8. Generate an ER Diagram using MySQL Workbench, save as a .mwb file 9. Export database frozenfood using MySQL Workbench, save as a .sql file 10. Provide written source code in a.sql file Test Cases Test Case 1 Test Case 2 Test Case 3 Table product should look like Figure 1 Verify table employeeSupplier using the SQL command in file testCase2TestCase3Code.sql, result set should look like Figure 2 Verify table productSupplier using the SQL command in file testCase2 TestCase3Code.sql, result set should look like Figure 3 ER Diagram should look like Figure 4 Test Case 4 ysql> select from product; ID I productName I product Type | description | size | quantity 1 price | lamb shank meat lamb shank in rosemary and mint sauce 10 ounce 2 | veal meat veal osso buco 15.5 ounce 3 short rib I meat | braveheart angus beef boneless short'rib | 12 ounce 4 | flank steak meat | braveheart angus beef flank steak | 2 pound 5 chicken meat | boneless chicken breasts 18 count 61 pork chops meat bacon-wrapped pork chops 4 count 7 | langoustines seafood | medium wild langoustines 7 count 8 octopus | seafood I cooked small octopus tentacles 3 count 9 shrimp seafood | red shrimp from argentina XL 12 count 10 | clams | seafood 1 coquina clams 12 count 11 | peas | vegetable extra fine french peas 2 pound 12 artichoke | vegetable | artichoke bottoms | 2 pound 13 | bean vegetable very find yellow wax beans | 2 pound 14 broccoli vegetable broccoli florets | 2 pound 15 potatoes vegetable family size smashed red potatoes 32 ounce 16 potatoes | vegetable | family size whipped sweet potatoes 32 ounce 17 potatoes | vegetable potatoes au gratin | 3 ounce 18 | rice I grain and rice | jasmine rice 2 pound 19 rice grain and rice brown, red and wild rice medley 2 pound 20 quinoa I grain and rice organic quinoa 2 pound 21 | lentils I grain and rice black beluga lentils 2 pound 22 pastry | bakery frangipane king cake 19 ounce 23 | pastry bakery chocolate croissant 3 ounce 24 | dessert | bakery I tiramisu classico 3 Oz 25 dessert | bakery | authentic french creme brulee | 5 ounce 26 pie | bakery cappuccino pie | 3 pound 27 | cake | bakery | red berry cheesecake | 3 pound 28 bread bakery | brioche burger buns | 4 count 29 | bread | bakery ciabatta sandwich 6 inch | 3 count 30 dough | bakery mini blinis | 16 count 201 9.99 15 | 11.99 40 7.99 30 16.99 56 21.99 4219.99 25 20.99 15 23.00 50 12.99 45 9.99 60 5.99 24 17.69 30 6.29 55 | 4.49 55 12.99 55 14.49 SS 8.49 45 9.99 351 9.99 26 | 12.99 1819.99 32 19.99 90 1.90 604.99 541 5.99 1036.50 12 36.50 44 4.80 28 | 3.29 26 | 4.46 30 rows in set (0.00 sec) -> mysql> SELECT concat(e.firstName, ', e.lastName) AS employee, s. supplierName AS supplier FROM employee e, supplier s, employeeSupplier es WHERE es. employeeId = e.id AND es. supplierId = s.id; employee | supplier Yvonne Prince New Direction Foods Dante Rennie | Monogram Foods Alysha Waters | Dutt and Wagner of Virginia, Inc Avaya Clarke culinary Specialties, Inc Haniya Kaiser John E. Koerner Company Nathalie Newman Diversified Foods and Seasonings LLC | Dante Guthrie | Ajinomoto Foods North America Beverley Roberts | Ascot Valley Foods Paris Solis Kellogg NA Company Umaiza Heath | AppetizersUSA 10 rows in set (0.00 sec) wsql> SELECT p.description As description, s.supplierName AS supplier FROM product p, supplier s, productSupplier ps WHERE ps.productId = p.ID -> AND ps. supplierId = S.ID; description | supplier brown, red and wild rice medley | Ajinomoto Foods North America organic quinoa Ajinomoto Foods North America black beluga lentils Ajinomoto Foods North America brioche burger buns AppetizersUSA ciabatta sandwich 6 inch AppetizersUSA mini blinis AppetizersUSA frangipane king cake Ascot Valley Foods chocolate croissant | Ascot Valley Foods tiramisu classico | Ascot Valley Foods coquina clams Culinary Specialties, Inc extra fine french peas Culinary Specialties, Inc artichoke bottoms | Culinary Specialties, Inc family size whipped sweet potatoes | Diversified Foods and Seasonings LLC potatoes au gratin | Diversified Foods and Seasonings LLC jasmine rice | Diversified Foods and Seasonings LLC | medium wild langoustines | Dutt and Wagner of Virginia, Inc | cooked small octopus tentacles | Dutt and Wagner of Virginia, Inc | red shrimp from argentina XL | Dutt and Wagner of Virginia, Inc | very find yellow wax beans | John E. Koerner Company broccoli florets John E. Koerner Company family size smashed red potatoes | John E. Koerner Company i authentic french creme brulee | Kellogg NA Company cappuccino pie | Kellogg NA Company red berry cheesecake | Kellogg NA Company braveheart angus beef flank steak Monogram Foods boneless chicken breasts | Monogram Foods bacon-wrapped pork chops Monogram Foods lamb shank in rosemary and mint sauce | New Direction Foods veal osso buco New Direction Foods braveheart angus beef boneless short rib | New Direction Foods product ID INT customer ID INT firstName VARCHAR(50) lastName VARCHAR(50) address VAROHAR (90) city VARCHAR(90) state CHAR(2) zip Code CHAR(5) phone CHAR(10) email VARCHAR(90) Indexes productName VARCHAR(90) productType VARCHAR(90) description VARCHAR(90) size VARCHAR(50) quantity INT price DECIMAL(7,2) Indexes productsupplier productId INT supplierid INT Indexes employee ID INT firstName VARCHAR(50) lastName VARCHAR(50) address VARCHAR (90) city VARCHAR(90) ++ state CHAR(2) zip Code CHAR(5) phone CHAR(10) emal VARCHAR (90) Indexes supplier ID INT supplierName VARCHAR(50) address VARCHAR(90) city VARCHAR(90) state CHAR(2) zip Code CHAR(5) phone OHAR(10) email VAROHAR(90) Indexes + employeesupplier employeeld INT ta supplierid INT Indexes 0+ Figure 4 ER Diagram insert into table employeeSupplier the primary key for each employee and supplier based on table.column employee.id and supplier.id data provided in format (, ) (, ) (, ) (, ) (, ) (, ) (, ) (, ) (, ) (, ) (, , */ (, ) (, ) (, ) (, ) (, ) (, ) (, ) (, ) (, ) (, ) (, ) (, ) (, , , , ) (, ) (, ) ) (, ) (, ) (, ) (, ) (, ) (, ) (, ) (, , ) (, , )