UML Class Diagram Assignment

Macao Green Company (MGC) provides landscaping services to individual and corporate customers in Macau. Mary originally founded MGC as a garden decoration service while she attended graduate school. It became so successful that she delayed her teaching career to concentrate on building the company. This case describes MGC’s processes for leasing trucks, maintaining trucks, and purchasing plants.

Inventories. MGC maintains an inventory of trucks of all sizes to support various landscaping requirements (the acquisition of trucks are outside the scope of this case). MGC 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. 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.

MGC 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, MGC 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, Mary categorizes all plants by plant type.

Truck Leases. MGC leases all its trucks from local dealers. MGC purchasing agents negotiate the leases. Each lease involves only one truck due to Macau registration requirements. The dealers require a down payment at the time a lease is signed, and then MGC makes payments monthly over the life of the lease. Although MGC usually turns in the trucks at the end of the lease, occasionally, MGC will sign a new lease for an existing truck when that truck provides unusual capability or has relatively low mileage.

Truck Maintenance. MGC contracts for truck maintenance with local truck repair shops. A purchasing agent will negotiate a truck maintenance contract for each type of truck with a truck repair shop that specializes in those types of trucks. Then, MGC takes its trucks to the contracted shops when maintenance is required. A MGC purchasing agent approves each maintenance invoice after carefully checking it against the contract terms and assigns a purchase number to track the purchase of maintenance. A MGC cashier pays the truck maintenance vendors monthly for all the maintenance invoices received during the month.

Plant purchases. MGC buys its plants in bulk to keep its plant inventory well stocked. Because MGC has an excellent relationship with its plant vendors, it places informal orders by phone. When the plants are delivered and accepted, MGC assigns a purchase number to each receipt. MGC cashiers pay for plant purchases within 30 days of the delivery. MGC cashiers occasionally combine payments if there are multiple deliveries from the same vendor within a short period of time.

Employees. MGC 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.

Vendors. MGC keeps all vendor information together (your model should show one Vendor class). However, they classify the vendors by type: truck dealer, truck repair shop, plant vendor, etc.

Miscellaneous. You may assume that all agent, resource, and type image information is entered into the database before any process activity takes place.

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 MGC’s processes 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:

Average price of plants in this category

Average daily charge to use a truck of this type

Cash account #

Cash account balance

Check #

Check amount

Check date

Date this employee qualified for this employee type

Employee #

Employee hire date

Employee name

Employee Type

Expected maximum size of plants in this category

Light required for plants in this category

Number of employees qualified for this employee type

Number of training hours to qualify for this employee type

Plant category name

Plant common name

Plant scientific name

Quantity on hand of this plant

Truck acquired year

Truck make

Truck mileage to date

Truck type

Truck type hauling capacity

Truck type use

Truck VIN

Truck maintenance contract #

Truck maintenance contract start date

Truck maintenance contract end date

Truck maintenance purchase #

Truck maintenance vendor’s invoice #

Truck maintenance date

Truck maintenance amount

Truck lease #

Truck lease start date

Truck lease end date

Truck lease down payment amount

Truck lease monthly payment amount

Plant purchase #

Plant purchase date

Quantity of this plant received on this purchase

Price of this plant received on this purchase

Vendor type

Vendor type description

Count of vendors of this type

Vendor #

Vendor name

Vendor account payable amount. Get Finance homework help today