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

For my project I will be designing a new database for a mail order company called SPANK MY MONKEY Skateboards (TM) selling skateboards and skateboard accessories.

Extracts from this document...


Analysis Introduction: For my project I will be designing a new database for a mail order company called SPANK MY MONKEY Skateboards (tm) selling skateboards and skateboard accessories. Mr. Pearce the company director has asked me to design and make a new computerised database system to replace their old paper based system. My database will deal with stock control, budget and customer details in an incorporated package. At present their system consists of many pieces of paper in a file cabinet, in a kind of box card format. The problems with this system are: * New records that are made take ages to create; * Records that need to be changed or updated take a long time; * It is hard to know if you have a particular item in stock; * It is quite unreliable due to human error and customers sometimes get the wrong items; * Records get lost; * Records get misfiled. User Requirements: Mr. Pearce has requested that the system I design will have: * Details of customers; * Details of past sales; * Details of the current stock; * Current cost value of stock; * Weekly and daily printouts of stock and stock value overviews; * A function that notifies him of ...read more.


Also there are about 100 products that are sold through this company. All this information will need to be copied onto the new system so will need to take a copy of the customer and stock details from the company. Hardware and Software: Mr. Pearce has just bought some new PC's especially to run this new system, he has 5 new PC's all with a specification of: Hardware: * Pentium II processor at 450MHz * 64 MB of RAM * 12GB Hard Drive * TNT2 Graphics Card * 52x Speed CD-ROM Drive * 3.5" Floppy Disc Drive * Logitech Wheel Mouse * Hot Keys Keyboard * Ethernet Card 10/100 Software: * Microsoft Office 97' for Businesses, includes; - Word - Excel - Access - Outlook Express - Internet Explorer * Microsoft Windows 98 Second Edition Also these computers will have to be networked so that if someone on one computer has a order for a product and it's the last of that item and another person tries to order the same product. As the computers are networked then it will update the tables and the other person will not be able to order that item. ...read more.


the users preference and to reduce the chance of error * It should be simple and easy to use and do advanced functions even for the most basic user, and just to make life easier for the advanced user * It should be impossible to accidentally delete important formulae etc. * It should fit on a floppy disc of 1.44 MB. The Current System: At the moment there audit and budget system is quite basic, some of the information that has been inserted is incorrect due to human error, some the information is quite hard to understand and it's not very fast or easy to find something. The advantages of putting it together into one easy database system: * This will greatly improve the speed of the system e.g. when your searching through a wad of paper for one particular bit of data it may take a few minutes. If this information was inputted in my spreadsheet it may take only a few seconds to find that data, this makes the new system a lot easier to use. * Moving towards a computer-based system greatly decreases the chance of a spelling error or mistake in the data and therefore improves the efficiency. 28 April, 2007 Steven Bell 1/3 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays


    The output would be: * Pivot Chart/Graph showing comparisons between gender, form-by-form and overall year group achievement. * Give students their grades using report card. * Table displaying student grades. * Creating report for using student with performance. * School letter, which would be sent out to parent using conditional formatting to highlighting grade attained.

  2. Database Analysis and Database Design Project - DVD library for moving images.

    The following activities must be performed: * Design the tables and identify Primary and Foreign Keys * Define the relationships between the tables * Create suitable data entry forms * Enter Test Data * Create at least five relevant queries to interrogate the database * Create and print reports that

  1. Computer project Alevels

    a doctor registers newly to the company and when the information of the doctor is needed and when needed editing the information keyed in. Every time the data is edited it is being updated and stored. An error report is produced when an error is detected while validation step is performed.

  2. Travel Agent Database - Effects of New System The new system will affect ...

    2. The travel agency will have to buy computers. This means that they will have to spend thousands on buying computers and also training the staff. The travel agency will also have to may for electricity bills and other expenses. 2. Some reliable employees may get trained to use computers because they will need to learn how to use them.

  1. Standalone vs networked computers

    Without procedures the security of the network might be comprised, as well as the health of the employees. Legislation such as the Data Protection Act and Computer Misuse Act may accidently be disobeyed. ADVANTAGES OF STAYING STANDALONE The advantages to keeping the current 5 machines set up as they are,

  2. GCSE Database Project ICT

    The receptionist has to go through the 150+ records and check the last appointment date if no appointment has been made in the last 4 months and to send them a letter informing the patient to rebook or face extradition from the surgery list.

  1. GCSE Excel Project ICT

    it saves (in a separate file), prints the order (to be given to Alex), resets the forms, saves and closes. The file is going to be reused repeatedly for multiple customers. At least 3 Quantitative objectives THESE MUST BE CHECKED BY YOUR TEACHER.

  2. Computer Studies Past paper definitions

    buffer temporary memory/storage area compensates for speed differences of device and CPU for data being transferred/downloaded between components of a computer system allows other functions to take place at same time examples, printer, keyboard [2] (d) RAM random access memory memory that can be read from and written to temporary

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