System Modelling Report for Estate Agent Office

Running head: SYSTEM MODELLING REPORT FOR ESTATE AGENT OFFICE
System Modelling Report for Estate Agent Office
Name of the Student
Name of the University
Author’s Note

1
SYSTEM MODELLING REPORT FOR ESTATE AGENT OFFICE
Table of Contents
Idea/Problem....................................................................................................................................2
Response..........................................................................................................................................2
Diagrams..........................................................................................................................................3
Level 0 DFD....................................................................................................................................3
Level 1 DFD....................................................................................................................................4
Data Dictionary................................................................................................................................5
ERD.................................................................................................................................................7
Z Specification.................................................................................................................................8
Bibliography....................................................................................................................................9

2
SYSTEM MODELLING REPORT FOR ESTATE AGENT OFFICE
Idea/Problem
The idea for the development of the information system is to save time and money and
helps in ensuring that the system focuses on the business problem and improve the accuracy and
response time of the system. The system is developed such that each of the users have a separate
login and the admin have all the authority. The property is maintained by the admin and the user
can add or buy property by providing the details of the property. The system is found useful for
keeping track on the account of buyers and investors of the real estate industry. The interface of
the system is needed to be aligned with the experience of the people and the system should
provide fast and easy access to the information. The user should never feel surprised and the
system operation should be predicted and is needed to store data easily.
Response
The following are the responses that are expected from the system:
Reliability – The design of the database is simple such that it can cater the original needs
of real estate agents and it is tested against all constraints during the earlier stages of
development.
Availability – The system is developed as a standalone application and is available for the
system on which the package is installed.
Maintainability – No maintenance is needed for the application since the database is
provided to the end user the user has the responsibility to manage it.
Security – Authentication and authorization is used and without it the access of the
system is denied and thus the legitimate users are allowed access to use it. Training is needed to

3
SYSTEM MODELLING REPORT FOR ESTATE AGENT OFFICE
be given such that the legitimate information of a user is not shared with outsiders and its effect
on the security of the user account and the system.
Diagrams
Level 0 DFD

4
SYSTEM MODELLING REPORT FOR ESTATE AGENT OFFICE
Level 1 DFD

5
SYSTEM MODELLING REPORT FOR ESTATE AGENT OFFICE
Data Dictionary
Table: Property_sell
P_key: sell_id
Description: Used for storing the seller and agent details
Sl. No. Field DataType Description
1 Property_type Varchar(50) Commercial/Residential
property
2 City Varchar(50) Cityname
3 Location Varchar(50) User area
4 Address Varchar(50) Address of user
5 Owner_type Varchar(50) Bedroom numbers
6 Plot_area Double(50) Land Area
Table: Postrequirement_buy
P_key: login_id
Description: Storing details of the person who wants to buy a property
Sl. No. Field DataType Description
1 Buyer_id Int(20) Buyer Id
2 State Varchar(50) Buyer state
3 Bedroom int(50) Number of bedrooms
4 Area Double(50) Land area

6
SYSTEM MODELLING REPORT FOR ESTATE AGENT OFFICE
5 Budget_min Varchar(50) Minimum land Area
6 Budget_max Varchar(50) Maximum land Area
7 Login_id Int(20) Login id of user
Table: Postrequirement_sell
P_key: login_id
Description: Storing details of the person who wants to sell a property
Sl. No. Field DataType Description
1 Property_type Varchar(50) Residential/Commercial
property
2 City Varchar(50) User city
3 Locality Varchar(50) User area
4 Address Varchar(50) User address
5 Bedrooms Int(20) Number of bedrooms
6 Bathrooms Int(20) Number of bathrooms
7 Login_id Int(20) Login id of user

7
SYSTEM MODELLING REPORT FOR ESTATE AGENT OFFICE
ERD

8
EstateAgent
AllHouses : HOUSE_ID_TYPEℙ
on_Valuation : ℙ HOUSE_ID_TYPE
ForSale : ℙHOUSE_ID_TYPE
Sold : ℙ HOUSE_ID_TYPE
Offers : ℙ OFFER_ID_TYPE
HouseOffers : OFFER_ID_TYPE ↛ HOUSE_ID_TYPE
AllHouses = on_Valuation ∪ ForSale ∪ Sold
on_Valuation ∩ ForSale ∩ Sold = ∅
dom HouseOffers = Offers
ran HouseOffers ⊆ AllHouses
SYSTEM MODELLING REPORT FOR ESTATE AGENT OFFICE
Z Specification

9
SYSTEM MODELLING REPORT FOR ESTATE AGENT OFFICE
Bibliography
Dakic, D., Stefanovic, D., Lolic, T., Sladojevic, S. and Anderla, A., 2018, March. Production
planning business process modelling using UML class diagram. In 2018 17th international
symposium infoteh-jahorina (infoteh) (pp. 1-6). IEEE.
Dennis, A., Wixom, B.H. and Roth, R.M., 2018. Systems analysis and design. John wiley &
sons.
Supriatna, A.D., 2018, November. Designing library information system using rapid application
development method. In IOP Conference Series: Materials Science and Engineering (Vol. 434,
No. 1, p. 012259). IOP Publishing.