Accounting Information System 1st Edition by Vernon Richardson -Test Bank

True    False

True    False

True    False

True    False

True    False

True    False

True    False

True    False

True    False

True    False

True    False

True    False

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

PGC maintains an inventory of trucks of all sizes to support various landscaping requirements (the acquisition of trucks are outside the scope of this case). PGC tracks the trucks by vehicle identification numbers (VINs) and keeps meticulous records on each truck. For example, they track the mileage for each truck on each landscaping job. Additionally, they track the maintenance history for each truck (maintenance is outside the scope of this case). Each type of truck has a different use and hauling capacity, but each truck in a particular truck type has the same use and hauling capacity.

PGC also maintains an extensive inventory of plants, ranging from colorful flowers to large trees, so they can address almost any landscaping requirement on short notice. Since the common name of many plants vary by region, PGC tracks its plant inventory by scientific names (i.e., the Latin names). To manage the plant inventory and ensure that the best plants are applied to job conditions, Heather categorizes all plants by plant type.

PGC performs landscaping jobs for individual and corporate customers. Before performing any job, Heather prepares a quote describing the scope of service and the price. Sometimes, the customer will elect to perform pieces of the overall quote, so one quote may result in several landscaping jobs. The landscaping quote presents a price estimate based on the types of plants and types of trucks required and the overall time involved. Each quote involves at least one truck type and one plant type.

PGC tracks landscaping jobs by job #. Each landscaping job may require many plants and several trucks. PGC typically assigns multiple employees to each job as follows: (1) one supervisor, (2) one truck drivers per truck, and (3) landscaping laborers. PGC specifically tracks which employees perform which of these functions on specific jobs, since they pay employees according to the work performed on each landscaping job. Customers must pay a 10% deposit when the job begins, another 50% when the job is half completed, and the final 40% within two weeks after the job is fully completed. Customer payments are made by check or credit card and processed for daily deposit by a PGC cashier.

PGC keeps all employee information together (your model should show one Employee class). They track each employee’s qualifications according to category: purchasing agent, cashier, landscaping laborer, truck driver, supervisor, etc. An employee is considered qualified when he or she reaches the number of training hours required for that category. However, each employee can hold qualifications for several categories, for example an employee qualified as a purchasing agent could also be qualified as a truck driver.

You may assume that all agent, resource, and type image information is entered into the database before any process activity takes place. You may also assume that PGC only receives cash from landscaping jobs.

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 PGC’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:

After the customer contacts PGC about a landscaping project, a PGC manager prepares a quote describing the scope of service and the price. After reviewing the quote and comparing PGC’s quote to other landscapers, customers may 1) accept the quote, 2) notify PGC that they did not get the job, or 3) request that the quote be modified. If the customer accepts the quote, they sometimes request that the project be completed in a series of jobs. Each job is handled separately. Jobs are then performed according to an agreed upon schedule until the overall project is complete.

Each landscaping job generally proceeds as follows after the contract for the job is signed. The PGC manager responsible for the quote assigns the trucks and selects the plants for the job. Then, the manager assigns the job team: the job supervisor, truck drivers, and landscaping laborers, to the job. At that point, the PGC job team performs the job. Customers must pay a 10% deposit when the job begins (that payment is made when they sign the job contract) and the final 90% is due when the job is completed. Customer payments are made by check or credit card and processed for daily deposit by a PGC cashier. After PGC starts the job, the cashier bills the customer for remaining 90% due. Customers either make the final payment or demand rework to bring the job up to the contract requirements. When the job is completed satisfactorily, the customers then pay the amount due. Occasionally, some deadbeat customers withhold further payment for unknown reasons. In that case, PGC either refers the debt to a collection agency or writes off the remainder of the amount due. Of course, PGC does not perform the remainder of the jobs in the project when the customer fails to pay.

REQUIRED: Using the description above, prepare a BPMN activity diagram with pools (customer and PGC) and swimlanes that accurately depicts the PGC sales process.

TRUE

TRUE

FALSE

FALSE

TRUE

TRUE

FALSE

TRUE

FALSE

TRUE

FALSE

FALSE

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

Diagram:

Table listing:

Resources
Apartment Complex = apartment complex name (PK), apartment complex address, date constructed, total square footage, count of apartments in this complex, employee# (FK) (agent/manager)
Apartments = complex name + apartment# (PK), apartment square footage, count of rooms in apartment, apartment category (FK)
Cash = bank account# (PK), bank account balance)

Events
Rental Contract = rental contract# (PK), actual monthly rent, rental contract date, employee # (FK), complex address + apt # (FK)
Cash Receipt = cash receipt# (PK), cash receipt date, bank account# (FK), employee# (FK), tenant ID# (FK), rental contract# (FK)

Agents
Employee = employee# (PK), employee name, employee monthly salary
Tenant = tenant ID# (PK), tenant name, tenant credit rating

Type Images
Apartment Category = apartment category# (PK), number of bedrooms for apartments in this category, number of bathrooms for apartments in this category, count of available apartments in this category

Linking
Rental Contract-Tenants = rental contract# + tenant# (PK)
Apartment Category – Complex = apartment category# + complex name (PK), standard monthly rent)

After the customer contacts PGC about a landscaping project, a PGC manager prepares a quote describing the scope of service and the price. After reviewing the quote and comparing PGC’s quote to other landscapers, customers may 1) accept the quote, 2) notify PGC that they did not get the job, or 3) request that the quote be modified. If the customer accepts the quote, they sometimes request that the project be completed in a series of jobs. Each job is handled separately. Jobs are then performed according to an agreed upon schedule until the overall project is complete.

Each landscaping job generally proceeds as follows after the contract for the job is signed. The PGC manager responsible for the quote assigns the trucks and selects the plants for the job. Then, the manager assigns the job team: the job supervisor, truck drivers, and landscaping laborers, to the job. At that point, the PGC job team performs the job. Customers must pay a 10% deposit when the job begins (that payment is made when they sign the job contract) and the final 90% is due when the job is completed. Customer payments are made by check or credit card and processed for daily deposit by a PGC cashier. After PGC starts the job, the cashier bills the customer for remaining 90% due. Customers either make the final payment or demand rework to bring the job up to the contract requirements. When the job is completed satisfactorily, the customers then pay the amount due. Occasionally, some deadbeat customers withhold further payment for unknown reasons. In that case, PGC either refers the debt to a collection agency or writes off the remainder of the amount due. Of course, PGC does not perform the remainder of the jobs in the project when the customer fails to pay.

REQUIRED: Using the description above, prepare a BPMN activity diagram with pools (customer and PGC) and swimlanes that accurately depicts the PGC sales process.

The activity is a slightly more complicated version of the diagrams shown for Sunset in chapter 6. Here is a simple activity diagram with the basic steps.

The use of pools and addition of different paths make the solution more complicated. The solution should look something like this, although a variety of solutions are possible.