Answered step by step
Verified Expert Solution
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 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 ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started