Sathuta Real Estate Company - Data Base Management System

This case study is designed to meet the needs of real estate comany,employees and buyers that aren't met by the current system, such as providing various types of real estate and providing massage between company and buyers.Actually company all prosses done by the employee.Based on the needs of the company, and in a way that facilitates the sale and purchase process, as well as communication between the employee and the buyer.

These days all the worlds trends towards to modern technology that is growing evolution every day and including several topics, Areal estate market study is the process of assessing a certain real estate market using historical and current data in order to determine the greatest potential investment assest in the market. Buying and selling property is one of the most time and money consuming processes. The process became more difficult for the employee and buyer as humans and real estate envolved. It is tough for a employee to keep track of all the property facts, and it will take him a long time. In addition, the buyer wastes a lot of time looking for a property that meets his needs. This program was created to assist the employee and the buyer in displaying information in a single location and searching for properties that are more accurate and fit for the individual.The Real Estate Web Application is a website for the real estate industry that is interactive, functional, and revenue...

    Functional Requirements Buyer can know about the real estate company, Buyer can view all properties shown to them.   Buyer can view some details of the properties. Employee can update his office profile. Employee can view all detail about the property.    Employee can control the visibility details about the property to the buyer.    Employee can determine if the sale was complete or not.   Employee can search for any property.   Employee can updates any details of the property. Employee can communicate with any customer by his phone number. Employee can add and make a relation with the customer and her property. The system wants to present estimated price list of the properties   Ø Non-functional Requirements The system is easy to learn. The interface design to be user friendly Rapidly move inside the system. System available 24 hours in 7 days. Buyer and employee privacy must be protected by the syste...

 Entities that need to store data system_login company property employee buyer Attributes that describe the Entities Entity Attributes                1.      system_login        login_username : (varchar)          login_passward : (int) 2.      company        com_name : (text)            com_reg_no : (int)          phone_no : (int)        address : (varchar) 3.      property        ID_no : (int)          Type : (text)        size : (varchar) ...