help them improve the performance of the current situation and overcome the problems that arise nowadays. Currently, BahRealEstate uses manual system to record their tenants, property owners and other business information.

The Real Estate Management System is a web$-$based application that allows property managers to manage their properties, rental listings, and tenants. This system helps streamline the property management process by providing a centralized location for storing property and tenant information, tracking rental listings, and managing maintenance requests.

ER and database tables:

To get you started with of the project, assume that the designer of the database has come up with an appropriate ER diagram. A suggested set of tables are given below.

$\backslash$table$[[$properties$,$property$\_$owners,property$\_$listings,Tenants,Rental$\_$agreements,Maintenance$\_$Requests$],[$property$\_$id$,$owner$\_$id$,$listing$\_$id$,$tenant$\_$id$,$rental$\_$id$,$request$\_$id$],[$address$,$name,property$\_$id$,$name,listing$\_$id$,$property$\_$id$],[$city$,$phone$\_$number,owner$\_$id$,$phone$\_$number,tenant$\_$id$,$tenant$\_$id$],[$size$,$email,price,email,start$\_$date,request$\_$date$],[$num$\_$bedrooms,,status,,end$\_$date,description$],[$num$\_$bathrooms,,description,,rent,status$]]$

The system has several main components $($APEX$)$:

Properties Management: This component allows property managers to manage their properties. They can add, edit, and delete properties, as well as view details such as the address, number of bedrooms and bathrooms, and amenities.

Rental Listings Management: This component allows property managers to create and manage rental listings. They can add, edit, and delete rental listings, as well as view details such as the property owner, price, and description.

Tenant Management: This component allows property managers to manage their tenants. They can add, edit, and delete tenants, as well as view details such as the tenant's name, phone number, and email.

Rental Agreements Management: This component allows property managers to manage their lease agreements. They can create, edit, and delete lease agreements, as well as view details such as the start and end dates of the lease, the rent amount, and the associated rental listing and tenant.

Maintenance Requests Management: This component allows property managers to submit maintenance requests for their rented properties. Property managers can view and manage these requests.

Tenant$\_$services: This component allows property managers to see the complete info about the tenant and all details of the maintenance requests associated with the tenant.

Reports: This component allows property managers to view different types of reports. Be creative.

Sequences:

Most of the tables will require their own sequence to automatically generate unique primary keys. Make sure that you create such sequences and later use them in your code in INSERT statements. Add triggers if needed to enforce the generation.