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

Implementing a new system for Mastercare.

Extracts from this document...

Introduction

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.

Middle

* 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.

Conclusion

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)

    cases in may not meet the demands of the proposed system, depending on what is required from it. Once the database is constructed and the system is completed, it must undergo rigorous testing. I will design attesting strategy and test the system according to that plan.

  2. Marked by a teacher

    Ecommerce Case Study

    utility bills, cleaning costs and transportation costs for bringing in new and replenishing stock. This is a huge amount in comparison to what is required to sell their goods via e-commerce. The total price for selling up a website can be as little as £5000 to have a fully functional

  1. Marked by a teacher

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

    Mr James Whitmore- head of administration would be in charge of this. Mr Whitmore has had experience with some other Microsoft products before such as word and excel. Due to the structure of Microsoft?s software it offers a look and feel aspect to all of its products.

  2. ict as level coursework

    This icon should be pressed when inserting a label. For example I have used this in my user form when labelling products and heading of the uses form. In order to create a text box this should be selected. This icon indicates a combo box this is associated with a drop down list.

  1. Feasibility Report

    Office Small Business 2007 will provide the Perfect Pie Company with the latest and newest office software, the following software is include in the package; Microsoft Excel 2007, Microsoft Word 2007, Microsoft PowerPoint 2007, Microsoft Publisher 2007, and Microsoft Outlook 2007, with Business Contact Manager.

  2. A2 ICT CouseWork

    be quite modern and up market, but when viewing these websites i noticed a distinct similarity, as when i moved my cursor over a button, it changed in colour. I would like you too implement this feature in your design.

  1. Database Analysis & Design

    This is the overall base structure of the project. The user requirements can be found in many different ways, * Interviews * Observation * Documentation * Questionnaires * Using the system All these will be reviewed and analysed to help find out what the user really wants from the project.

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

    5 minutes when working for about an hour when using the PCs or laptops in order to let their hands rest. Another way to reduce this from happening is to provide employees with wrist wrest in order to help their hands rest.

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