Create the SQL statements needed to create the following tables and relationships. Please note the primary and foreign keys, nullable and non-nullable fields, and the data types. On page 253, figure 6-5 gives a more general syntax of the create table statement needed for this assignment. You also may use MySQL Workbench to help create these statements for you. Please submit the SQL statements. Here is figure 6-5 on textbook.

Figure 6-5 General syntax for CREATE TABLE statement used in data definition language CREATE TABLE tablename (column definition [table constraint).,. . [ON COMMIT (DELETE | PRESERVE) ROWS]); Where column definition : column_name (domain name | datatype [(size)]l ) [column-constraint-clause . .] [default value] [collate clausel and table constraint: [CONSTRAINT constraint_name] Constraint type [constraint_attributes] Figure 6-5 General syntax for CREATE TABLE statement used in data definition language CREATE TABLE tablename (column definition [table constraint).,. . [ON COMMIT (DELETE | PRESERVE) ROWS]); Where column definition : column_name (domain name | datatype [(size)]l ) [column-constraint-clause . .] [default value] [collate clausel and table constraint: [CONSTRAINT constraint_name] Constraint type [constraint_attributes]