Based on the project title Real Estate Management System, write the SQL statements using the software Oracle SQL Developer

Question one:

1. Create at least three (3) tables for the mentioned system as follows:

a) The table must be fully normalized b) Each table must consist of a minimum of 5 columns c) Specify appropriate table names, column names, and column data types and column size d) Include a minimum of one (1) DATE and one (1) NUMBER data types

2. Add comments on one table and all it columns

3. Set constraints wherever applicable at the column level or table level as follows:

a) PRIMARY KEY for all tables

b) at least two (2) NOT NULL constraints

c) at least one (1) UNIQUE constraint at table level

d) at least one (1) CHECK constraint

e) link at least two tables

4. Insert any 4 records in each table with valid real information.

5. Preform any two(2) Nested functions using any of above created tables as an example

6. Create any correlated Subqueries for the system

7. Create any complex view for the above implementation