Pacific Green Company (PGC)provides Landscaping Services to Individual and Corporate

Pacific Green Company (PGC)provides landscaping services to individual and corporate customers in southern California.Heather F originally founded PGC as a lawn mowing 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 PGC's processes for leasing trucks,maintaining trucks,and purchasing plants.
Inventories.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.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.
Truck Leases.PGC leases all its trucks from local dealers.PGC purchasing agents negotiate the leases.Each lease involves only one truck due to the state registration requirements.The dealers require a down payment at the time a lease is signed,and then PGC makes payments monthly over the life of the lease.Although PGC usually turns in the trucks at the end of the lease,occasionally,PGC will sign a new lease for an existing truck when that truck provides unusual capability or has relatively low mileage.
Truck Maintenance.PGC 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,PGC takes its trucks to the contracted shops when maintenance is required.A PGC 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 PGC cashier pays the truck maintenance vendors monthly for all the maintenance invoices received during the month.
Plant purchases.PGC buys its plants in bulk to keep its plant inventory well stocked.Because PGC has an excellent relationship with its plant vendors,it places informal orders by phone.When the plants are delivered and accepted,PGC assigns a purchase number to each receipt.PGC cashiers pay for plant purchases within 30 days of the delivery.PGC cashiers occasionally combine payments if there are multiple deliveries from the same vendor within a short period of time.
Employees.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.
Vendors.PGC 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 PGC'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: