Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A real-estate agency named HomeComfort which has recently been founded in Canberra wants to setup a database to accomodate the following requirements. HomeComfort has

A real-estate agency named HomeComfort which has recently been founded in Canberra wants to setup a database

A real-estate agency named HomeComfort which has recently been founded in Canberra wants to setup a database to accomodate the following requirements. HomeComfort has opened 5 offices in different districts of Canberra including Canberra Central, Belconnen, Gungahlin, Tuggeranong and Weston Creek, respectively. It is planning to open two more offices in Molonglo Valley and Woden Valley in the future. An office has a unique address but may have multiple telephone numbers. Each property is associated with exactly one office of HomeComfort, and is managed by a property manager from that office. A property can be identified by its address and has the information about the area and the number of rooms. Each employee working at HomeComfort has a tax file number (TFN), a name and an address. HomeComfort's employees are categorised into one of the following four categories: 1) office manager, 2) property manager, 3) property inspector, and 4) customer service representative. Every employee works at only one office of HomeComfort. A customer at HomeComfort is identified with a unique customer ID, a name and a contact number. A customer can buy or rent one or more properties and details about that property such as the rental period or pay-off period and price should be recorded. If a customer is not satisfied with the possessed property, this customer may submit a complaint to a customer service representative and thus a distinct reference number and detailed description of the complaint should be recorded. The relevant office manager will handle all the complaints with respect to this office and has an urgent contact number in case of emergency. Property inspectors inspect the properties and record the condition and inspection date. A property may be inspected by any of the property inspectors from the associated office, but must be inspected at least four times per year. Each property inspector has a diploma in building inspection and might have another property inspector as the supervisor. The supervisor must have a higher skill level compared to the property inspectors supervised by this supervisor. Your task is to design an Enhanced Entity Relationship (EER) diagram for the above database, which should include entities, relationships, attributes and constraints wherever appropriate. Note that you can make more assumptions if necessary and provide them with your solutions. You also need to identify the requirements that cannot be captured in an EER-diagram.

Step by Step Solution

3.46 Rating (156 Votes )

There are 3 Steps involved in it

Step: 1

Creating an EER diagram involves visualizing entities relationships attributes and constraints Heres ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Programming questions

Question

=+c) Calculate the lower control limit of the p chart.

Answered: 1 week ago