We're Open
+44 7340 9595 39
+44 20 3239 6980

REAL ESTATE COMPANY NEEDS TO IMPLEMENT A DATABASE TO MANAGE PROPERTIES

  100% Pass and No Plagiarism Guaranteed

REAL ESTATE COMPANY NEEDS TO IMPLEMENT A DATABASE TO MANAGE PROPERTIES

In this assignment (assignment-1), you are to implement the data modelling for a database that is based on the following application scenario.

 

The application scenario

 

The Best Home real estate company needs to implement a database to manage properties. The real estate has delegated this task to an IT service company. As an officer of the IT service company, you are delegated to be the designer and developer of the database. To accomplish this task, you will divide the design and development tasks into two assignments. In this assignment (assignment-1), you will do the data modelling. In assignment-2, you will design and implement the database and relevant SQL queries. Consequently, a successful data modelling of this assignment is also important for assignment-2.

 

The application scenario of The Best Home real estate is as follows.

 

  1. The Best Home manages two types of property, property for rent and property for sale. A property could be available at the moment, rented or sold.
  2. The people who need to be managed by the database include the property managers of The Best Home, the property owners, the customers (buyers and tenants) and the solicitors.
  3. A property manager can manage sale properties and/or rental properties. A property manager can supervise other property managers.
  4. A customer can make an application for a rental property or give an offer to a sale property.
  5. A solicitor may involve in a property sale.
  6. A property manager, a property owner, a customer or a solicitor could have a phone, a mobile and/or email contact.

 

The above application scenario was not presented in very detail for the entities or relations because one of your tasks for this assignment is to analyse and model the data in real estates. You may need to do some research about the data in real estate management and model the data with necessary attributes under some assumptions.

 

The assignment specification

 

You are to develop an ER model for the data management of The Best Home. You will need to provide the ER model to cover the data and transactions of The Best Home. Your tasks are:

 

  1. Identification and justification of entities. You need to identify all the necessary entities including super/sub type entities and justify your assumptions on those entities for the given application scenario.
  2. Identification and justification of relationships. You need to identify all the necessary relationships and their cardinalities and justify your assumptions on those relationships/cardinalities for the given application scenario.
  3. An ER diagram. You need to use the standard notations (as given in the textbook) to present the ER diagram, clearly representing entities and relationships, cardinalities and primary and 2 foreign keys and using super types and sub types. The M:N relationship between entities is not allowed for the diagram. Thus you will need to translate an M:N relationship into multiple 1:M relationships with the aid of associative entities.

 

Note: use of a formal modelling tool such as Microsoft Visio is not required for the ER modelling. You can use any drawing tools to create the ER diagram and put it into the document.

 

Submission

 

Your assignment must be detailed in and submitted as a Word document via the online submission system. Any email or hardcopy submission will not be accepted. Any late submissions of assignment will not be accepted after the marked assignment has been released.

 

The Marking Criteria

 

Marking Criteria

Available Marks

The identification and justification of entities

8

1.       Whether the necessary entities have been identified

4

2.       Whether the composite attributes and multi-valued attributes have been identified

2

3.       Whether the primary keys and foreign keys have been identified.

2

The identification and justification of relationships

8

1.       Whether the necessary relationships have been identified

4

2.       Whether the cardinalities of the relationships are correct

4

The ER diagram

12

1.       Whether the standard notations have been used

2

2.       Whether entities and associative entities have been differentiated

2

3.       Whether the primary keys and foreign keys have been correctly represented

4

4.       Whether super types and sub types have been used

2

5.       Whether the M:N relationships have been translated into multiple 1:M relationships

2

Coverage

2

Whether the modelling has covered the application scenario

2

Sub Total for Assignment-1

30

Late Penalty

-1.5 (5% ) for each calendar day (either full or part)


100% Plagiarism Free & Custom Written,
Tailored to your instructions


International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

UK Registered Company # 11483120


100% Pass Guarantee

STILL NOT CONVINCED?

View our samples written by our professional writers to let you comprehend how your work is going to look like. We have categorised this into 3 categories with a few different subject domains

View Our Samples

We offer a £ 2999

If your assignment is plagiarised, we will give you £ 2999 in compensation

Recent Updates

Details

  • Title: REAL ESTATE COMPANY NEEDS TO IMPLEMENT A DATABASE TO MANAGE PROPERTIES
  • Price: £ 109
  • Post Date: 2018-11-09T07:04:32+00:00
  • Category: Assignment
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

 REAL ESTATE COMPANY NEEDS TO IMPLEMENT A DATABASE TO MANAGE PROPERTIES REAL ESTATE COMPANY NEEDS TO IMPLEMENT A DATABASE TO MANAGE PROPERTIES
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

Very professional and effective assignment writing service.
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

I received my order last night and now I’m writing my reviews. My assignment has all the points I needed along with a good style. The citations used are relatable and professional. The best thing is the discount I got because I recommended my friend too to use their service. I am so pleased to use this effective service. The features are also amazing, everything is good. Will come again soon!