CIS 3650 Database Management Systems Fall 2022 Assignment 5 Assignment instructions Answer questions related to the scenario below in a Word document. Include your name at the top of the document and name the file using your last name. Include the ER diagram in the document using one of the following methods: - You can draw the diagram by hand, scan it or take a picture of it and insert it in the assignment document. The diagram must be clear, fully shown, and readable. If I am not able to read or view any part of the diagram, I will not consider it. - You may use any ERD tool such as SmartDraw, LucidChart, Visio, and diagrams.net (watch lecture videos for suggestions). When you use those tools, make sure your notation is accurate - some of them may not give you an accurate notation. If you use a tool, insert a copy of the diagram in the document. Again, make sure the diagram is fully shown and easy to read. - Either way, DO NOT SUBMIT a separate picture/file containing the diagram. - Upload your assignment file in the corresponding link on Blackboard. - The ERD MUST use crow's foot notation. Other notations are not acceptable. Assignment information Consider the following scenario: A real estate agent, specializing in helping students find off-campus housing, needs to create a database of off-campus rentals. She would like to create a web site to make this data available to students who wish to stay off-campus and make it easier to find properties willing to rent to students and close to campus. This is the information you gathered from your first meeting with the agent: For each rental property, the database should store data about the number of bedrooms, number of bathrooms, square footage, rent per month, type of property (apartment, duplex, house), parking garage spaces and whether pets are allowed or not. For each property, the reals estate agent would like to store owner information such as name, email, and phone number. Even if a property has multiple owners, for rental purposes, only one owner should be listed for a property. She would also like to store reviews of past tenants about properties. For each review, the database should store the date of the review, the rating and comment. A specific review is only for one property and provided by one tenant. For the tenant providing the review, she would like to know the name of the tenant, name, email and user name that will show on the web site. The process of verifying that the person providing the review was actually a renter of the property is outside the scope of this assignment. 1. Identify the entities that these data suggest and the corresponding attributes. If none of the attributes can be used as identifier, add your own identifier attributes (for example, rental ID or rental number). 2. Draw an ER diagram with the entities and attributes you identified. Mark maximum and minimum cardinalities on the diagram in the appropriate notation using crow's foot notation. Do not include foreign keys to model the relationship between the tables. Do NOT use the database terminology such as tables, primary key etc. in the model. 3. Enter the relationships and their cardinalities in the table below. Explain which cardinalities can be inferred from the information provided and which need to be confirmed with users. Add rows as needed. *Parent or Child terms are used only for 1:N relationships. For 1:1 or N:M relationships just put the entities in that relationship and ignore the parent/child terminology. CIS 3650 Database Management Systems Fall 2022 Assignment 5 Assignment instructions Answer questions related to the scenario below in a Word document. Include your name at the top of the document and name the file using your last name. Include the ER diagram in the document using one of the following methods: - You can draw the diagram by hand, scan it or take a picture of it and insert it in the assignment document. The diagram must be clear, fully shown, and readable. If I am not able to read or view any part of the diagram, I will not consider it. - You may use any ERD tool such as SmartDraw, LucidChart, Visio, and diagrams.net (watch lecture videos for suggestions). When you use those tools, make sure your notation is accurate - some of them may not give you an accurate notation. If you use a tool, insert a copy of the diagram in the document. Again, make sure the diagram is fully shown and easy to read. - Either way, DO NOT SUBMIT a separate picture/file containing the diagram. - Upload your assignment file in the corresponding link on Blackboard. - The ERD MUST use crow's foot notation. Other notations are not acceptable. Assignment information Consider the following scenario: A real estate agent, specializing in helping students find off-campus housing, needs to create a database of off-campus rentals. She would like to create a web site to make this data available to students who wish to stay off-campus and make it easier to find properties willing to rent to students and close to campus. This is the information you gathered from your first meeting with the agent: For each rental property, the database should store data about the number of bedrooms, number of bathrooms, square footage, rent per month, type of property (apartment, duplex, house), parking garage spaces and whether pets are allowed or not. For each property, the reals estate agent would like to store owner information such as name, email, and phone number. Even if a property has multiple owners, for rental purposes, only one owner should be listed for a property. She would also like to store reviews of past tenants about properties. For each review, the database should store the date of the review, the rating and comment. A specific review is only for one property and provided by one tenant. For the tenant providing the review, she would like to know the name of the tenant, name, email and user name that will show on the web site. The process of verifying that the person providing the review was actually a renter of the property is outside the scope of this assignment. 1. Identify the entities that these data suggest and the corresponding attributes. If none of the attributes can be used as identifier, add your own identifier attributes (for example, rental ID or rental number). 2. Draw an ER diagram with the entities and attributes you identified. Mark maximum and minimum cardinalities on the diagram in the appropriate notation using crow's foot notation. Do not include foreign keys to model the relationship between the tables. Do NOT use the database terminology such as tables, primary key etc. in the model. 3. Enter the relationships and their cardinalities in the table below. Explain which cardinalities can be inferred from the information provided and which need to be confirmed with users. Add rows as needed. *Parent or Child terms are used only for 1:N relationships. For 1:1 or N:M relationships just put the entities in that relationship and ignore the parent/child terminology