|Perfect Number of Pages to Order||5-10 Pages|
An Entity-Relationship (ER) Diagram Study Assignment
Module Learning Outcomes (MLOs) assessed:
Knowledge & Understanding:
Intellectual / Professional skills & abilities:
Personal Values Attributes (Global / Cultural awareness, Ethics, Curiosity) (PVA):
Tasks of the Assignment
Part 1 (50 marks)
This part is based on the EasyMove scenario in the Appendix
(A) Using a database design approach of your choice, produce a logical design for the database to support the EasyMove online property marketing system.
Your answer must consist of ONE of the following:
(B) Based on your logical design from Part 1 (A) and the information available in the scenario, produce an SQL script file using Oracle 11g/12c.
Your submission must include:
Part 2 (30 marks)
This part is based on your answer / solution to Part 1, i.e., design and implementation of the database for the EasyMove scenario.
(A) Populate the database with some data (by generating your own data like 5 to 10 rows for each table and enough data to see meaningful output for the queries below).
(B) Answer the following queries (retrievals) using SQL and relational algebra.
1) Display details of semi-detached properties for sale having at least three bedrooms in the Jesmond area of Newcastle upon Tyne that were added to the system in the last 14 days.
2) Display details of properties sold in Newcastle, Sunderland, Gateshead or Durham for £157,000 to £279,000 in the years 2017 or 2018.
Your submission must include:
Part 3 (20 marks)
(A) Consider the EasyMove scenario in the Appendix. Produce a report for the managing director of the company elaborating on the professional, legal and ethical issues that need to be considered and make any recommendations that you think are appropriate for development and management of the database for EasyMove.
The report should be concise and comprehensive and in the region of 800-900 words. You should use Harvard style of citation and referencing by following the guidelines in Pears and Shields (2008).
(B) Compare and contrast different approaches to database design (e.g., entity relationship modelling, normalisation, etc.) and briefly justify the approach you have used for answering Part 1 (A).
The report should be concise and comprehensive and in the region of 600-700 words. You should consult a range of literature (e.g., database text books, journal and conference articles, and quality websites). Again you should use Harvard style of citation and referencing by following the guidelines in Pears and Shields (2008).
Pears, R. and Shields, G. (2008) Cite them right: the essential referencing guide. (Accessed: 19 September 2018).
EasyMove is a consortium of independent nation-wide estate agents, which operates in a virtual manner and provides a single online portal for marketing / advertising properties for sale and renting. Its basic role is to bring landlords and prospective buyers & tenants together.
Clients could be landlords, prospective buyers and tenants. Landlords register their properties for sale or renting at individual estate agents. When a client wishes to view a property, their details are sent to the concerned estate agent, who arranges the viewing with the landlords. It is the job of the particular local branch of the concerned estate agent to communicate with the landlord and prospective buyers or tenant to confirm the viewing.
For each estate agent, the system knows their branch offices, staff at the branches, and which properties are marketed by each estate agent and local branch. The system records data about properties sold and rented out. The details of the data requirements are as follows:
GET THIS PROJECT NOW BY CLICKING ON THIS LINK TO PLACE THE ORDER