• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17

Implementing a new system for Mastercare.

Extracts from this document...


Analysis 1. Statement of Problem Mastercare is a section of the company 'Dixons' and this division is used to repair electrical goods ranging from Televisions and DVD players to Hi-Fi systems and Computers. There is a main office of staff for Mastercare that assign jobs to the service engineers and they will visit the house of the customer and either fix the appliance there and then, arrange for it to be picked up and be delivered to the workshop or deliver it themselves. Each employee has to record details of each job during the day such as the time taken to repair the product and any items of stock that were required in doing so. This information is produced and at the end of each week sent back to the office staff. The employee that I will be working with is Steven Taylor who has been working with Mastercare for many years and is experienced to provide me with the information I need to build the company a new system. The old computerised system was only available in the office, so the engineers had to travel into the office to make out their reports. The company thought that it would be more efficient if the engineers had their own copy of a program so that they didn't have to travel into the office to produce their reports. This would money because the extra travel fuel would not be needed and it would also save time. A new system is required that must be able to store and process information entered into suitable outputs such as invoices and daily records sheets for both the Service Engineers and the office Staff. This system should be able to keep track of the stock used when repairing products and be able to produce valuable outputs when the stock level gets below a given level and needs to be updated. A password system will need to be created for the database to prevent unauthorised access to the system. ...read more.


* Produce Stock Reports when the level of stock drops. * Produce order forms with details of the stock items that need to be reordered. * Have a feature that lets you search for past customers * Be able to backup the system. I will not be able to create a payroll section to the system as I would have liked because the staff at Mastercare, understandably, did not want me to be viewing their financial earnings and thought that the information that would have been required was also quite personal. Also, with the amount of information and processing it would have required, I do not think I would have had the time (or technical knowledge) to create this section of the project. [For the client] I have read the previous proposed system objectives and am happy to see these objectives implemented into a new system for Mastercare. Signed ___________________ 1.3.3 Operational Environment The new system will have 4 users. One of them will be an administrator who gets access to everything contained within the database. The administrator will have the availability to see the table structure of the system and be able to update anything on the system or to add anything new. The administrator will be the only user that has access to the "Users" table and information that contains the usernames and passwords for all of the current users of the system. They will be able to change passwords in this section and also add or delete users on the system. The administrator will also be able to use the system just like the regular users. 1.3.4 Outputs My proposed system will be able to create a variety of reports to aid the users in their work. All reports will be viewed on screen on the laptops and then with the option to print via a printer, which will be recommended for all reports. ...read more.


The engineer inspects the appliance so that they know what the fault is and know what stock it requires. The engineer then checks if the item is currently in stock. If it isn't, he will then order it and book another visit with the customer for a future date. If the item is in stock, he will then repair the appliance and give the customer an invoice. 1.4.2 New System Data Flow Diagram This Data Flow Diagram (DFD) is for the proposed system for Mastercare. The supplier will bring the required stock items and they will be stored in the warehouse or with the engineer. The engineer will give the supplier an invoice and update the supplier details in the database. A customer who needs their appliance repairing gives their details to the engineer and stores them in the database. The engineer will assess the appliance to see how to fix it and see if it requires any stock to repair it. The engineer will get the stock and then repair the appliance. He will then enter the job details into the system and then create an invoice and give one to the customer. 1.5.8 Summary of System Objectives Here is a summary of the objectives of the system: 1) Create relevant tables and have relationships that link them together. 2) Create forms that have a consistent layout 3) Create an easy environment for the user to navigate around that isn't too complicated. 4) Create daily reports that list each job attended that day and details of each task. 5) Create a password system that allows more than one user to log onto the system and have the authority to be able to change their password when necessary. 6) Produce Stock Reports when the level of stock drops. 7) Produce order forms with details of the stock items that need to be reordered. 8) Have a feature that lets you search for past customers 9) Be able to backup the system. ?? ?? ?? ?? Phil Taylor ICT Coursework Page 1 of 17 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Information Systems and Communication section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Information Systems and Communication essays

  1. Marked by a teacher

    Database Coursework on a Vehicle Rental System: Analysis

    5 star(s)

    However, running two systems simultaneously can put a tremendous strain on the business in terms of time, money and manpower. In a pilot conversion, the new system is implemented in one location or segment of the business before its full implementation throughout the organisation.

  2. Marked by a teacher

    I have been asked to create an ICT solution for a local events and ...

    A example of one of the benefits which will come with the introduction of the new system will be a massive decrease in company expenditure. This will come directly as a result of the new system. The new system is removing the cost of printing in various areas of the business.

  1. Feasibility Report

    New and improved capabilities will guide personnel through the process of creating and distributing in print, Web, and e-mail so the Perfect Pie Company can build their brand, manage customer lists, and track your marketing campaigns - all in-house. Microsoft Outlook 2007 with Business Contact Manager offers powerful customer and

  2. ICT AS-Level Coursework

    The pseudo codes are activated, as they check the details. The user logs in and he is allowed into restricted areas. Create a self-updating receipt, which also appears in the user form. Input the pseudo code, the macros etc. The codes are initiated and the receipt changes.

  1. ict as level coursework

    Fruit Lip Balm Organic lip balm Max Moisture lip balm Quantity Desired number of product wished to be purchased. Number will show up on invoice Cleanser Drop down menu of available cleanser will be selected by user. Makeup removal cleanser Dry Skin cleanser Light non greasy clenser Quantity Desired number of product wished to be purchased.

  2. System Analysis and Design Assignment

    If the book is still not returned we will send a further letter and then possibly take action by demanding the cost of the book be paid immediately." Analysis of Present System & Problems Identified * Becoming a Library Member In order to become a member of the Learning Centre,

  1. Wjec alevel ict Creating a mailmerge

    Main Body of Text The main body of text is in 'Times New Roman' at 12pt at Normal + Left: 0.95 cm. Style of Paragraph To ensure a professional image in the letter I have followed a formal convention for the layout of the letter.

  2. Communication & Employability Skills for IT. OCR Cambridge Technicals Unit 1 LO1-P1

    For example if a computer keeps on freezing and doesn?t respond then an employee may get angry or stressed due to this. This can be reduce by the employee calling for IT support or the employer providing the correct equipment for the employee so that they don?t get into trouble with the equipment.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work