/Database

Database for Real Estate Agency

Primary LanguagePython

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