Property Management System
Job Description: To create a property management atmosphere that will contain the following pages:
1. Add New: A page where the properties are uploaded via an XLSX input form
2. Remove Duplicate: A page where the duplicates are fetched from the DB and removed, if any.
3. Download New: A page where the new properties will be pulled based on the parameters given on the page from the DB and exported on an Excel sheet.
4. Upload Updated: A page where the Up-to-date properties data is imported via an excel sheet.
5. Export Updated: A page where you would query records based on parameters as shown in screenshot attachment and export and updated version of properties to work on further.
6. Overview: Database overview page where all the database statistics could be seen on a click of button. You have almost all the parameters from the DB tables to filter from.
A simple database management script.