Home Sweet Home Case Study Enhanced Entity Relationship Diagram - Management Assignment Help

Assignment Task

Case Study: Home Sweet Home
Home Sweet Home Sdn Bhd is a large property development company, which builds new houses and apartments in Malaysia.
Home Sweet Home has its head office in Kuala Lumpur but has several regional sales offices across Malaysia, including the South region, Central region, East region, and North region. At any one time, Home Sweet Home has about 10 developments in progress, some of which may be in the same city. Each development is managed by one regional office, depending on where that development is, for example, developments in Penang are managed by the North region because Penang is in the North of Malaysia.
Home Sweet Home employs numerous staffs, including sales advisors and site managers, all of which are assigned to specific developments.
The developments vary in size, ranging from about 20 apartments, to larger areas on which Home Sweet Home is building 100s of houses and 100s of apartments.
Home Sweet Home builds a variety of different house and apartment types, which differ according to the following factors:
number and size of bedrooms
number and size of reception rooms (dining room, lounge)
number of floors
type of bathroom eg. separate or ensuite
In addition, each house or apartment has a car park allocation, which can be in the form of a single garage, double garage, parking space, or carport.
Each house or apartment type has a name to represent its features, for example the house type 'Ukiran' has 3 large bedrooms, a kitchen, separate dining room, lounge, and a double garage.
Site managers are usually assigned to one development at a time, but if the development is small, they may be assigned to more than one development. It is the job of the site manager to employ the contractors to work on the properties on the development. The contractors may consist of builders, plumbers, roofers and carpenters. In addition, once a buyer has bought a property and is living in it, if they find any problems that need repair, such as a leaking tap, they will contact the site manager to get them to arrange for it to be fixed.
The job of sales advisors is to market the properties and to sell them as quickly as possible. The sales process works with potential buyers visiting the sales office and viewing the show houses. Sales advisors can then show interested buyers the types and locations of houses or apartments currently available for sales.
Once a buyer agrees to buy a specific property, he/she needs to contact their solicitor to organise the conveyance (legal transfer of the house from being owned by Home Sweet Home to the buyer). In addition, the buyer also needs to contact a mortgage broker to apply for a mortgage. Once the conveyance is under way, the buyer's solicitor will communicate with Home Sweet Home’ solicitor who will keep the sales advisor and the buyer informed of the progress of the sale.
Coursework Details:
Overview
In this assignment, you are required to design, implement, and document a database system for the property development company named Home Sweet Home Sdn Bhd.
Design a database solution for the given scenario and document the following:
Produce a complete Enhanced Entity Relationship (EER) diagram (include attributes, keys and participation constraints) for the above-mentioned scenario.
Map your Enhanced ER diagram to its corresponding relational schema.
Normalise the Appendix A to third normal form (3NF). Illustrating the normalisation process undertaken clearly and document it.

Implement the set of relations/ tables using Data Definition Language (DDL).
Enforce data integrity in the database by mapping Primary Keys (PK) and Foreign Keys (FK). Create the following queries using Data Manipulation Language (DML).
List all the property types of UKIRAN and show the total number of properties sold for each category.
List all the properties sold by Nadia in 2020.
List all the repairs of January 2021. You need to show the owner name, owner’s contact number, property address, contractor name, contractor’s contact number, problem, start date and status.
List all the staff names and show all the developments that he/she involved.
List all the developments that will be ending on 31st October 2021. You need to show the site manager names as well.
Minimum requirement of Project documentation:
 

This Management Assignment has been solved by our Management Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
    
Be it a used or new solution, the quality of the work submitted by our assignment Experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.