• 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)

    Whilst this is certainly the most speedy and inexpensive option, at the same time, it is also the riskiest having as the result of a system failure could be catastrophic, as no back-up of the system exists. With a parallel running changeover, both new and old systems run simultaneously for

  2. Kenwood - Functions and objectives

    If a message is important then it will be sent quickly whereas just a sociable message to a friend will not need sending as quick. When encoding a message the sender may wish it to be personal and therefore will make it confidential by scrambling or sending as an attachment with a password.

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

    The major part of their job is to help the client to understand their own needs and developing their brief. They always make sure that the client knows exactly what are they developing and what it will do for them.

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

    The interaction is direct as the user just has to touch the desired spot on the screen to navigate them round the system. Other advantages include less space is needed, less possibility of theft and greater data security. These are all useful for future use as people are forever looking

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

    He currently uses a manual system but he feels it will be much better if he uses a computer system to carry out these tasks. He is interested in improving his record keeping, for example the way he stores his customers, his products and the customers order details.

  2. User Guide to my minibus hire database.

    - Beside the "Postcode" label there will be a data entry box, type in the postcode of the customers address in this box. - Beside the "Telephone" label there will be a data entry box, type in the customers contact number in this box.

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

    Samsung is owned by the South Koreans it's a company that was build up back in 1987, and the owner of this company is Lee Kun-hee and the employees that work for him in that company they all have different ideas of making electricity items.

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

    In summary the Computer Misuse Act prevents hackers and people from accessing data and gaining access to computer without permission, this could also include stealing, changing or causing damage to data and computers. The Act protects companies because it stops hackers from gaining unauthorised access to computers.

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