Quickest Franks (QF) Is a Fast Food Restaurant That Specializes

Quickest Franks (QF) is a fast food restaurant that specializes in frankfurters. QF cooks and prepares cheese franks, chili franks, plain franks, and so forth, to customers who need a quick meal. QF has several stores in the city of Quincy and hopes someday to expand and become a national franchise. QF employs several types of personnel, including managers and assistant managers for each store, cooks, counter clerks, cleaning staff, marketing personnel, a systems technician, and an accountant. The marketing personnel, systems technician, and accountant work in a back office at the headquarters store and are on salary. They are required to work 40 hours per week, but they may choose their own hours and need not be included on any schedule. If they work less hours they make up the time; if they work more hours, they don't receive additional compensation.
The managers and assistant managers are also on salary; however, they must be scheduled for certain hours along with the hourly employees (cooks, counter clerks, and cleaning staff) to ensure each store is adequately staffed and managed at all times. On Wednesday of each week, the manager of each store determines the staffing needs for the following week (Sunday through Saturday) based on predicted restaurant traffic (which depends on seasonality, school vacations, holidays, planned sporting and musical events in town, and so forth). Each manager prepares a staffing plan, including the number of hours required for each type of position at that store. The staffing plan does not specify employees - only the positions needed. The manager then creates a tentative schedule that lists each employee and the dates and hours the employee is expected to work for the week; this tentative schedule is posted and employees have until Friday at noon to request changes. The schedule is then adjusted and the final version obligating QF and its employees to the scheduled hours is posted on Friday by 6 p.m.
Each week each employee is issued a new time card. The time cards are kept in a central location at each store. When each employee arrives to work, leaves for and returns from breaks, and leaves work for the day, he or she inserts the time card into a device that inserts the current date and time into the appropriate spot. At the end of each week, the manager verifies the accuracy of each timecard and sends the approved timecards to the accountant. The accountant calculates gross pay, withholdings, and net pay dollar amounts and enters the weekly payment information into the database. Paychecks (each identified by a unique check number) are issued to employees each Friday for the previous week's work. Because QF purchases its ingredients from a very small set of vendors and is a closely held company, very few payments are issued to non-employee recipients; most payments QF makes are for payroll. The accountant processes all payments, including payroll and all other checks.
Following is a business process-level REA diagram that is intended to represent the payroll cycle for QF. Your task is to identify errors in this diagram. The types of errors you should consider include missing entities, missing relationships, extra entities, and extra relationships (i.e., entities or relationships that are either nonsense or don't belong to the represented cycles). List the errors on the following page. Do NOT include cardinalities or attributes for this problem! If you identify a missing entity you should word your statement as, "An entity named _______ is missing." If you identify a missing relationship you should word your statement as, "A relationship named _____ is missing and should exist between the _____ and _____ entities." If you identify an extra entity or relationship you should word your statement as, "The entity (or relationship) named _____ should not exist." If you identify a mis-named entity or relationship, you should word your statement as, "The entity (or relationship) named _____ should instead be named _____."
REA Model for Quickest Franks
List the errors you identified from Quickest Franks payroll cycle model below. The number of blanks available does not correspond to the number of actual errors. Use only as many as you need to use, and add blanks if necessary.
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________