• 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

  1. GCSE Excel Project ICT

    As normally when the reference cell is moved any formulae linked to the cell gets re-written to accommodate the movement, if it's the formula that is moved then the reference is changed but maintains its position relative to the formula cell.

  2. The Design Brief - The company is a car hire company called Citicar.

    It can be searched fro records quickly using queries and filters. Customers can specify what sort of car they want by using a query. Mail merge saves addresses and customer names having to be looked up and typed out. Over all there is less filing and more time saved because of the new database.

  1. a level ict project

    The tables represented in standard notation above aren't in 2nd normal form because, for example, employee work plan is not dependant on the employee ID. Therefore I need to introduce a third table that acts as a link; this will be the employee work plan table.

  2. Smarts Leisure Park Database Booking System

    I will create it in accordance with the entity definitions and the data dictionary. This screenshot shows me inputting the data into the table. I will then do the same for all of the other fields in accordance with the entity definition and the data dictionary.

  1. System requirements analysis

    * Patient and insurance company balances displayed in every patient-related view * Budget billing plan specific to the individual patient * Custom fields available for user-defined information * Automatic computation of all managed care data * Easy viewing of managed care issues such as capitation, referral tracking, copayments, number of

  2. ICT Case Study Coursework - Hull Daily Mail Publications Ltd.

    enabled on the local machine, most of the machines are personal to their user (not shared between many people), and therefore users can install any software they link onto their machine as long as it causes no damage to the network or the machine itself.

  1. GCSE Calculator Project

    This would mean that even if I were to forget to bring my memory stick, I can access my work anyway because most computers now days have internet access. Data flow Diagrams Input User Security In order to stop the silver surfers making accidental changes to the calculator we can stop them from looking at the calculator in design view.

  2. Computer Studies Past paper definitions

    printer out of paper, pressing break key [2] (d) buffer any two points from: temporary store/memory allows speed of CPU/devices to be matched to hold data being transferred between peripherals and CPU e.g. pages stored waiting to be printed [2] (e)

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