Please create the SQL DML statements necessary to implement the below database schema as an OpenOffice database.

Please include all of the SQL statements and a screen shot that shows the structures that you implemented in OpenOffice or the database of your choice. The DML statements must accommodate the following elements:

Create statements to create tables from the entities defined as part of the Unit 4 assignment

Appropriate use of Null (and Not Null) parameters to ensure data validity

Appropriate use of constraint clauses to implement appropriate referential integrity

Use of data types and formats that is appropriate for the data in your database schema.

Appropriate use of keys including automatic generation of key values if appropriate

Please make appropriate use of Null (and Not Null) parameters to ensure data validity.

Please make appropriate use of constraint clauses to ensure the referential integrity of the relations in the schema.

Please make appropriate use of keys including the automatic generation of key values where appropriate.