FA-TB ES Qu. 05-38 La Jolla Management Company...

La Jolla Management Company (LJMC) manages several apartment complexes and earns revenues by renting out the apartments in those complexes. LJMC 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 rental (sales) process.

Complexes and apartments.LJMC has acquired fifteen and built several more new apartment complexes over the last two years. It identifies complexes by unique name and apartments by the combination of the complex name and apartment#. LJMC categorizes each apartment according to the number of bedrooms and bathrooms, as well as other factors. There are more than 20 apartment categories at present, each identified by unique category #. Since each complex presents a unique set of luxury appointments and amenities, LJMC 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 $1850 per month in the El Dorado Arms complex (where there is no view and the complex is close to a freeway) but the same category apartments rent for $2850 per month in the La Jolla Cove complex (where there is a view of the ocean from most apartments in the complex).

Rentals.LJMC managers negotiate rental contracts with tenants. Rental contract duration is 12 months from the designated apartment availability date (the date the apartment is available to the tenants). 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, LJMC requires every tenant to sign the rental contract. LJMC assigns a unique tenant ID# to each tenant and issues them ID cards to control access.

Cash Receipts.LJMC 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. Assume that LJMC does not receive cash from other sources.

1) information above and the list of attributes below to draw a UML class diagram showing the classes, associations, and multiplicities, 2) listing of the tables necessary to support La Jolla Management Company's process using all the attributes. Name each table and clearly identify primary keys with PK and foreign keys with FK. Tables in the following order: RESOURCES, EVENTS, AGENTS, TYPE IMAGES, and LINKING. Use only the following list of attributes

Attributes

employee#	number of bathrooms for apartments in this category
appartment square footage	count of available apartments in this category
apartment#	count of rooms in apartment
date complex was constructed	actual monthly rent
total complex square footage	tenant ID#
cash receipt#	tenant name
cash receipt date	rental contract#
cash receipt amount	rental contract date
bank account#	tenant credit rating
bank account balance	employee hire date
apartment complex name	employee name
apartment complex address	standard monthly rent
apartment category#	date apartment available to tenant
number of bedrooms for apartments in this category	count of apartments in this complex