PV E 125% Zoom View Add Page Format Document Insert Table Chart Text Shape Media Comment Collaborate Washington Royalty is a real estate investment firm whose business consist of acquiring properties and renting them overtime to customers. Each Customer may choose to rent multiple properties at once, or they may not be renting at the moment. . Properties can be rented to multiple customers over time, though only one customer may be renting it at once. Washington Royalty wants to record the start date, end date, and price of each rental instance to keep track of who is renting which property at any given time. Washington Royalty only deals with 2 types of customers: Renters who desire the property to live in it with their family, and investors who desire to acquire the property to sub rent it to others. All customers have a customer ID and a name. Renters are unique in that Washington Royalty keeps track of the family size. Investors are unique in that each investor owns at least one, but potentially many companies, while each company is owned by one and only one investor. Each company has its own company ID and name, and it is possible for a customer to be both a Renter and an Investor at the same time. Properties have a property ID, name and address, and can also be of multiple types. Of important consideration are Condominiums which have the unique property of possessing a set apartment quantity (for example a Condominium could refer to a single apartment, a 4-unit property, or a 100- unit property). Properties can also be commercial properties in which case Washington Royalty wants to record the class type (a measure of its quality based on letters from the alphabet with A being top quality) To simplify the process, Washington Royalty has provided us with part of the model, though it is up to us to complete it based on the specifications above. PROPERTY CUSTOMER PKPD PKCLD Cew_kam Property Name Property Address CONDOMINIUM 2.211 words 125% Zoom View E Format Document Add Page Insert Table Chart Text Shape Media Comment Collaborate Property_des CONDOMNUM PKP GOAL: For this assignment, expand the model above, and make sure to: 1. Identify all necessary entities (including associative if needed). (4nts) 2. Identify their relationships and cardinalities (one to one, one to many, optional, mandatory, etc.). (4pts) 3. Record the attributes each entity should have based on the statements above. 4pts) 4. Record the appropriate completeness constraints for any superty.ps/subtype relationships present. (Arts) 5. Record the appropriate disjointness constraints for any supertype/subtype relationships present. (Apts) 2,211 words PV E 125% Zoom View Add Page Format Document Insert Table Chart Text Shape Media Comment Collaborate Washington Royalty is a real estate investment firm whose business consist of acquiring properties and renting them overtime to customers. Each Customer may choose to rent multiple properties at once, or they may not be renting at the moment. . Properties can be rented to multiple customers over time, though only one customer may be renting it at once. Washington Royalty wants to record the start date, end date, and price of each rental instance to keep track of who is renting which property at any given time. Washington Royalty only deals with 2 types of customers: Renters who desire the property to live in it with their family, and investors who desire to acquire the property to sub rent it to others. All customers have a customer ID and a name. Renters are unique in that Washington Royalty keeps track of the family size. Investors are unique in that each investor owns at least one, but potentially many companies, while each company is owned by one and only one investor. Each company has its own company ID and name, and it is possible for a customer to be both a Renter and an Investor at the same time. Properties have a property ID, name and address, and can also be of multiple types. Of important consideration are Condominiums which have the unique property of possessing a set apartment quantity (for example a Condominium could refer to a single apartment, a 4-unit property, or a 100- unit property). Properties can also be commercial properties in which case Washington Royalty wants to record the class type (a measure of its quality based on letters from the alphabet with A being top quality) To simplify the process, Washington Royalty has provided us with part of the model, though it is up to us to complete it based on the specifications above. PROPERTY CUSTOMER PKPD PKCLD Cew_kam Property Name Property Address CONDOMINIUM 2.211 words 125% Zoom View E Format Document Add Page Insert Table Chart Text Shape Media Comment Collaborate Property_des CONDOMNUM PKP GOAL: For this assignment, expand the model above, and make sure to: 1. Identify all necessary entities (including associative if needed). (4nts) 2. Identify their relationships and cardinalities (one to one, one to many, optional, mandatory, etc.). (4pts) 3. Record the attributes each entity should have based on the statements above. 4pts) 4. Record the appropriate completeness constraints for any superty.ps/subtype relationships present. (Arts) 5. Record the appropriate disjointness constraints for any supertype/subtype relationships present. (Apts) 2,211 words