• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

ITC - Database storage.

Extracts from this document...


SPECIFICATION The problem that I intend to renovate is the inconvenience of the stock check by automating the current system, which is manual and can lead to human error and will limit the time required to fulfil the needed specifications. The current system is manual work and not very accurate, it can cause mistakes and more likely to make errors as stock check is done by hand. It is difficult to find out if an item is in stock. Invoices have to be calculated manually leading to the possibility of mistakes being made. My new computerized system will monitor stock and once it has gone below an assured level then it will automatically re-order stock without the need for human supervision on the stock. My new system will also be able to store vast amounts of information and will allow users to print out appropriate references and other source of valid information. It will be a menu driven program for employees and general use. Requirements of new system is a database storage check which will in turn show the stock available in the shop and will steadily decrease after a period of time and then re-order after a certain level of availability. ...read more.


FOOD ORDERING SYSTEM The business is located in Kingsbury, London has around 10 or so employees that do a specified task on a daily basis. For Example, a few employees prepare the food and a few handle the financial side to the organisation. On average around 100-120 customers per night depending on reservations or not. The business uses invoices as a form of information and uses receipts for take away customers. The problem the business is having is a stock check every week, which is occasionally inaccurate and very time consuming and could lead to human error. I intend to solve this by creating a system which will be used for eating in and take away orders it will be a food ordering system and it will keep stock of how much food is available in the restaurant and when it goes below a certain level the system will re-order stock automatically. The main problem I will tackle is convenience for the staff, as my system will repeatedly order stock after a certain level of monitoring. My overall aim in this project is to create an automated food re-ordering system, which will verify the level of availability of stock for the restaurant. ...read more.


I will arrange the interview on a weekend and it will take place in the organisation itself. I will ask the following questions to my end-user: What current problems do your old system on stock have? How do u re-order stock? Do you have any schedule for re-ordering or do you just re-order when there isn't any stock available? Explain how you order your stock? Do you feel your system is proficient or can there be improvements? What do you feel about my new automated system? How do you think my new system will help this organisation? What advantages and disadvantages do you think my new automated system will have over you old manual system? QUESTIONNAIRE I will also carry out a questionnaire for the employees of the workplace so I can get their opinions on my new system and how it will benefit the organisation. Do you agree that making the old system automated will help the business? YES NO What system would you prefer to work with? OLD MANUAL NEW AUTOMATED What skill level do you think you have on information technology? BASIC INTERMEDIATE ADVANCED ...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 ICT in Business 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 ICT in Business essays

  1. Business Aims and Objectives.

    almost exactly mirrors the demographic make-up of the UK. Simply this means they have somehow managed to be all things to all men. They have between 7m and 8m different variations on the mailings going out to their clients based upon demographic and transactional data. The objective has always been to up-sell to their existing customers through acquiring better customer data and meeting their needs.

  2. ICT Coursework Two - Database Project

    Data Type Field Size Validation Description Customer ID Text 7 Input mask: LL00\0900 Members chosen ID number Surname 20 -- Members Surname (Alphabetic order) Forename 50 Members Forename Telephone 13 Input mask: 0\ 20\-0000\-0000 Member's telephone number Gender 1 Input mask: L "M" or "F" Member's gender (M or F)

  1. Spreadsheet project

    and the 2nd will have more realistic information like tax, personal allowance etc. Then the computer will have to take data from both sheets and make a monthly total before creating a payslip as shown above. Gathering information: - There are many ways in which I can obtain data from.

  2. The purpose of this document is to define the Context of Cain Motors Information ...

    see a difference in the time it takes to search the database for information and find that the information they receive is in fact no longer valid. Systems Impact: This change will require the production of a new updated version of the Cain motors database.

  1. For my Coursework I have looked at how Steve Edwards at Airbus UK uses ...

    This scans the disk and detects viruses. You must ensure it is used regularly. ( This will not protect the computer for viruses that are sent by email. Do not open email from anyone you do not know. ( Do not buy second hand software, unless you can scan the disc for viruses first.

  2. Fab Food Pix I.T. System

    under, the only way to find the desired record would be through trial and error of every record. - E.g. if a phone number is recorded and the name of the person to whom it belongs is desired, the only way to find it would be either call the number

  1. Estate agent.I will be creating a system that will help my client to let ...

    different things so I may not interpret the answers the right way and mess up. Existing documents Advantages: You get to see how the business is doing in black and white. You can see whether or not the business is making a profit or a loss quite easily and you can see how their business affairs are being managed.

  2. Video Rentals Shop Database

    A photocopy of a pre written letter is used to mail customers who have rented videos, which are overdue. This is a serious inconvenience because the employee who is working at a particular time must take time to get a photocopy of the pre written letter and fill in the

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