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

Introduction

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.

Middle

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.

Conclusion

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. Standalone vs networked computers

    For example if the network file server goes down, no computer can gain access to the shared files * The initial costs involved in setting up a network are high as all the hardware and software need to purchased, although a network will save money in the long run, in

  2. ICT PROJECT

    * It will be easy and clear to use. * The new system will produce an average performance percentage for each student. And also it will automatically convert numerical marks to percentages. * It should have protection to prevent accidental deletion of important formulae, numbers, table, chart and text.

  1. Analysing Qualitative Interviews

    (Miles, M.B. and Huberman, A.M 1994). Good qualitative analysis relies on the "skill, vision and integrity of the researcher doing that analysis" (Pope, Ziebland, and Mays; Qualitative research 2000). The results are only effective, if the researcher is to with their work.

  2. GCSE Excel Project ICT

    AlienWARE Go to sheet1 select insert value '3' in D4 Pass Back Go to sheet 1 Pass Button123_Click Go to sheet 7 Pass Corsair1 Go to sheet1 select insert value '2' in D10 Pass Corsair2 Go to sheet1 select insert value '3' in D10 Pass Corsair512 Go to sheet1 select

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

    out forms with titles, field names and concise instructions for entering data into multiple tables. The database must be rigorously tested with specifically designed test data that demonstrates the effective use of validation and the resulting error messages. You should have at least 20 records in all tables to ensure that the validation checks are effective.

  2. Computer project Alevels

    Queries and macros used 5.1.8.1. Queries * Special Information on Patients Query Field Table [PATIENT_NO] Table - Patient's Details [FIRST_NAME] Table - Patient's Details [CIVIL] Table - Patient's Details [DOB] Table - Patient's Details [SEX] Table - Patient's Details [NOTES] Table - Patient's Details This query is being used to identify each patient specifically.

  1. 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.

  2. Computer Studies Past paper definitions

    1 Generally, one mark per valid point. Two examples can gain two marks. (a) mouse pointing device/controls cursor input device allows user to select options from a menu used in windows environment uses buttons/scroll wheels(s)/touch pad [2] (b) search engine used on the Internet to locate web sites/web pages/other links based on input of certain key phrases/words [2] (c)

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