Free Sample Assignment On NZ Real Estate Data Management

Question: Discuss about the NZ Real Estate Data Management. Answer: Introduction The New Zealand Real Estate (NZRE) in Auckland is a firm that provides the facilities to its clients in the field of property. It offers the brokerage facility to its clients. The client may be buyer or vendor. The clients offer on the property and the vendor chose the buyer to sell his property. Currently, the system is being manually handled. Now the NZRE wants to make the complete system automatic. In this assignment, I am providing the planning and designing of the database of New Zealand Real Estate (NZRE). Planning: Strategic Planning Current Processing: Manually handled everything Store information regarding vendors, buyers, properties, buyers requirements, offers etc. New System Requirement: Form to enter, modify or delete Clients. Form to enter, modify or delete Properties. Form to enter, modify or delete Price Ranges. Form to add or remove categories or suburbs to or from clients. Form to enter, modify or delete a clients offer on a particular property. Change property and offer status. Report to show all available properties that meet the requirements of one particular buyer; Report to show all offers made on one particular property. Report to show available properties, locations and the price range. Problem in current system: There are so many issues in the current system like below- The data may be mismatched sometimes because manually It is very difficult to handle large data manually. Benefits of new database system: There are so many benefits to the NZRE by the new developed system like below- Easy to manage the large data. Easy to track the record of all clients. Easy to track the property detail. Easy to track the offers of clients. Automatically accept the offers. Entities Following entities are required in the New Zealand Real Estate (NZRE) database- Client The client entity will contain the information regarding clients- buyers and vendors. PropertyCategory This entity will contain the information regarding category of property e.g. Bedroom, Bedroom with bathroom etc. Property The property entity will contain the information regarding properties of vendors that are registered to sell. Offer The offer entity will contain the information regarding offers of buyers for particular property. Requirement The requirement entity will contain the information of buyers requirements to purchase the property. Data Entity Planning Matrix Business Functions Client Property Offer Requirement Property Listing X X Client Registration X Matching of Client and Property X X X Update Client X Update Property X Add Buyers requirements X X Update Client Status X Update Offer Status X X X Update Property Status X 5 Logical Design: ER Diagram (Lucid Software Inc. 2015) (Carlo Zaniolo 1982) Business Rules Following business rules are required in the database development of New Zealand Real Estate (NZRE)- The clients will be categorized into two types- Vendor and Buyer. Each property is related to one vendor. A buyer can offer more than one property. The successful offers cannot be deleted for 2 years. The clients who have an offer or property cannot be deleted. The clients, whose status is bad, can be deleted from the database, if they have no offer. References Lucid Software Inc. 2015, ER Diagram Symbols and Meaning, [Online]. Available: https://www.sparxsystems.com/enterprise_architect_user_guide/modeling_languages/data_flow_diagrams.html [Accessed: 9-April-2017] Carlo Zaniolo, A New Normal Form for the Design of Relational Database Schemata, September 1982