Question
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)
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:
1) 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 Companys 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
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 category |
check amount | number of bedrooms for apartments in this category |
check date | projected completion date of job |
contractor # | standard cost for this job type |
contractor name | total complex square footage |
contractor phone number | YTD $ spent on this job type |
contractor quality rating | YTD $ spent on this job type in this complex |
contractor type |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started