Real Estate Database

Data and Applications

Introduction

This database is of a Real Estate Agency which stores the information about the listed properties, their sellers and interested buyers. It can be used by interested buyers to look for a property according to their needs. We also store information about the agency’s agents who work as a mediator between the buyers and sellers of properties and also about the partner banks who provide financial assistance to the buyers.

Requirements

1. Pyhton Modules required - PyMySql, Tabulate
2. MySQL Server

How to Install

1. Install MySQL in Windows from here https://dev.mysql.com/doc/mysql-installation-excerpt/8.0/en/windows-install-archive.html
   For Ubuntu from here https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-18-04
   For MacOS from here https://database.guide/how-to-install-sql-server-on-a-mac/
2. For Python Libraries run these commands -
   pip install pymysql
pip install tabulate

How to Access the Database

Run these commands

1. mysql -u <Your MySQL UserName> -p < RealEstate.sql
2. python DBMS.py
3. Unique administrator ID : database are okish