a. Prepare an integrated UML class diagram with classes, associations, and multiplicities.
b. Using the preceding information and the following attributes list, prepare a listing of the relational tables necessary to support BRMC's processes. List the tables in the following order: resources, events, agents, type images, and linking tables.

The 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.

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.

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

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