• 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

    Advanced integration with Microsoft Office SharePoint Server 2007 and new XML-based file formats make Office Word 2007 the ideal choice for building integrated document management solutions. Microsoft PowerPoint 2007, will enable staff within the Perfect Pie Company to quickly create high-impact, dynamic presentations, while integrating workflow and ways to easily share information.

  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 could be used for entertainment purposes, internet activity purposes, or even research purposes such as an interactive version of the Hotels questionnaire. Also touch screens could be used for the dining of the Hotel, this means staff would just have to choice the correct meal on the touch screen and it will run the price through automatically.

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

    It features TV's, laptops, cameras, phones and tablets. Mr Peters has currently ten members of staff in his business. There is now competition in this area with the opening of a new electronics shop not far away from where Samsung is situated. Mr Peters is very aware of this stiff competition and therefore he wants to improve the

  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.

    Samsung CCTV Camera has been used by this store for couple of years and it has been monitoring the store in very decent way and kept the thief's away from this store and capturing the thief's in the store The video cameras used for CCTV usually do not look anything

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

    For example when they get a pay rise, it is updated on the payroll system. The accuracy of the information does not have to be correct if you correctly recorded the information given to you, and have make reasonable steps to check that the information holds water, or you got the information from third parties and checked the validity.

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

    For example if an employee was carrying data on an USB then the USB must be encrypted which is password protecting data. For example if a teacher has to take students work home to assess and mark then they

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