/Majestic-Rentals

Property Rental Agency which facilitates mediating between Owners of properties and the tenants.

Primary LanguageSQL

DBMS Project

This is a Property Rental Agency which facilitates mediating between Owners of a properties and the Tenants, across multiple cities in India.

Enhanced ER Model

DBMS ER Model Draft (2)

Relational Schema

DBMS Project Schema

Procedures Created

  • InsertPropertyRecord
  • GetPropertyRecords
  • GetTenantDetails
  • CreateNewUser
  • SearchProperyForRent
  • GetRentHistory
  • DeletePropertyByUser
  • RentProperty

Tech Stack

  • PL/SQL