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 purchase of maintenance service 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$).$

Maintenance Jobs. LJMC keeps its apartments and complexes in top condition. The LJMC complex managers monitor the condition of the facilities. Whenever the condition falls below LJMC standards, the managers hire contractors to bring the apartment back up to specification. LJMC classifies each maintenance job by job type, and the managers match the job type to the contractor type that can best perform the job. The LJMC 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. LJMC tracks the maintenance performed on apartments and complex common areas. LJMC pays its contractors in full at the end of the month for all jobs that the contractor performed during the month.

Other Information. Agents, resources, and type images may be recorded in the database before they are linked to other classes. LJMC tracks all its employees in one employee class.

Required:

use the information above and the list of attributes below to draw a UML class diagram showing the classes, associations, and multiplicities, $2)$ prepare a 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$.$ List your tables in the following order: RESOURCES, EVENTS, AGENTS, TYPE IMAGES, and LINKING. Use only the following list of attributes $($remember that there should be no classes without attributes$).$

Attributes

$$ Prev

$3$ of $3$

Attributes

actual completion date of job count of rooms in apartment

actual cost of this job count of this type of contractor

actual monthly rent date complex was constructed

apartment # date job ordered

apartment category # employee #

apartment complex address employee hire date

apartment complex name employee name

apartment square footage job type

bank account balance maintenance job #

bank account# number of available apartments in this category

check #

number of bathrooms for apartments in this

check amount category

check date

number of bedrooms for apartments in this category

contractor #

projected completion date of job

contractor name

standard cost for this job type

contractor phone number

total complex square footage

contractor quality rating

contractor type

YTD $ spent on this job type

YTD $ spent on this job type in this complex