Cain Motors Information System Essay Example for Free

Cain Motors Information System Essay The purpose of this document is to define the Context of Cain Motors Information System in order to form the basis for the Information System and assessment of the success of the project. This document will allow the Project Board to ensure the project has a sound basis before making a major commitment to the project. It will act as a base document against which the Project Board and Project Manager can assess progress, change management issues, and on-going viability issues. Approval of the Project Initiation Document (PID) is sought from the Project Board, together with authorisation to proceed with the next stage of the project. here are eight main stages to using PRINCE2 Quality Management, which is the system we will be using to develop this project. Cain Motors is a small garage in the east end of London situated under the railway arches. The garage has been running for thirty years and relies mainly on word of mouth and passing trade for its business. It deals with car repairs, MOTs, servicing and insurance work. There are a total of four workers including the owner Mr Cain. Last year we were brought into update the system from a manual system to a computerised system, which we did but Mr Cain has called us back to update the system and to redevelop the existing information processing system at Cain Motors to resolve defects highlighted by users and Mr Cain, the project will also incorporate certain changes requested by users of the present information system such as to be able to produce a complete MOT history, to produce invoices, web site for advertising and booking appointments (MOT, crash repairs and servicing). Mr Cain has decided to store stock on the premises; therefore he now requires a facility for stock monitoring i. e. a stock table added to the database so he can keep track of what needs to be reordered and what has to be used. The project aims to provide an information system that will assist staff in the day-to-day operations of Cain Motors, providing an efficient computer system, which reliably and securely stores information manages stock control, customer information and MOT service history. If the aim of the project if achieved it will make the business more efficient, it will cut down on lost time, because everything should be on the computerised system, which means the company will on lost man hours. The identified defects are listed below, also the desired improvements Improvements Defects As business expands, stock details needs to be included and supplier referencing for purposes of stock control and monitoring. The supplier table is not related to any other tables within the databases, at present it is a flat file contained with the database. Web site for advertising and booking appointments (MOT and crash repairs servicing) MOT history is not recorded for each customer, when a search is entered only the last record is shown. A full history needs to be returned. Estimates were not included into database version 1 to be included in version (estimate log, costs retail date given who gave when was it given to customer, proceed or decline. How long does estimate stand) Printing details currently only tacks a screen dump and prints that off rather than a full report, which is really what is required. Delete functions used in a VB front end for the database does not delete record conation with the database table this needs to be readdressed. The stock control system will be integrated into the existing system, linking the supplier table to the database. The system will be loaded as part of a new version, data migration for the previous version will be required and data entry will be required to enable the staff to see all supplier information. Financially this change will benefit Cain Motors immensely, turn around time will increase for cars, and cars will not be held static in the garage awaiting parts thus increasing the amount of cars that can be worked on at once. Thus increasing business revenue.