page 192The following narrative describes a purchase and payment process and a sales and collection process for BR Management Company. Use the narrative to answer the questions below. BR Management Company (BRMC) operates apartment complexes and earns revenues by renting out the apartments in those complexes. BRMC assigns an agent/manager to each complex (one manager can manage several complexes) to handle day-to-day operations, 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 categorizes each apartment according to a number 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 classifies each maintenance job by job type, and it matches the job type to the contractor type that can best perform the job. The BRMC agent then selects one specific contractor for the job from that contractor type. Each contractor may belong to several contractor types. Each maintenance job involves either one apartment or the common areas of the complex. BRMC tracks the maintenance performed on apartments and complex common areas. Rentals BRMC 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 rents if they see the need to do so. It is important to have a full record of the actual rent for all apartments. 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 simplify the case, the cash resource, the cashier agent, and the cash receipt and disbursement 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. Prepare an integrated UML class diagram with classes, associations, and multiplicities. Using the preceding information and the following attributes list, prepare a listing of the relational tables necessary to support BRMCs processes. List 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 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 Apartment square footage Apartment# Category Contractor name Contractor phone number Contractor quality rating Contractor type 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