Comolous and Apartments Because cach complex presents uniques category and complex for example, 200 o S850 per month for S1 450 per month in the Nones complex Maintenance BRMC Ke states and Presentachded by oueregory number presents and amenities ord r ental fee by o n both the apart Por ex e gory 21 B e ategory artments rent ous its apartments and complemento no conoton The BRMC agents monitor the condition of the facties when the condoon as below BRMC standards, the gentshire contractors to be to Siflesh och maintenance on by the type to the con pe that can best perform the one specic contro for for the job from that contractors are contractor may belong to several contros or types. Each maintenance of the common areas on the complex. BRMC tracks the nee d on artments and complex common areas Rentals BRMC agents negotiate rental contracts with tenants Each rent contract governs one year-long lease of an apartment Athough there is a nderd monthly rental fee for each apartment in each building en honorower rent if they see the need to do so is important to have record of the actualment for all apart ments. When there is more than one tant pers on every tenant must sign the rental contract BRMC assigns a unique tenant number to each tenant and issues them ID cards to control access Cash Receipts and Disbursements and Other Information To simplify the case, the cash resource the cashier agent and the cash rece ot and s- bursement events (although they would certainly exist) are emited. You should not model those in your solution. All agents, resources, and types are put into the database before they are linked to other classes 3. Prepare an integrated UML class diagram with classes, associations, and multiplicities. b. Using the preceding information and the following attributes st. prepare a listing of the relational tables necessary to support BRMC's processes. List the tables in the following order resources, events, agents, type mages and linking tables Attributes: Actual completion date of job Actual cost of this job Actual monthly rent Agent monthly salary Agent name Apartment category Apartment complex address Apartment square footage Apartment Category Contractor name Contractor phone number Contractor quality rating Contractor type Contractors Count of rooms in apartment Count of this type of contractor Date complex was constructed Employee Job type Maintenance job Number of available apartments in this Category Projected completion date of job Rental contract date Rental contract Standard cost for this job type Standard monthly rent Tenant credit rating Tenant IDF Tenant name Total complex square footage Vendor Year to date (YTD) advertising $ for this YTD $ spent on this job type YTD $ spent on this job type in this complex Additional problems are available in connect only. The following narrative describes a purchase and payment process and a sales and col lection process for BR Management Company Use the narrative to answer the questions below. BR Management Company (BRMC operates apartment complexes and earns rev. enues by renting out the apartments in those complexes BRMC assigns an agent manager to each complexione manager can manage several complexes to handle day-to-day oper stions, such as maintaining the property and signing rental contracts. This case describes the maintenance and rental processes. LO 6-5 Complexes and Apartments BRMC has acquired 15 and built several more apartment complexes Over the past 2 years. It identifies complexes by address and apartments by the combination of address and apartment number BRMC categories each apartment according to a num. ber of factors, including the quality of its furnishings, number of rooms, and size. There are 27 apartment categories at present each Identified by unique category number Because each complex presents a unique set of luxury appointments and amenities BRMC determines the standard monthly rental fee by considering both the apartment category and complex, for example, 2 bedroom 1 bath apartments category 21) rent for $850 per month in the Broadway complex, but the same category apartments rent for $1.450 per month in the Naples complex Maintenance BRMC keeps its apartments and complexes in top condition. The BRMC agents monitor the condition of the facilities. Whenever the condition falls below BRMC standards, the agents hire contractors to bring the apartment back up to specifications BRMC clas. Sifies each maintenance job by job type, and matches the job type to the contractor type that can best perform the job. The BRMC agent then selects one specific contrac tor for the job from that contractor type. Each contractor may belong to several contrac tor types. Each maintenance job involves other one apartment or the common areas of the complex BRMC tracks the maintenance performed on apartments and complex common areas Rentals BRAC agents negotiate rental contracts with tenants. Each rental contract governs one year long lease of an apartment. Although there is a standard monthly rental fee for each apartment in each building agents may negotiate higher or lower rent if they see the need to do so it is important to have a full record of the actual rent for all apart ments. When there is more than one tenant per apartment, every tenant must sign the rental contract. BRMC assigns a unique tenant ID number to each tenant and issues them ID cards to control access Cash Receipts and Disbursements and Other Information To implify the case, the cash resource, the cashier agent and the cash receipt and dis- bursement events (although they would certainly exist) are eliminated. You should not model those in your solution. All agents, resources, and types are put into the database before they are linked to other classes. a. Prepare an integrated UML class diagram with classes, associations, and multiplicities. b. Using the preceding information and the following attributes ist, prepare a listing of the relational tables necessary to support BRMC's processes. Ust the tables in the following order resources, events, agents, type images and linking tables Attributes: Actual completion date of job Actual cost of this job Actual monthly rent Agent monthly salary Agent name Apartment category+ Apartment complex address Apartment square footage Apartment Category Contractor name Contractor phone number Contractor quality ang Contractor type Contractor Count of rooms in apartment Count of this type of contractor Date complex was constructed Employee# Job type Maintenance job Number of available apartments in this category Projected completion date of job Rental contract date Rental contract Standard cost for this job type Standard monthly rent Tenant credit rating Tenant ID# Tenant name Total complex square footage Vendor# Year to date (YTD) advertising $ for this YTD $ spent on this job type YTD $ spent on this job type in this complex Additional problems are available in connect only. Comolous and Apartments Because cach complex presents uniques category and complex for example, 200 o S850 per month for S1 450 per month in the Nones complex Maintenance BRMC Ke states and Presentachded by oueregory number presents and amenities ord r ental fee by o n both the apart Por ex e gory 21 B e ategory artments rent ous its apartments and complemento no conoton The BRMC agents monitor the condition of the facties when the condoon as below BRMC standards, the gentshire contractors to be to Siflesh och maintenance on by the type to the con pe that can best perform the one specic contro for for the job from that contractors are contractor may belong to several contros or types. Each maintenance of the common areas on the complex. BRMC tracks the nee d on artments and complex common areas Rentals BRMC agents negotiate rental contracts with tenants Each rent contract governs one year-long lease of an apartment Athough there is a nderd monthly rental fee for each apartment in each building en honorower rent if they see the need to do so is important to have record of the actualment for all apart ments. When there is more than one tant pers on every tenant must sign the rental contract BRMC assigns a unique tenant number to each tenant and issues them ID cards to control access Cash Receipts and Disbursements and Other Information To simplify the case, the cash resource the cashier agent and the cash rece ot and s- bursement events (although they would certainly exist) are emited. You should not model those in your solution. All agents, resources, and types are put into the database before they are linked to other classes 3. Prepare an integrated UML class diagram with classes, associations, and multiplicities. b. Using the preceding information and the following attributes st. prepare a listing of the relational tables necessary to support BRMC's processes. List the tables in the following order resources, events, agents, type mages and linking tables Attributes: Actual completion date of job Actual cost of this job Actual monthly rent Agent monthly salary Agent name Apartment category Apartment complex address Apartment square footage Apartment Category Contractor name Contractor phone number Contractor quality rating Contractor type Contractors Count of rooms in apartment Count of this type of contractor Date complex was constructed Employee Job type Maintenance job Number of available apartments in this Category Projected completion date of job Rental contract date Rental contract Standard cost for this job type Standard monthly rent Tenant credit rating Tenant IDF Tenant name Total complex square footage Vendor Year to date (YTD) advertising $ for this YTD $ spent on this job type YTD $ spent on this job type in this complex Additional problems are available in connect only. The following narrative describes a purchase and payment process and a sales and col lection process for BR Management Company Use the narrative to answer the questions below. BR Management Company (BRMC operates apartment complexes and earns rev. enues by renting out the apartments in those complexes BRMC assigns an agent manager to each complexione manager can manage several complexes to handle day-to-day oper stions, such as maintaining the property and signing rental contracts. This case describes the maintenance and rental processes. LO 6-5 Complexes and Apartments BRMC has acquired 15 and built several more apartment complexes Over the past 2 years. It identifies complexes by address and apartments by the combination of address and apartment number BRMC categories each apartment according to a num. ber of factors, including the quality of its furnishings, number of rooms, and size. There are 27 apartment categories at present each Identified by unique category number Because each complex presents a unique set of luxury appointments and amenities BRMC determines the standard monthly rental fee by considering both the apartment category and complex, for example, 2 bedroom 1 bath apartments category 21) rent for $850 per month in the Broadway complex, but the same category apartments rent for $1.450 per month in the Naples complex Maintenance BRMC keeps its apartments and complexes in top condition. The BRMC agents monitor the condition of the facilities. Whenever the condition falls below BRMC standards, the agents hire contractors to bring the apartment back up to specifications BRMC clas. Sifies each maintenance job by job type, and matches the job type to the contractor type that can best perform the job. The BRMC agent then selects one specific contrac tor for the job from that contractor type. Each contractor may belong to several contrac tor types. Each maintenance job involves other one apartment or the common areas of the complex BRMC tracks the maintenance performed on apartments and complex common areas Rentals BRAC agents negotiate rental contracts with tenants. Each rental contract governs one year long lease of an apartment. Although there is a standard monthly rental fee for each apartment in each building agents may negotiate higher or lower rent if they see the need to do so it is important to have a full record of the actual rent for all apart ments. When there is more than one tenant per apartment, every tenant must sign the rental contract. BRMC assigns a unique tenant ID number to each tenant and issues them ID cards to control access Cash Receipts and Disbursements and Other Information To implify the case, the cash resource, the cashier agent and the cash receipt and dis- bursement events (although they would certainly exist) are eliminated. You should not model those in your solution. All agents, resources, and types are put into the database before they are linked to other classes. a. Prepare an integrated UML class diagram with classes, associations, and multiplicities. b. Using the preceding information and the following attributes ist, prepare a listing of the relational tables necessary to support BRMC's processes. Ust the tables in the following order resources, events, agents, type images and linking tables Attributes: Actual completion date of job Actual cost of this job Actual monthly rent Agent monthly salary Agent name Apartment category+ Apartment complex address Apartment square footage Apartment Category Contractor name Contractor phone number Contractor quality ang Contractor type Contractor Count of rooms in apartment Count of this type of contractor Date complex was constructed Employee# Job type Maintenance job Number of available apartments in this category Projected completion date of job Rental contract date Rental contract Standard cost for this job type Standard monthly rent Tenant credit rating Tenant ID# Tenant name Total complex square footage Vendor# Year to date (YTD) advertising $ for this YTD $ spent on this job type YTD $ spent on this job type in this complex Additional problems are available in connect only