* Write a mission statement for the EasyDrive School of Motoring database system.
Review the mission statement shown in Figure 10.8 on page 327 as an example.
Mission statement: * The purpose of the EasyDrive School of Motoring database is to maintain important company data, to provide an efficient and effective service our clients, meet the growing demand of the school and to facilitate the communication and sharing of information between offices. * Write mission objectives for the EasyDrive School of Motoring database system.
Review the mission objective shown in Figure 10.9 on page 331 as an example.
Mission objectives: * To maintain data on offices. * To maintain data on staff (managers instructors and admin). * To maintain data on Clients (registration info) * To maintain data on lesson and progress * To maintain data on vehicles. * To maintain data on lessons and driving tests. * To support the queries by the director * Create a user's requirements specification for the EasyDrive School of Motoring database system. Use a single major user view for the application (Director View).
Review the user's requirements specification shown in Appendix A as an example. Be sure to include detailed data requirements and transaction requirements in your solution. * Data Requirements * Staff Data; This will include names, personal info, position, contact, assigned office * Office Data; This will contain specific office location, number of staff members, vehicles assigned * Client Data; This will contain personal information acquired in registration process, student status, exam scores and historical data. * Vehicle Data; This will contain vehicle registration, assigned office and vehicle history. * Transaction Requirements * Data Entry * Enter the detail of new Office – Rm 1 Bldg 234 corner of 56th ave, 10 instructors/1 manager/3 admin/2 vehicles * Enter the detail of new Staff Member (manager/instructor/admin) – Mr. John A Doe, manager, Phone number 555-5555, assigned to B001 in Glasglow * Enter new client – Ms. Jane B. Smith, *personal contact info, Current instructor: Mr John A. Doe, *student status and history (mainly handled by admin) * Enter newly acquire vehicle – Mini Cooper - Lic# ABC-D123 assigned to B001 in Glasglow (mainly handled by admin) * Data update/deletion * Update/delete detail of an office * Update/delete detail of a Staff at an office * Data Queries * (a) The name and telephone number of the manager of each office. * (b) The full address of all offices in the city of Glasgow. * (c) The names of all female instructors based in the Bearsden office in the city of Glasgow. * (d) The total number of staff at each office. * (e) The total number of clients at each office. * (f) The lessons for a given instructor. * (g) The employee numbers and names of staff who are over 55 years old. * (h) The registration number of the cars used at the Bearsden office in the city of Glasgow. * (i) The names of all clients who passed the driving test in January 2005. * (j) The names of all clients that have taken the driving test more than three times. * (k)The average number of miles driven during a lesson. * (l) The number of administrative staff at each office.