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

Download Sample

Get 100% money back after download, simply upload your unique content* of similar no. of pages or more. We verify your content and once successfully verified 100% value credited to your wallet within 7 days.

Upload Unique Document

Document Under Evaluation

Get Credits into Your Wallet

*The content must not be available online or in our existing Database to qualify as unique.

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 09 July 2020].

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

My Assignment Help. NZ Real Estate Data Management [Internet]. My Assignment Help. 2018 [cited 09 July 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

ITECH2306 Agile Coding

Download : 0 | Pages : 4
  • Course Code: ITECH2306
  • University: Federation University
  • Country: Australia

Answer: UML Class Diagrams Before   After   Screenshots demonstrating that your JUnit tests prove that the system has worked as expected Screenshot 1:   Screenshot 1 represents passed JUnit test cases of the 7-property rate calculation when each of the ratepayer did not do any charitable work. Screenshot 2:   Screenshot 2 represents passed Junit test cases of the 7-property rate calculation when each of the ratep...

Read More arrow Tags: Australia Arlington Management University of New South Wales 

COIT20247 Database Design And Development 3

Download : 1 | Pages : 2

Answer: Entity Relationship Diagram   (Smartdraw, 2016) Assumptions and Business Rules Following business rules and assumptions are put into practice into the CQI database- A customer can insure more than one property. Each property should be attached with addresses. Each claim should be belonged to one customer. The policy premium will be on yearly basis in CQI. The policy types available at CQI are- ‘Home’, &lsquo...

Read More arrow

TCC 233 Database Management Systems

Download : 0 | Pages : 7
  • Course Code: TCC 233
  • University: Wawasan Open University
  • Country: Malaysia

Answer: About Attributes and Tuples:  In the Student Relation of figure 1, tuple is a row. Here, it has 5 tuples with 6 values that is called as 6 tuples. In general, n- tuples has a list ordered of values n.  If t1 is refer to first tuple variable for the relation STUDENT, then t1 = <S10010, Chan Wai Yee, 56A, Jalan 2/14, Taman Midah, kuala Lampur, 012-3256780, F, wai99@yahoo.com>, similarly for the other.  Tuples may ap...

Read More arrow

OIT20247 Database Design And Development

Download : 0 | Pages : 2

Answer: Business Rules Every Entity Relationship Model must have a strong set of business rules. For the CQ Insurance company’s database adaptation, the business rules that have been implemented into the ER Diagram are as follows: A customer can apply for only one of the insurance policies. He can buy the insurance for either a building policy or a home-contents policy for a particular property of his interest, or may be a building-c...

Read More arrow

ISYS616 Systems Analysis And Design

Download : 1 | Pages : 4

Answer: Reflective Journal System Analysis & Design is one of the most significant aspects of the system development projects. There are several concepts that are defined under system analysis & design. The application of these concepts shall be done to design and develop a flexible, scalable, and reliable system. I got an opportunity to apply these concepts and my understanding of the methods on Waiters on call meal-delivery system t...

Read More arrow
Next
watch

Save Time & improve Grade

Just share Requriment and get customize Solution.

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,358,337

Orders

4.9/5

Overall Rating

5,081

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

93 Order Completed

100% Response Time

Jackson Mitchell

MiM (Masters in Management) in Supply Chain Management

New Jersey, United States

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

230 Order Completed

97% Response Time

Liya Han

Master Of Science in Geotechnical Engineering (MSc Geotec)

Singapore, Singapore

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

1265 Order Completed

97% Response Time

James Cook

Masters in Management

Wellington, New Zealand

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

I really got good marks in that assignment, I wish you guys keep working like that to solve student problems with reasonable price. Thanks wkjkljtwoitqw ewrwiouie weu quie weuqwueit

flag

User Id: 401482 - 09 Jul 2020

Australia

student rating student rating student rating student rating student rating

Great work, i will recommend you to my friends and surely use your service again. Great references and APA format.

flag

User Id: 81173 - 09 Jul 2020

Australia

student rating student rating student rating student rating student rating

Worest report, they didn’t know the anything. At least they don’t read the template and waste of money and time

flag

User Id: 451873 - 08 Jul 2020

Australia

student rating student rating student rating student rating student rating

GOOD SERVICE BUT NEED TO WORK ON TIME LIMITS. THAT\'S IT. JUST NEED TO SUBMIT ON TIME.

flag

User Id: 283077 - 08 Jul 2020

Australia

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