Need help with transferring and creating a ddl with the following information

Write and execute$$the DDL necessary to create the database and tables to implement your design in$$MySQL$.(50$ points$)$

The names and data types for the attributes should be the same as in the$$denormalized$$table$.$ Be sure to indicate whether attributes are not$$nullable$$where appropriate. Note that attributes$$are created as$$nullable$$by default if not specified.Define all primary keys when creating your tables.$$This can be done in the CREATE TABLE statement or in a separate ALTER TABLE statement.Define all foreign key dependencies when creating your tables. This can be done in the CREATE TABLE statement or in a separate$$ALTER TABLE$$statement$.$

Write and execute the DML using INSERT INTO $...$ SELECT FROM $...$ statements to load data from the$$denormalized$$table into your normalized tables.

attached is the ERD and here is what i got so far for the coding as well as information on the Database

create database hrbrown$4\_$finalassignment;

$//$make hrbrown$4\_$finalassignment default database

$//$create table

create Table Competitor $($

$//$add attributes

$//$add PK

$//$add FK

$)$;