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).You should apply the standard REA patterns wherever the narrative does not clearly specify otherwise, but avoid adding extra relationships that are not discussed. If the narrative is not clear, you should clearly note any assumptions that you make.

ACCT 480 Redemption Exercise Pacific Green Company (PGC) provides landscaping services to individual and corporate customers in southern California. Heather 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 landscaping jobs (sales), truck maintenance (purchases), and plant purchasing (purchases) processes. PGC Inventories Trucks. 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 that each truck incurred 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. Plants. 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). For example, there are Rosa spinosissima (Scotch roses), Rosa gallica (Gallic roses), Rosa virginiana (Virginia roses), etc. To manage the plant inventory and ensure that the best plants are applied to job conditions, PGC categorizes all plants by plant types that indicate whether the plants are best in shaded areas, sunny areas, etc. Truck Maintenance. PGC purchases routine truck maintenance from local truck repair shops. When maintenance is required PGC takes its trucks to the repair shop. After completing the maintenance, the repair shop will invoice PGC. A PGC purchasing agent approves each maintenance invoice 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 from each vendor 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 (these informal orders are not recorded). 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. PGC Landscaping Jobs PGC performs landscaping jobs for individual and corporate customers, although at this point PGC does not differentiate among types of customers. PGC tracks landscaping jobs by job #. Each landscaping job may require many plants and several trucks, and PGC typically assigns multiple employees to each job. PGC designates one of those employees to supervise the 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 deposited daily in PGC's bank account by a PGC cashier. Each payment is made for only one job. Miscellaneous. PGC keeps all employee information together (your model should show one Employee class). 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. 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 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). You should apply the standard REA patterns wherever the narrative does not clearly specify otherwise, but avoid adding extra relationships that are not discussed. If the narrative is not clear, you should clearly note any assumptions that you make. Attributes: Cash account # Cash account balance Cash receipt # Cash receipt amount Cash receipt date Check # Check amount Check date Customer # Customer name Employee # Employee hire date Employee name Expected maximum size of plants in this category Hauling capacity for trucks in this truck type Landscaping job # Landscaping job price Landscaping job start date Light required for plants in this category Number of hours this employee worked on this job Number of hours this truck used on this job Number of vendors of this type Plant category Plant common name Plant purchase # Plant purchase date Plant scientific name Price of this plant received on this purchase Primary use for trucks in this truck type Quantity of this plant received on this purchase Quantity of this plant used on this job Quantity on hand of this plant Standard daily charge to use a truck of this type Standard price of plants in this category Total truck maintenance $ cost for this purchase Truck maintenance date Truck maintenance purchase # Truck make Truck mileage to date Truck type Truck VIN Vendor # Vendor account payable amount Vendor name Vendor type Vendor type description Year that this truck was acquired YTD sales $ to this customer