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

Recently a small "Young Enterprise" group has set up a Sweet Stand, which sells a variety of sweets and soft drinks. The staff working at this Sweet Stand are Dave Currall (The Manager), Natalia Gelder (Assistant Manager).

Extracts from this document...


THE SWEET STAND Analysis The Problem Recently a small "Young Enterprise" group has set up a Sweet Stand, which sells a variety of sweets and soft drinks. The staff working at this Sweet Stand are Dave Currall (The Manager), Natalia Gelder (Assistant Manager). At the moment, the records which hold the information, are all paper based. This problem requires for Dave Currall to keep records in order, and also wastes time in writing the information down for the records. A stock check takes a lot of time to do although Nature of the problem User's requirements 1. Stock checking forms. 2. Stock not re-ordered. 3. Wrong Minimum re-order quantities. 4. Don't know who supplies which item. 5. Takes time and is difficult to prepare orders. 1. Form to use for stock checking. 2. Automatically identify when stock is low. 3. Items have a re-order quantity. 4. Each item has its known supplier. 5. System creates printed orders. Details of the problem Details of the user's requirements 1. Stock checking form - its paper based. This means that too much time is taken filling in the stock check form. Paper can be easily lost; also after a period of time it begins to look all messed up. Repeating the tasks again and again wastes time. ...read more.


in Stock of each item. Also it will be able to identify which item has come from which supplier. Also, these orders will be prepared when an item needs to be reordered. Inputs, Processing and Outputs required Inputs Processing Outputs * Stock items * No. in Stock of stock * Supplier details * Re-order level * Formulae * * Stock check form * Order form * Stock listing report Detail of inputs, processing and outputs Name of input Detail of input Stock items The items of stock that need to be ordered need to be input into the system No. in Stock of stock The number of items in stock will need to be an input into the system Suppliers details The information on the supplier will need to be input. This information is the address, name, and contact numbers. Re-order level The re-order level will need to be input for each item of stock. This is so that the calculation can alert the user that the item needs to be re-ordered. Name of Processing Detail of processing Formulae IF('RE-ORDER'<='STOCKLEVEL',"Y","N") Name of Output Detail of Output Stock check form This is for the staff so that the staff can go around the sweet stand and count the number of items available to buy. ...read more.


Alternative to the basic Landscape view on paper to give a certain stock more given space. My choice is: Alternative to the basic Reasons for my choice: Its view easier to understand and less confusing. 4. Software and Hardware requirements Preferred Software and Hardware Hardware Software * Processor - 900MHz Intel compatible * Memory - 32Mb * Hard disk drive - 1Gb * CD-ROM - fitted. * Floppy disk drive - fitted * Printer - Mono laser * ClarisWorks V.5 database application - It stores and processes the data for the Sweet Stand. An alternative to the database application would be Ms Access. * Ms Windows 98 operating system - This controls the systems hardware. There is no alternative for this. Hardware alternative Software alternative * Processor - 1000MHz Intel compatible, this will allow the programs to run faster. * Memory - 128Mb RAM, this allows large or many files to run faster. * Hard Drive - 60Gb * CD-ROM - CD-RW fitted, this allows you to backup your data on compact disk * Floppy disk drive - no alternative * Printer - Colour ink jet, more expensive, output is slower * Ms Access Implementation 1. Database Title The Sweet Stand Database Filename Sweet Stand.cwk Database File Storage Location H:\SweetStand.cwk Database File Backup Details SweetStand.bak 2. Application Program Name ClarisWorks V5.0 Application Program Opened From Start/Programs/Pupil Programs/ClarisWorks 5.0 3. Data Capture Form Used Data Entry Form Data Capture Form Storage GCSE I.T. Major Project Daniel Barker 34551 Page ...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 Computer Science 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 Computer Science essays

  1. Visual basic

    * Objects have properties (attributes) and methods (procedures), the details of which are hidden within the object Procedures * The best way to build and maintain a large program is to use the "divide and conquer" technique. * The project is made up of modules.

  2. Computing Project

    ON [Members Table].MemberId = [Loans Table].MemberID WHERE ((([Loans Table].DateBack)<Date())); This query was used to gather a list of all the loans which are overdue. This is present on the Overdue Loans Form below on this ADO Query component. 4. Sample of detailed Algorithm Design Setting Up Username and Password procedure TFMSetupUserandPass.BtnSaveClick(Sender: TObject); begin//begin if//if (EdUsername.text='')

  1. System Analysis The aim of the Jewellery store system is to make the work ...

    THREE VIEW OF THE SYSTEM Logical data models (LDM) Logical data models represent the abstract structure of some domain of information. They are often diagrammatic in nature and are most typically used in business processes that seek to capture things of importance to an organization and how they relate to one another.

  2. Infernowear is a new company run by a self-employed creative designer aiming to producing ...

    It is very good for calculating and carrying mathematical operations on large amounts of data in a very quick time. Unfortunately it does not function as well as a simple data input device as customising sheets and performing validity checks are complicated and slow.

  1. Computing Project

    PLANNED VALID OUTPUT For my system outputs I have decided to create a report for students to see their progress. This will need to be created in Access. DESCRIPTION OF MEASURES PLANNED FOR SECURITY AND INTEGRITY OF DATA. The data must be kept secure and correct as this information's is

  2. ict implementation

    contacting office , materials and extra and for the pc parts and other information I used from the PC Systems website. How to record the macros on the user interface and all pages Firstly I used clip are as shown below to get the pictures for my user interface: Below

  1. Smart Card System

    Since the user must have a different key for every person they communicate with, they must trust each and every person with one of their secret keys. This means that in practical implementations, secure communication can only take place between people with some kind of prior relationship, be it personal or professional.

  2. Flexible Architectures in Communication Security Application

    The intermediate vector IV ensures that the diffusion process propagates to all remaining ciphertext in the communication stream. The ciphertext value of encrypted block i is first XOR'ed with plaintext block i+1 before it is encrypted. The end result is that the cipher kernel execution is a very long recurrence with virtually no parallelism.

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