Case Study - CQ United Property Management database system

Assignment Help Database Management System
Reference no: EM132377777

Assignment -

Objectives -

  • To develop a conceptual data model diagram
  • To perform logical design (optional)

Assignment Specification - In this assignment, you need to perform the following tasks for the given case study:

  • Draw an Entity Relationship (ER) diagram and specify business rules

Case Study: CQ United Property Management database system

CQ United Property Management (CQUPM) is an Australian-owned business located in a large city that specializes in management of rental property and relevant services. The management of CQUPM has approached you to build a relational database that will be used as the most critical backend software component in their enterprise management system so that the relevant business data will be recorded appropriately and further information query will be processed efficiently. The proposed database system requires efficiently to record and track all listed properties, customers, staff and relevant rental activities. Consider the following user requirements carefully and design a database conceptual schema (i.e. E-R model) to support such an application.

The major business of CQUPM is to manage the property rentals, where the property managers accept entrusted rental management of the real estate from property owners. The property could be a house or an apartment. Each property should be described and recorded with the information including the property 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 is required to make an application, which will be processed by a property manager. If an application is approved, 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 multiple listed properties. A property manager also can supervise other managers. From time to time, the properties under management may need some maintenance service or minor repair jobs (for example window glass broken and replacement, electrical fault, water pipe leaking etc.). The company has contracted the maintenance tasks to the qualified external employee, who will undertake the repair jobs as requested. The external employee could be a licensed electrician, plumber or handyman. The details 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 of the property, the customers and the contracted external employees. Their names, addresses, and contact phones are essential data in the database system. In addition, you should consider one or two extra 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 on the entities or relationships in the required E-R model, because one of your tasks for this assignment is to analyze the requirement of users, identify necessary entities and relationships, and build the E-R data model for the case study. You may need to do some research on the data and possible model in general property management with complete attributes or under some assumptions, which should make sense for such an application scenario.

Assignment Requirements -

In this assignment, you need to create an Entity Relationship (ER) diagram relevant to the above case study Relations.

The attributes for various entities have not been purposely described in the case study so that the students are encouraged to further research and list the pertinent attributes in addition to the required identifier for each and every entity in their ERD.

1. Draw an appropriate ER diagram

Use the symbols as prescribed in your unit-textbook to draw the ER diagram (ERD) for the above case study.

Your ERD must

  • show all necessary entities, attributes and relationships
  • show identifiers/identifying attributes as necessary
  • show multi-valued attributes, if any
  • show participation and cardinality
  • show associative entities, if appropriate
  • show weak entities, if any
  • use the notation described in the set text
  • use consistent and appropriate naming for entities and attributes as specified in the unit text book

Some business rules or other aspects of the case study may not be clear to you when you read the case study. If this is the case, then you should either approach your lecturer or tutor for clarification, or you may simply make an assumption and then develop your ERD accordingly. For example, the case study might not mention all relevant participation information (also called minimum cardinalities). If so, you may make an assumption about what the minimum cardinalities might reasonably be, and then show them in your ERD accordingly. You should justify each assumption in terms of the business, for example: in the case study regarding the E-R model for customers placing an order it is assumed that each customer must have at least one order because it is assumed that the business does not record customer details until the customer places an order. To get yourself started, ask yourself, 'If I were running this business, what things I need to keep a list of?' Write those things down. For each thing, what information would you need to record about it? How can it be identified? The answers to these questions will help you to develop your ERD.

2. Assumptions and Business rules

Provide assumptions and business rules relevant to your ERD.

Reference no: EM132377777

Questions Cloud

How can the board be confident in the information : How do Key Performance Indicators help companies to manage existing risks? How can the Board be confident in the information reported on management's progress.
Business Continuity Plan And Disaster Recovery Question : Business Continuity Plan And Disaster Recovery assignment help and assessment help - What role do end users play in incident reporting?
Disney Case Study - Describe Disney main service : Disney Case Study - Guide: Describe Disney main service. What is correct about the Disney service and what can be improved to be successful
How the enigma machine has changed the world of security : In this essay, you will explain how the Enigma machine has changed the world of security to this day. You will provide a timeline of the major milestones.
Case Study - CQ United Property Management database system : Case Study: CQ United Property Management database system - Create an Entity Relationship (ER) diagram relevant to the above case study Relations
Literature review on influence of climate on agriculture : Question - Literature review on influence of climate on agriculture
HC3152 E-Business Applications Assignment problem : HC3152 E-Business Applications Assignment help and solution, Holmes Institute, Assessment help - How e-commerce companies are using Artificial Intelligence
HLTH3201 Pathophysiology Assignment Problem : HLTH3201 Pathophysiology assignment help and assessment help, Clayton State University - Create a chart that summarizes one family's health history.
Write a Reflection on Canada Indian Hospitals : Write a Reflection on Canada's Indian Hospitals, Current healthcare systems and practices in Canadian Indigenous communities and Cultural Safety in Health Care

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd