country
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!

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:

  1. Manually handled everything
  2. Store information regarding vendors, buyers, properties, buyer’s requirements, offers etc.

New System Requirement:

  1. Form to enter, modify or delete Clients.
  2. Form to enter, modify or delete Properties.
  3. Form to enter, modify or delete Price Ranges.
  4. Form to add or remove categories or suburbs to or from clients.
  5. Form to enter, modify or delete a client’s offer on a particular property.
  6. Change property and offer status.
  7. Report to show all available properties that meet the requirements of one particular buyer;
  8. Report to show all offers made on one particular property.
  9. 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-

  1. The data may be mismatched sometimes because manually
  2. 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-

  1. Easy to manage the large data.
  2. Easy to track the record of all clients.
  3. Easy to track the property detail.
  4. Easy to track the offers of clients.
  5. 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 buyer’s 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 Buyer’s 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)-

  1. The clients will be categorized into two types- Vendor and Buyer.
  2. Each property is related to one vendor.
  3. A buyer can offer more than one property.
  4. The successful offers cannot be deleted for 2 years.
  5. The clients who have an offer or property cannot be deleted.
  6. 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

OR

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2018). NZ Real Estate Data Management. Retrieved from https://myassignmenthelp.com/free-samples/nz-real-estate-data-management.

" NZ Real Estate Data Management." My Assignment Help, 2018, https://myassignmenthelp.com/free-samples/nz-real-estate-data-management.

My Assignment Help (2018) NZ Real Estate Data Management [Online]. Available from: https://myassignmenthelp.com/free-samples/nz-real-estate-data-management
[Accessed 08 April 2020].

My Assignment Help. ' NZ Real Estate Data Management' (My Assignment Help, 2018) <https://myassignmenthelp.com/free-samples/nz-real-estate-data-management> accessed 08 April 2020.

My Assignment Help. NZ Real Estate Data Management [Internet]. My Assignment Help. 2018 [cited 08 April 2020]. Available from: https://myassignmenthelp.com/free-samples/nz-real-estate-data-management.


MyAssignmenthelp.com is a leading name in providing PhD dissertation writing help in Australia. Our services cover a wide range of subjects including economics and marketing dissertation help. Students can easily avail our services since we provide cheap dissertation writing services. But we never compromise with the quality while providing dissertation help services . Moreover, students are also allowed to get free access to dissertation samples and use them as a future reference.

Latest Database Samples

ITECH2002 Systems Modelling

Download : 0 | Pages : 3
  • Course Code: ITECH2002
  • University: Federation University
  • Country: Australia

Answer: Background The report contains the details of the WestAust Corporation Ltd. who is looking to implement an Operations Management System. The system would be able to support the operations in the business of the organization. The organization works in the parcel system. They also provide services in the other sectors as well. The five sub-systems of the Operations Management System (OMS) for WestAust Corporation Ltd that have been identi...

Read More arrow Tags: Australia Abbotsford Management University of Sydney 

ITC548 System Analysis Project

Download : 0 | Pages : 10
  • Course Code: ITC548
  • University: Charles Sturt University
  • Country: Australia

Answer: Introduction This report aims to discuss the aspects of the implementation of the solutions of Telehealth Project. A review of the cloud based solutions along with the advantages and the disadvantages are provided in this report. The advantages and the disadvantages of the predictive SDLC approach and the advantages and the disadvantages of the Adaptive SDLC approach is provided in this approach is provided in this report. Lastly, thi...

Read More arrow

MITS5002 Software Engineering Methodology And Investments

Download : 0 | Pages : 15
  • Course Code: MITS5002
  • University: Victorian Institute Of Technology
  • Country: Australia

Answer: Introduction System is composed of different procedures that are brought together to complete a particular designated task within a specified period of time while information system is just a software used to give a particular data to it’s users. Information system in most organizations are managing and processing data as soon as the users request for the data. It can as well be used for planning long term activities in an orga...

Read More arrow

CPT140 Database Concepts And Relation

Download : 0 | Pages : 5
  • Course Code: CPT140
  • University: Royal Melbourne Institute Of Technology
  • Country: Australia

Answer: Question 1: 1.1 Give {LoanID}+: {LoanID, MemberFirstName, MemberLastName, Address, PostCode, LoanDate, ReturnDate, Title, Year, PublisherName, Year, LoanDate, ReturnDate} The closure of {LoanID} is in the above section. 1.2 Candidate Key:  MemberID – no redundant attribute MemberFirstName - redundant attribute MemberLastName – redundant attribute Address – redundant attribute PostCode – redunda...

Read More arrow

ITECH7406 Business Intelligence And Data Warehousing Enterprise Data

Download : 0 | Pages : 14
  • Course Code: ITECH7406
  • University: Federation University
  • Country: Australia

Answer: Introduction Air consist of breathable oxygen which is the most important factors for the existence of life on earth and continuously supports life on Earth. With the industrial revolution the fresh and pure air has been contaminated due to the excessive amount of increase pollutants. The presence of any substance in the air over the natural concentration level potentially impacts the effect.  Air pollution is mainly caused by t...

Read More arrow
Next
watch

Save Time & improve Grades

Just share your requirements and get customized solutions on time.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

1,247,995

Orders

4.9/5

Overall Rating

5,068

Experts

Our Amazing Features

delivery

On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

work

Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

time

24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat.

subject

Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

price

Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

755 Order Completed

95% Response Time

Douglas Cowley

Masters in Finance with Specialization in Audit

Wellington, New Zealand

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

647 Order Completed

98% Response Time

Adlina Han

Masters in Marketing with Specialization in Branding

Singapore, Singapore

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

1592 Order Completed

96% Response Time

Jane Sima

Ph.D in Psychology with Specialization in Industrial-Organizational Psychology

Singapore, Singapore

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

416 Order Completed

95% Response Time

Tyler Moore

MBA in Accounting

Washington, United States

Hire Me

FREE Tools

plagiarism

Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.

referencing

Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

calculator

Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability

1

1

1

Your Approx Earning

Live Review

Our Mission Client Satisfaction

Good work. it was on topic base, understandable and relevant. Help me to achieve great mark. Really appreciate.

flag

User Id: 78040 - 08 Apr 2020

Australia

student rating student rating student rating student rating student rating

got assignment completed on time. I had lot of important information and up to the point.

flag

User Id: 299002 - 08 Apr 2020

Australia

student rating student rating student rating student rating student rating

I was so excited to share my experience. I had Peter help me with assignment. He did and exceptional job that I couldn\'t believe it. I got an A+ PERFECT SCORE! ALL i can say is WOW! THANK YOU.

flag

User Id: 307193 - 08 Apr 2020

Australia

student rating student rating student rating student rating student rating

Excellent work from the teacher. I got excellent marks and Assignment help had given the. assignment in the time.

flag

User Id: 213317 - 08 Apr 2020

Australia

student rating student rating student rating student rating student rating
callback request mobile
Have any Query?