• 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. Feasibility Report

    Microsoft Word 2007 will help staff within the Perfect Pie Company; create professional-looking content more quickly than ever before. With a host of new tools, the staff, can quickly construct documents from predefined parts and styles, as well as compose and publish blogs directly from within Word.

  2. I have been asked to write a report on current working practice and I ...

    They need to understand the job very quickly so they can explains it to the client in straightforward terms which helps to ensures that the company and client both agree on that's what they want. Before a work order is signed, they suggest some extra features that client might want to include, it helps them to raise more money.

  1. The aim of this task is to produce a report for the managing director ...

    They are also places which people would instinctively thing of to try and find certain things. Digital Broadcasting Since the 1990's, digital broadcasting has become more widely available and is set to replace analogue broadcasting with a few years. This information can be broadcast by cable, satellite or using terrestrial broadcasting - using the aerial used for receiving analogue broadcasts.

  2. Data Processing Task. Mr Peters, the man who runs this particular Samsung store ...

    will have a print out copy of their orders rather than the more unprofessional way of just handwriting it. This shop sells all the things you would expect to find in an electronic shop. It features TV's, laptops, cameras, phones and tablets.

  1. User Guide to my minibus hire database.

    black form like so: Adding minibus records: - Beside the "Registration" label there will be a data entry box, type in the number of the registration plate in this box. - Beside the "Make" label there will be a data entry box, type in the make/manufacture of the minibus in this box.

  2. Applied ICT - How Comet Stores could use ICT and a CCTV system.

    9. 1 previous systems The previous systems they used to have wasn't that great as they have now because back in few years time they used to have CCTV Camera but wasn't that really decent to capture the person who enters the store or try's to take something from the store

  1. From the e-commerce strategy you gave me earlier I understand that by having a ...

    This could be beneficial to the company as it shows why they have refunded money. You can delete the original error if it was misleading to the correct fact. When you need to compile the information, make sure the information has veracity.

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

    For example a workplace may use strict measures to keep data secure. They may force their employees to change their password every 6 weeks. This makes sure that if someone does get to know the password of an employee or they have hacked it then the employee can keep data secure by changing the password.

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