Create an ERD, the next step is to create the objects (attributes, entities & relationships etc) as defined in the ERD using SQL DDL statements which will include the following:

1.Drop statements for all objects in the lab project (drop existing objects first so that you can rerun your script without error).

2.Create statements for all tables and keys of your project.

3.Create indexes on natural key columns, foreign keys, and other columns that will be frequently used as query filters (i.e., Columns in the WHERE clause).

4.Create at least two views.

5.Create at least two sequences.

6.Create at least two triggers.

7.Check content of the catalog/data dictionary.

Item 7 (above) should contain SQL SELECT statements to query DBMS catalog/data dictionary (such as user_objects or user_tables) to demonstrate all objects are created successfully.