I need help with question 31. I just need help with the emp table.

Here is the data records for emp table

You can show me first few records then i will do it my by self. I just want to know syntax so i can put all data together.

30. Using the data dictionary below write the MySQL code that will create the table structure for both the JOB and EMP 1 tables. I expect that both primary and foreign keys are added to these tables as indicated in the data dictionary. I also expect if you use a foreign key that you create an INDEX for that foreign key Also add a CONSTRAINT CHECK or a CHECK that checks the JOB_CODE in EMP_1 is either 500, 501, or 502 - remember that JOB_CODE is a CHAR(3) and not a number Key Table Type Attribute (Field) Nam EMP NUM EMP LNAME EMP FNAME EMP INITIAL EMP_HIREDATE JOB_CODE JOB_CODE OB DESCRIPTION JOB CHG HOUR JOB_LAST_UPDATE e Data Declaration CHAR(3) VARCHAR(15) VARCHAR(15) CHAR(1 DATE CHAR(3) CHAR(3) VARCHAR(25) DECIMAL(12,2) DATE EMP 1 PK FK OB PK 31. Now add the data into these two tables using INSERT commands and the two files provided with the data records for each of the tables