CMIS 320 Lab/Homework Company Grades Wine 1. Make a .sql script file that creates the tables for the Company data that is sketched in company.txt and whose text data files are in company.zip. Be sure to include the primary and foreign keys and create and then load the tables in a correct order. b. Draw the ERD diagram for the Grades database. 2. You're taking over the wine database project left vacant by a colleague who has entered rehab after way too much "research" in the application domain. The wine_create.sql set of related tables for the database is incomplete, it is missing the foreign keys and its create tables will need to be rearranged. Draw a 1-to-many ERD diagram of the tables. Clearly indicate the parent-child relationships. Use the wine_insert.sql to insert the data into the tables. Turn in the drawing, a printout of the file of table definitions, and Select Count(*) queries of each of the tables.