FUNCTIONAL REQUIREMENTS (Specifications for the development of the application programs) The Woodys Automotive is interested in an online application program

interface that is easy to use so that they do not have to spend time unnecessarily to train their employees. Woody would also like the program interface to be easy for the customers. In particular, Woodys Automotive is interested in the next three applications: Customer registration and service appointments, Shop Management (workload reporting and monitoring, service transaction processing), and Management and Reporting. The last application is crucial in decision making by the owner and Accounting Department of the company. For instance, it will allow the workload and profitability at each location. As database and application program designers you are expected to write a menu-based main program which consists of the following three application programs for the daily transactions of the company and is open to the inclusion of additional functionality in the future. Note that many functions are left out in order to reduce the size and the complexity of the project. 1. Customer Registration and Service Appointments Every customer has to register before being able to place a service order. This interface will help the customers register (themselves and their automobiles) and manage/edit their registration information. Customers will be able to initiate service orders for their vehicles using a simple menu-driven system. 2. Shop Management and Transaction Processing Once a vehicle has been dropped off for service, the customer should be able to check and inquire about the status of his/her order. The status of an order is updated as the shop processes it. The customer should be able to view his service history and pull up specific transactions based on different criteria (for instance, based on the vehicle serviced or the type of service). The location manager should be able to view all service appointments for a selected date. Service appointments are closed out by recording and processing an invoice and its payment. 3. Management and Reporting Management uses this application to review and/or change prices for services (by vehicle type) and parts. This program provides statistics used by Woodys Automotive to help management to analyze its locations, sales and customers.

In particular, the program should be able to make the following computations: 1. For a given day and location, a report of the pending service appointments. 2. For a given time period (begin date and end date) compute revenue by location and service type. 3. For a given time period (begin date and end date) compute the top 3 locations (in terms of total service revenue) in descending order. 4. For a given time period (begin date and end date) compute the 5 best customers (in terms of total service revenue). 5. For a given time period (begin date and end date) compute the average service revenue for each vehicle type at each location.