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

HOME REAL ESTATE COMPANY NEEDS TO IMPLEMENT A DATABASE TO MANAGE PROPERTIES

  100% Pass and No Plagiarism Guaranteed

HOME REAL ESTATE COMPANY NEEDS TO IMPLEMENT A DATABASE TO MANAGE PROPERTIES

The Assignment-1 Specification and Marking Criteria

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

1

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 have 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

2

 

attributes have been identified

 

 

 

 

3.

Whether the primary keys and foreign keys have been

2

 

identified.

 

 

 

The identification and justification of relationships

8

 

 

 

1.

Whether the necessary relationships have been

4

 

identified

 

 

 

 

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

2

 

differentiated

 

 

 

 

3.

Whether the primary keys and foreign keys have been

4

 

correctly represented

 

 

 

 

4.

Whether super types and sub types have been used

2

 

 

 

5.

Whether the M:N relationships have been translated into

2

 

multiple 1:M relationships

 

 

 

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: HOME REAL ESTATE COMPANY NEEDS TO IMPLEMENT A DATABASE TO MANAGE PROPERTIES
  • Price: £ 109
  • Post Date: 2018-11-09T11:48:23+00:00
  • Category: Assignment
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

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

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

My psychology assignment just came on time and the overall quality is good. It’s also free from errors. I simply loved it!
Reviews: 5

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

I was worried about the plagiarism ration in my dissertation. But thanks to my dedicated writer, I received 0% plagiarism in all the chapters. I owe my writer a million thanks..!