Create the database schemer.

Create the tables shown in your ERD from AT1, along with the keys, constraints and datatypes.

Make sure that you include a pair of tables with a primary and foreign key relationship

Create the following constraints that apply to the tables created in step 2. Include at least one of each: (they do not have to be on the same table) primary key. unique, not null, foreign key,

Build and install test data into each of the tables. One of the tables must be the main table that holds the event details. Please note: The data must be realistic but cannot use real names or other identifiers and at least 5 items of data per table