The Housing Management System is a solution designed to efficiently manage housing societies, properties, tenants, and financial transactions. It automates tasks such as rent payments, maintenance tracking, and tenant management, improving operational efficiency. The system features a relational database with entities like Society, Property, Tenant, Rent Payment, and Maintenance request interconnected through relationships. SQL queries (DDL, DML), views, triggers, and stored procedures manage and manipulate the data.
The Housing Management System project aims to develop a database-driven solution to efficiently manage housing societies, properties, tenants, and related processes.
The key objectives are:
- Automate Property Management: Track property details, tenant information, and payments.
- Improve Efficiency: Streamline rent payments, maintenance requests, and tenant management.
- Provide Insights: Generate analytical reports on occupancy rates, revenue, and maintenance trends.
- Support Scalability: Design a system that can scale as the agency expands.
- Role-Based Access: Implement secure user access control for data integrity.
- Cloud Deployment: Deploy the system on AWS for reliability and accessibility.
