Breaking News
recent

Please Help Community by G+

Real Estate Management System full documentation with DB files with download facility

Introduction

Existing System

The existing system is currently saving record (property, staff, customer, and seller) manually on registers, notebooks etc. Seller and customer record is saved via the visit to the office. If customer/seller wants to update the details of his property, he should contact the agent or visit office. If customer/seller gives any updated details regarding his property then agent have to change all the details on every record keeping register.

Existing System Analysis 

This manual record keeping of property, staff and customers are time-consuming. There is a lot of duplication and common errors are faced while entering and updating property data, making it inconsistent and unavailable at times for future use. In addition, to this, the retrieval of the information is the slow and boring task to perform. The security of data is also a concern as it is placed in cabinets that could be accessed by others.  

Proposed Solution

The existing structure should be converted to the computerized system, in which user can easily store every information regarding his system (i.e. manual records). We prefer you to make a web based system, that will be easily accessible by every customer and seller at any time. This system will also be able to track your's all previous records (i.e. 10-year-old records).

Project objective

Real Estate Management System allows user to store property, customer, seller, and staff details. It will allow users to update, search property details and use them whenever necessary. It will also be able to provide financial, sold properties, all staff, all contacts reports.

Stakeholders

  1. Government 
  2. Property Dealers
  3. Developing Team

Functional Requirements

  1. Login
  2. Search
  3. Registration

User Rights


Admin  

  1. Admin can register new agents and create logins for them
  2. Admin can update, delete, add new property and customer records

Agents 

  1. Agent can update, add new property and customer records

Customers

  1. Customer can register on website
  2. Customer can search for property

Seller

  1. Seller can register on website
  2. Seller can search for property
  3. Seller can post about his property information on website

Reports

  1. Rented Property Report
  2. Sold Property Report
  3. Staff Report
  4. Contacts Report
  5. Customers Report
  6. Seller Report
  7. Available Property Report
  8. Financial Report

Data flow diagrams (DFD)

Context Level


Level-0

Level-1 (Search & Login)


Level-1 (Registration)


Screens

Login


Registration


Search


Entity Relationship Diagram



Report Quires and Results

All Available Property Report

Quersy

select tbl_seller.name as "Seller Name" , tbl_seller.phone as "Seller Phone",
tbl_property.address as "Property Address", tbl_property.size as "Proprty Size",
tbl_property.amont as "Amount", tbl_property.catagory as "Property Catagory", tbl_property.type as "Property Type",
tbl_property.Date_R as "Date", tbl_property.noOfBedRooms as "Bedrooms", tbl_property.facilities as "Facilities"
from tbl_seller, tbl_property
where tbl_seller.sId=tbl_property.sId and tbl_property.status='available'


All Available Commercial Property Report


Query

select tbl_seller.name as "Seller Name", tbl_seller.phone as "Seller Phone",
tbl_property.address as "Property Address", tbl_property.size as "Property Size",
tbl_property.amont as "Amount", tbl_property.catagory as "Property Catagory", tbl_property.Date_R as "Date"


All Customer Report


Query

select tbl_customer.name as "Customer Name", tbl_customer.email as "Email",
tbl_customer.fax as "Fax", tbl_customer.phone as "Phone", tbl_customer.address as "Address"
from tbl_customer



All Seller Report


Query

select tbl_seller.name as "Seller Name", tbl_seller.email as "Email", tbl_seller.fax as "Fax",
tbl_seller.phone as "Phone", tbl_seller.address as "Address"
from tbl_seller

All Staff Report

Query

select tbl_agent.name as "Agent Name", tbl_agent.email as "Email", tbl_agent.phone as "Phone",
tbl_agent.address as "Address", tbl_agent.salary as "Salary" from tbl_agent


Financial Report


Query

SELECT tbl_property.amont as "Property Amount", tbl_sold_rent.commision as "Commision", tbl_agent.name as "Name" ,
tbl_expenses.cost as "Expences", tbl_expenses.reason as "Reason"
FROM tbl_expenses INNER JOIN
tbl_agent ON tbl_expenses.aId = tbl_agent.aId INNER JOIN
tbl_sold_rent ON tbl_agent.aId = tbl_sold_rent.aId INNER JOIN
tbl_property ON tbl_sold_rent.pId = tbl_property.pId


All Customer Report



Query

select tbl_customer.name as "Customer Name", tbl_seller.name as "Seller Name", tbl_seller.address as "Seller Address",
tbl_customer.address as "Customer Address", tbl_seller.email as "Seller Email", tbl_customer.email as "Customer Email",
tbl_customer.phone as "Customer Phone", tbl_seller.phone as "Seller Phone"
from tbl_seller, tbl_customer ,tbl_sold_rent where tbl_customer.cId=tbl_sold_rent.cId and tbl_seller.sId=tbl_sold_rent.pId

All Rented Property Report



Query

select tbl_seller.name as "Seller Name" , tbl_seller.phone as "Seller Phone",
tbl_property.address as "Property Address", tbl_property.size as "Proprty Size",
tbl_property.amont as "Amount", tbl_property.catagory as "Property Catagory",
tbl_property.type as "Property Type", tbl_property.Date_R as "Date"
, tbl_property.noOfBedRooms as "Bedrooms", tbl_property.facilities as "Facilities"
from tbl_seller, tbl_property
where tbl_seller.sId=tbl_property.sId and tbl_property.status='rent'

Downloading Links

Click here to download DB_Files
Click here to download full documentation

Message from author

Please like and share it with you friends, if it was helpful :)

Hassnain Jamil

Hassnain Jamil

7 comments:

  1. This points are very helpful for the improve the commercial property management services. all of us take this steps for our real estate.

    ReplyDelete
    Replies
    1. thanks
      we are developing a new real estate solution for you people.If you are interested feel free to contact

      Delete
  2. it is very helpful for anyone want to build an online property management system
    I appreciate your work

    ReplyDelete

Powered by Blogger.