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.
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).
Average price of plants in this category
Average daily charge to use a truck of this type
Cash account #
Cash account balance
Date this employee qualified for this employee type
Employee hire date
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 mileage to date
Truck type hauling capacity
Truck type use
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 description
Count of vendors of this type
Vendor account payable amount. Get Finance homework help today