Question

6-dt-content-rid-11 91 82071-1/courses/1 1025.201 860/Scanned%20from%20MIS%20Xeroxpdrag 3. (42 points) This problem was inspired by a real-world database problem found in the news: Rental-owner database seen as solution to problem properties. A municipality (city) is creating a new database to help manage problems with rental properties within the city. They need to keep track of basic information (description, address, etc.)on the properties being rented within the city. They will store information on two types of rental properties, houses and apartments. These have substantial overlap in the data being stored about them but each also has a couple of attributes that are specific to only that rental property type. Additionally, basic information is maintained on each próperty owner/landlord. One of the primary purposes of the database is to allow owners to be easier to find when needed; hence, the database should be able to store any number of phone numbers and mailing addresses that are or have been related to the property owners. Property owners and properties are related to each other in that an owner can have one to many properties and each property can be owned by one to many property owners. The date the property was purchased must also be stored. Finally, each property owner will receive a monthly statement listing the properties that the city considers them responsible for. Each owner would have zero to many statements (depending on how many statement cycles they have been in the database for) and each statement is for one and only one property owner. Each statement will contain one or more line items Each line item is associated with one and only one rental property. Each property can appear on zero to many line items. Draw an E-R diagram to represent this database. If necessary, create an association pattern only if a relationship needs additional attributes other than foreign keys Show all minimum and maximum cardinalities. that you understand what is being stored. These do not need to be shown on diagram. be certain you add modifications that would eliminate this as a problem. . Do not show attributes for entities. Some attributes are given as examples in the problem so .If there is information that would lead you to believe an attribute discussed will be multi-valued, List any non-obvious assumptions you made. .ID-Dependent vs non-iD-Dependent relationships do not have to be distinguished for this diogram (will not be a groding point).

Answer 1

Please follow the ER diagram , having all entities, attributes, their relationships with cardinality properties and specified identifiers like primary keys.