A 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 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. Other Information. Agents, resources, and type images may be recorded in the database before they are linked to other entities. 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 entities without attributes). Attributes ber of bathrooms for apartments Attributes employee# apartment square footage apartment# date complex was constructed total complex square footage cash receipt# cash receipt date cash receipt amount bank account# bank account balance apartment complex name apartment complex address apartment category# number of bedrooms for apartments in this category number of bathrooms for apartments in this category count of available apartments in this category count of rooms in apartment actual monthly rent tenant ID# tenant name rental contract# rental contract date tenant credit rating employee hire date employee name standard monthly rent date apartment available to tenant count of apartments in this complex A 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. Other Information. Agents, resources, and type images may be recorded in the database before they are linked to other entities. 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 entities without attributes). Attributes employee# apartment square footage apartment# date complex was constructed total complex square footage cash receipt# cash receipt date cash receipt amount bank account# bank account balance apartment complex name apartment complex address apartment category# number of bedrooms for apartments in this category number of bathrooms for apartments in this category count of available apartments in this category count of rooms in apartment actual monthly rent tenant ID# tenant name rental contract# rental contract date tenant credit rating employee hire date employee name standard monthly rent date apartment available to tenant count of apartments in this complex