Advanced Database Management Systems - Management Assignment Help

Assignment Task :

Background
You have been asked to design and construct a database system for Brunner Letting and Management, a property management company based in London, United Kingdom. They manage property portfolios for owners. A property portfolio is a set of property investments owned by an individual, a group or a company. A property is a building of some sort.
 

How the company organises its work:
Brunner Letting and Management have clients that they classify by the term “owners”. An owner will have one or more property portfolios, which will consist of one or more properties. Properties are defined as being of a particular type such as residential house, residential flat or commercial property.
A particular property will be rented by a tenant. The terms of that rental are defined as a
tenancy. Tenants are defined by type.
As well as managing the tenancies of properties Brunner Letting and Management maintain the properties by carrying out repairs when they are needed. A property repair will involve one or more members of staff and can involve one or more parts.
The system should be capable of storing all the information needed for Brunner Letting and Management to carry out their business.
Further details of the case study are shown in the documents below which give a representative example of data and can be taken as representative of a much larger data
set.

Assignment
You are required to produce a report that addresses all of the following tasks:
Task 1 
Create an ER diagram (using UML notation) of the Brunner Letting and Management system. Please state any assumptions that you make.

Task 2 
Critically assess the normalisation you have undertaken to produce a set of relations for the scenario. You should discuss the process of normalisation as general and also the specific way it has been applied in your work.

Task 3 
Create a table listing for the Brunner Letting and Management system. You should show all the attributes and identify primary and foreign keys.
 

Task 4 
Create the relevant SQL CREATE TABLE statements for implementing the Brunner Letting and Management system in a DBMS of your choice (not MS Access). You should provide screen dumps to show that the create statements have worked.

Task 5  
Populate the database with the data shown in the case study. Discuss the population of the database tables for the Brunner Letting and Management system (order of population, issues and resolutions and SQL used) supported by appropriate screen dumps.

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.