Case Study: CQUnited Property Management database systemCQUnited Property Management (CQUPM) is an Australian-owned businesslocated in a large city thatspecializes in management of rental property and relevant services. The management of CQUPM hasapproached you to build a relational database that will be used as the most critical backend softwarecomponent in their enterprise managementsystem so that the relevant business data will be recordedappropriately and further information query will be processed efficiently. The proposed databasesystem requires efficiently to record and track all listed properties, customers,staff and relevantrentalactivities. Consider the following user requirements carefully and design a database conceptualschema (i.e. E-R model) to support such an application.The major business of CQUPM isto manage the property rentals, where the property managers acceptentrusted rental management of the real estate from property owners. The property could be a houseor an apartment. Each property should be described and recorded with the information including theproperty type, address, the number of bedrooms, the number of bathrooms, the listed weekly rental,property photo, as well as the available date. When a customer wishes to rent a property, he/she isrequired to make an application, which will be processed by a property manager. If an application isapproved, the contract start date, end date, and weekly rental etc. must be recorded in the system.Usually, a property is managed by one property manager while a manager could take care of multiplelisted properties. A property manager also can supervise other managers. From time to time, theproperties under management may need some maintenance service or minor repair jobs (for examplewindow glass broken and replacement, electrical fault, water pipe leaking etc.). The company hascontracted the maintenance tasks to the qualified external employee, who will undertake the repairjobs as requested. The external employee could be a licensed electrician, plumber or handyman. Thedetails of the repair job and complete date must be entered the system.The people that the system needs to record include the property managers of CQUPM, the owners ofthe property, the customers and the contracted external employees. Their names, addresses, andcontact phones are essential data in the database system. In addition, you should consider one or twoextra attribute(s) to describe the property manager and the external employee.The specification of above application scenario may be not presented explicitly with every detail onthe entities or relationships in the required E-R model, because one of your tasks for this assignmentis to analyze the requirement of users, identify necessary entities and relationships, and build the E-Rdata model for the case study. You may need to do some research on the data and possible model ingeneral property management with complete attributes or under some assumptions, which shouldmake sense for such an application scenario.
Australian Expert Writers
Assignment status: Already Solved By Our Experts
(USA, AUS, UK & CA PhD. Writers)