IDS 410- Business Database Technology Fall 2018 Assignment #2 (Database Design) Realty Property Management Case Assigned Date: Monday, September 24, 2018 Due Date: Submit the printout of your solution by Friday, October 5, 2018 Problem Statement For this assignment, you are to develop a relational schema based on the conceptual data model (ER diagram) from the first assignment. Your relations should be normalized to the third Normal form. For your convenience, I have included a possible solution to the first assignment (see the last page). Please use this solution as the starting point to do this second assignment. Submission 1. A cover page with the following information: IDS 410 Business Database Technology Fall 2018 Assignment #2 (Database Design) Realty Property Management Case Your Name and last four digits of UIN The printout of a relational schema for Realty Property Management Company. Use arrows from 2. foreign keys to their corresponding primary keys to show the referential integrity constraints. Use a computer-based graphic tool to draw your relational schema such as www.drawio or VISIO. IDS 410- Business Database Technology Fall 2018 Assignment #2 (Database Design) Realty Property Management Case Assigned Date: Monday, September 24, 2018 Due Date: Submit the printout of your solution by Friday, October 5, 2018 Problem Statement For this assignment, you are to develop a relational schema based on the conceptual data model (ER diagram) from the first assignment. Your relations should be normalized to the third Normal form. For your convenience, I have included a possible solution to the first assignment (see the last page). Please use this solution as the starting point to do this second assignment. Submission 1. A cover page with the following information: IDS 410 Business Database Technology Fall 2018 Assignment #2 (Database Design) Realty Property Management Case Your Name and last four digits of UIN The printout of a relational schema for Realty Property Management Company. Use arrows from 2. foreign keys to their corresponding primary keys to show the referential integrity constraints. Use a computer-based graphic tool to draw your relational schema such as www.drawio or VISIO