IDS 410 Homework 1 The Realty Property Management Case Study IDS 410 Business Database Technology Fall 2018 Individual Assignment # 1 (database analysis) E-R Modeling of Realty Property Management Assigned Date: See Blackboard for details Due Date: See Blackboard for details Problem Statement Please draw an E-R diagram for the Realty Property Management case (see pages 2-7). Use the Supertype and Subtype concepts (see Chapter 4 [8th or 9th edition] or Chapter 3 [10h 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: 1. A cover page with the following information IDS 410 - Business Database Technology . . . Fall 2018 Assignment #1 (database analysis) E-R Modeling of Realty Property Management Your name and the last four digits of your University ID Number (UIN) 2. The E-R diagram and assumptions, if any, for Realty Property Management case. Use a computer-based graphic tool to draw your diagrams such as Draw.io, VISIO or Gliffy (visit http://www.gliffy.com) 3. 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 Realty Property Management, 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 Realty Property Management includes advertising the property in the local or national press (when necessary), interviewing prospective renters, organizing visits to the property by prospective renters, and ncgotiating the leasc agreement. Oncc rented, Rcalty Property Management assumes responsibility for the property, which involves regular property inspections by Rcalty Propcrty Management staff. Listed below is a description of the data recorded, maintained, and accessed at cach branch office to support the day-to-day operation and management of Realty Property Management Page 1 IDS 410 Homework 1 The Realty Property Management Case Study IDS 410 Business Database Technology Fall 2018 Individual Assignment # 1 (database analysis) E-R Modeling of Realty Property Management Assigned Date: See Blackboard for details Due Date: See Blackboard for details Problem Statement Please draw an E-R diagram for the Realty Property Management case (see pages 2-7). Use the Supertype and Subtype concepts (see Chapter 4 [8th or 9th edition] or Chapter 3 [10h 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: 1. A cover page with the following information IDS 410 - Business Database Technology . . . Fall 2018 Assignment #1 (database analysis) E-R Modeling of Realty Property Management Your name and the last four digits of your University ID Number (UIN) 2. The E-R diagram and assumptions, if any, for Realty Property Management case. Use a computer-based graphic tool to draw your diagrams such as Draw.io, VISIO or Gliffy (visit http://www.gliffy.com) 3. 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 Realty Property Management, 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 Realty Property Management includes advertising the property in the local or national press (when necessary), interviewing prospective renters, organizing visits to the property by prospective renters, and ncgotiating the leasc agreement. Oncc rented, Rcalty Property Management assumes responsibility for the property, which involves regular property inspections by Rcalty Propcrty Management staff. Listed below is a description of the data recorded, maintained, and accessed at cach branch office to support the day-to-day operation and management of Realty Property Management Page 1
