Given the ERD in this document, write the CREATE TABLE statements to construct the tables for this database.Be sure to use reasonable data types and create all tables, attributes, primary keys, foreign keys, and “not null” constraints in your statements where appropriate. The full instruction is in the attachment file.