Real Estate Database

Introduction

This database is for 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. Information is also stored 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. Python 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