A real-estate agency named HomeComfort which has recently been founded in Canberra wants to setup a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Answer rating: 100% (QA)
Creating an EER diagram involves visualizing entities relationships attributes and constraints Heres ... View the full answer
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these programming questions
-
Mei Mei, a system administrator, would like to run five jobs J1, J2, J3, J4, J5 on three computing servers S1, S2, S3. The time taken (in hours) by a server to complete a job is listed in the table...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Find the values of the parameter p > 0 for which the following series converge. k=1 k ^ ( + In k + 1/ P
-
Consider a 90% confidence interval for m. Assume s is not known. For which sample size, n = 10 or n = 20, is the critical value tc larger?
-
It costs \(\$ 10\) to produce a low-quality wallet and \(\$ 20\) to produce a high-quality wallet. Consumers cannot distinguish between the products before purchase, they do not make repeat...
-
Putnam Company owns 80 percent of Swaraj Company. The excess of acquisition cost over book value was attributed entirely to previously unrecorded identifiable intangibles. For 2017, Swaraj Company...
-
The following two comparative balance sheets and statements of income are for XYZ Company for the years 20x120x3: Income statement Calculate all ratios needed to determine if XYZ is possibly...
-
You are attempting to value a put option with an exercise price of $109 and one year to expiration. The underlying stock pays no dividends, its current price is $109, and you believe it has a 50%...
-
Your marketing research firm is preparing the final written report on a research project commissioned by a major manufacturer of lawn mowers. One objective of the project was to investigate seasonal...
-
According to the Bathtub model: Et + U = L AUt+1=sEt- fUt What is the effect on steady state unemployment if the separation rate rises (s )? O The separation rate is always zero in steady state. O If...
-
Given: Fixed costs Rs.4,000, break-even sales Rs.20,000, profit Rs.1,000, selling price per unit Rs.20. Calculate the following: (a) Sales and marginal cost of sales. (b) New break-even point if...
-
Describe two historical events that have influenced the field of public health.
-
A soccer team is playing in a tournament this weekend. The possible outcomes of a game are win or lose. In the event of a tie at the end of regulation, the teams will play overtime until one team is...
-
Question 01: Hosiery corporation purchased raw material at the start of January amounted 54,000 dollars .some additional purchases was made amounted $3,50,000. The work in process cost at the start...
-
Where should the website focus efforts to increase the conversion rate? Select one: a. Getting users to place items in the cart b. Getting customers to proceed to checkout after placing items in the...
-
The current year financial statements for Blue Water Company and Prime Fish Company are presented below. Balance sheet Cash Accounts receivable (net) Inventory Property & equipment (net) Other assets...
-
Why do markets typically lead to an efficient outcome for buyers and sellers?
-
Are associative entities also weak entities? Why or why not? If yes, is there anything special about their "weakness"?
-
Consider the example code shown in Figure 8-10. Assume that instead of accessing data from a local server, you are going to access data from a cloud provider that offers the appropriate application...
-
Write an SQL command to display each item ordered for order number 1, its standard price, and the total price for each item ordered.
-
The bank statement for G Greene for the month of March 19X6 is: You are to: (a) Write the cash book up to date, and (b) Draw up a bank reconciliation statement as on 31 March 19X6. 19X6 Mar 1 Dr Cr...
-
Following is the cash book (bank columns) of E Flynn for December 19X7: You are required to: (a) Write the cash book up to date to take the necessary items into account, and (6) Draw up a bank...
-
You are required to prepare a sales ledger control account from the following for the month of May: 19X6 May 1 Sales ledger balances 4,936 Totals for May: Sales journal 49,916 Returns inwards journal...
Study smarter with the SolutionInn App