Need help to get the output of this question please. I need step by step solution.(mySQL)

1. 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) Name EMP NUM EMP LNAME EMP FNAME EMP INITIAL EMP_HIREDATE JOB_CODE JOB_CODE OB DESCRIPTION JOB_CHG_HOUR OB LAST UPDATE 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