DB Scripts

The zip file contains the ERD for project and the script file I was working on. Getting errors, so not sure what I have incorrect. Please correct this and include the items identified below.

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

Drop statements for all objects in the project (drop existing objects first so that you can rerun your script without error).
Create statements for all tables and keys of your project.
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).
Create at least two views.
Create at least two sequences.
Create at least two triggers.
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.

The deliverable would be one file: one plain text file (.txt or .sql file) with your SQL statements only;