Cain Motors Information System Essay Example for Free

Cain Motors Information System showThe purpose of this document is to define the Context of Cain Motors Information System in order to form the foothold for the Information System and assessment of the success of the project. This document leave alone altogetherow the Project Board to crack 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 privy assess progress, change management issues, and on-going viability issues. Approval of the Project Initiation Document (PID) is sought from the Project Board, unneurotic with authorisation to proceed with the next stage of the project. here are eight main stages to using PRINCE2 woodland Management, which is the system we will be using to develop this project. Cain Motors is a small garage in the eastward end of London situated under the railway arches. The garage has been running for thirty years and relies generally 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 selective study processing system at Cain Motors to resolve defects highlighted by users and Mr Cain, the project will also incorporate certain(p) changes requested by users of the present information system such as to be able to come a complete MOT history, to produce invoices, web site for advertizing and booking appointments (MOT, crash repairs and servicing).Mr Cain has distinguishable to store hold 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 inevitably 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 turn back, customer information and MOT service history.If the aim of the project if achieved it will make the business more efficient, it will squeeze down on disconnected time, because everything should be on the computerised system, which means the comp any will on lost man hours. The identified defects are listed below, also the desired improvements Improvements Defects As business expands, stock details take 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 but the last record is shown. A full history needs to be returned. Estimates were not included into database form 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 suppress 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 addition for cars, and cars will not be held static in the garage awaiting parts thus increasing the hail of cars that can be worked on at once. Thus increasing business revenue.