La Jolla Management Company (LJMC)manages Several Apartment Complexes and Earns

question 8

Essay

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

---

Definitions:

Trade Secrets

Information that is not known to the public, confers a competitive advantage to its holder, and is subject to reasonable efforts to maintain its secrecy.

Customer Lists

Refers to compilations of information about clients or customers that a business uses for contact, marketing, or strategic purposes.

Marketing Techniques

Strategies and methods used to promote and sell products or services to target consumers.

Theft Of Trade Secrets

The unauthorized acquisition, use, or disclosure of confidential business information that provides an enterprise with a competitive edge.