BACKGROUND. OC Management Company (OCMC) has built or acquired several high-quality apartment buildings in Orange County. OCMC operates apartment complexes and earns revenues by renting out the apartments in those complexes. OCMC assigns an agent/manager (employee) to each complex (one manager can manage several complexes) to handle day-to-day operations, such as maintaining the property, advertising, and signing rental contracts. This case describes the maintenance and rental processes.

Complexes and apartments. OCMC has acquired fifteen and built several more apartment complexes over the last two years. It identifies complexes by address and apartments by the combination of address and apartment#. OCMC categorizes each apartment according to bedrooms and bathrooms, e.g., 1 bedroom and 1 bath is category 11. Each apartment category is identified by unique category #. Since each complex presents a unique set of luxury appointments and amenities, OCMC 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 $2250 per month in the Tustin Arms complex but the same category apartments rent for $3350 per month in the Laguna Beach Crest complex.

Maintenance. OCMC keeps its apartments and complexes in top condition. The OCMC agents monitor the condition of the facilities. Whenever the condition falls below OCMC standards, the managers hire contractors to bring the apartment back up to specification. OCMC classifies each maintenance job by job type, and the managers match the job type to the contractor type that can best perform the job, although most job types can be performed by multiple contractor types and each contractor type can perform multiple job types. The OCMC manager 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. OCMC tracks the maintenance performed on apartments and complex common areas.

Rentals. OCMC managers 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. OCMC assigns a unique tenant ID# to each tenant and issues them ID cards to control access.

Cash Receipts and Disbursements. OCMC pays its contractors at the end of the month for all jobs performed during the month, although it sometimes pays cash advances to contractors for more extensive jobs. OCMC collects the first month rent in advance from the tenants when the rental contract is signed and then collects payments monthly for the life of the contract.

Other Information. All agents, resources, and types are put into the database before they are linked to other entities. OCMC tracks all its employees in one employee class.

REQUIRED:

1) use the information above and the list of attributes below (no additions) to draw a UML class diagram showing the classes, associations, and multiplicities

2) list the tables necessary to support OC Management Companys processes. Use all the attributes (name each table, identify the primary and foreign keys. List your tables in the following order: RESOURCES, EVENTS, AGENTS, TYPES, and LINKING. Document any assumptions that you make when the text is unclear.

Attributes

• actual completion date of job
• actual cost of this job
• actual monthly rent
• apartment category#
• apartment complex address
• apartment square footage
• apartment#
• bank account balance
• bank account#
• cash receipt amount
• cash receipt date
• cash receipt#
• check amount
• check date
• check#
• contractor #
• contractor name
• contractor phone number
• contractor quality rating
• contractor type
• count of rooms in apartment
• count of this type of contractor
• date complex was constructed
• date job ordered
• employee hire date
• employee name
• 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
• YTD $ spent on this job type