I need help creating a database that has 18 - 20 tables with logical relationships (Primary Keys and Foreign Keys) defined. You need to use real life database example like Car Dealership / Banking / Manufacturing / University Library System / Payroll etc.

This database should be Oracle database having required objects (Tables, Views) including Primary Keys and Foreign Keys relationships. This project requires detailed ER Diagram describing the business purpose and its relationships with respective objects (i.e. Tables and Columns).

It requires SQL statements/Scrips for the following:

1) Dropping and Creating a Table

2) Creating a Table having Primary Key and Foreign Key constraint

3) Insert table statement to load data into the respective tables

4) Create database views

5) Select queries as per the requirement given below.