Fast Buck Lizzie's Produce (FBL) is a company that buys fresh produce from farmers and sells it to restaurants and non-commercial customers.  FBL operates in a fantastic part of Michigan that has warm growing weather year-round.  This is FBL's first year in business.  Lizzie would like you to develop a relational database to be used to manage her company. She is a sole proprietor, so she is not interested in producing financial statements.  She does need operational performance information to make sure that the business is running as planned.

 

You have interviewed Lizzie and have summarized the results of these conversations as follows:

 

Each store carries all types of produce.  Produce is purchased directly from local and regional farmers and then are priced based on seasonal demand conditions. All purchases and sales of produce are measured per pound.  FBL also purchases fixed assets and miscellaneous items in other business processes. 

 

Some customers (very busy restaurants) may buy on credit and pay on the last day of the month. Customers that purchase in the stores pay cash or with a credit card.  FBL does not keep track of the individual names of these customers.  They are called "cash customers" and share the same customer ID.  There are no bad debts because no one wants to deal with Lizzie's crankiness.

Normal business proceeds as follows. An employee decides approximately how much produce is needed each day.  They purchase that amount in the early morning, rinse all of it, and deliver it by 3:00 p.m. to restaurants.  This minimizes the on-hand inventory of produce from day to day.  Produce is never transported between locations.  Employees always use company trucks to visit farmers and retail customers.

 

Lizzie handles the hiring at each store.  She strives to hire generalists who can perform many functions such as purchasing, selling, and preparing produce.  These employees earn a wage based on their hourly rate and the number of hours worked.  The hours worked are recorded on weekly timecards which are identified by timecard numbers which are unique throughout the company.  When employees sum their hours at the end of the week, they also note the % of their hours dedicated to preparing produce.  Employees are assigned to a store when hired but sometimes are asked to temporarily work at another store.  This does not affect the original store assignment.

 

FBLP also utilizes a fleet of trucks.  They are used to bring the produce from the farms to the store and to deliver the produce to customers such as restaurants.   The use of a truck on a purchase or a sale is tracked (one truck per sale or purchase), as is the time of the employee/driver. Each truck is uniquely numbered and assigned to a store, but trucks may occasionally make deliveries for other stores.  Company trucks are leased from truck vendors. Each lease is for one truck. Lease payments against each contract are made monthly by Lizzie who will send a truck vendor just one check to cover all existing contracts with that vendor.  

 

Lizzie uses three checking accounts for all disbursements and receipts.  One check is written for each purchase submitted properly (it will have a unique purchase invoice number).  Check numbers are not unique across bank accounts.  

 

Only Lizzie has access to the cash accounts, therefore she is always the person who acts for the company on cash transactions.  You may also assume that Lizzie is the agent for the company on the acquisition of employee service and the lease of trucks.  Do not model Lizzie as an employee or as a separate entity in this problem. (This means that some events will not have a modeled inside agent.)  There are cash receipts and disbursements in other business processes.

 

  You have also kept a list of data elements that you want to include in Lizzie's system.  They are as follows:

 

                Store location Code #                                                   $ amount of sale

                dollar amount of purchase                                            Employee Soc. Sec. No. (SS#)

                Employee Name                                                           Farmer Name

                Quantity of each produce item purchased                    cash account location

                Quantity of each produce item sold                             Store telephone no.

                Wage rate                                                                     Customer name

                Bank account no.                                                          Truck mileage for this sale

                Farmer quality score                                                     Truck mileage for purchase of produce

                Time spent (in minutes) of purchasing employee        produce description

                Customer credit score                                                   Driver time for sale

                Check #                                                                         $ amount of cust. remittance

                Timecard #                                                                   Lease interest rate

                Purchase invoice #                                                        Pay period begin date

                Check amount in dollars                                               Store item QOH

                % of time rinsing produce for this period -- employee      Remittance advice # (RA#)

                Total hrs worked this period, employee                       Customer #

                Item selling price (standard across US)                       Truck engine #

                Date of sale                                                                   Produce ID #

                Date of purchase                                                           Vendor#

                Lease#                                                                          Lease end date

                Truck model year                                                         Vendor phone #    

                Farmer#                                                                        Lease monthly payment   

                Store address                                                                Sales invoice # 

                Vendor name                                                                Pay period end date

                Individual Farmer A/P                                                  Amount applied to this lease

                Total QOH

                

  Required: 

 1.  Develop an UML diagram for Fast Buck Lizzy's Produce.   

 

2.  In determining minimum cardinalities, you may assume that agents, stores, and resources are entered into the database before any relationships with other entities are established - unless otherwise noted.

          

3.  This will be useful when determining the Labor Acquisition relationships in this model.  

Transcribed Image Text:

Labor Acquisition Timecard (PK) Duality Cash Disbursement P2 P1 1..1 0..1 Employee Labor Acquisition Timecard (PK) Duality Cash Disbursement P2 P1 1..1 0..1 Employee

Answer rating: 100% (QA)

To develop an UML diagram for Fast Buck Lizzies Produce we can first identify the main entities in the system 1 Store 2 Employee 3 Produce 4 Farmer 5 ... View the full answer