6217

this is ER modeling – Problem Statement Please draw an E-R diagram for the Home Sweet Home case (see pages 2-7). Document Preview:

Problem Statement Please draw an E-R diagram for the Home Sweet Home case (see pages 2-7). Use the Supertype and Subtype concepts (see Chapter 4 [8th or 9th edition] or Chapter 3 [10th edition]) if needed. State any assumption you have when developing the diagram. Submit the printout of the following 3 items in class on the due date: A cover page with the following information IDS 410 – Business Database Technology Fall 2011 Assignment #1 (database analysis) E-R Modeling of Home Sweet Home Your name and the last four digits of your University ID Number (UIN) The E-R diagram and assumptions, if any, for Home Sweet Home case. Use a computer-based graphic tool to draw your diagrams such as VISIO or Gliffy (visit HYPERLINK “http://www.gliffy.com” http://www.gliffy.com). You also need to show the attributes for each entity on your E-R diagram. If you run out of space to show all the attributes in your diagram, you can indicate only the identifier of each entity on your E-R diagram. In this case, however, you also need to turn in a list of all attributes for each entity in an Excel worksheet. This case study describes a company called Home Sweet Home, which specializes in the management of properties for rent on behalf of the owners. The company offers a complete service to owners who wish to rent out their furnished property. The service provided by Home Sweet Home includes advertising the property in the local or national press (when necessary), interviewing prospective renters, organizing visits to the property by prospective renters, and negotiating the lease agreement. Once rented, Home Sweet Home assumes responsibility for the property, which involves regular property inspections by Home Sweet Home staff. Listed below is a description of the data recorded, maintained, and accessed at each branch office to support the day-to-day operation and management of Home Sweet Home. Data Requirements Branch offices Home Sweet Home has several branch…

Attachments:

er-modeling.docx