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

My friend would like to make order of her collection and sort the items into categories. She wants to keep track of the prices she paid for them and the prices that she will end up selling them at - creating a system.

Extracts from this document...

Introduction

Background to the problem. My friend, Ms burke age 37 3/4 is a collector of Garfield items. She's fanatical about anything to do with Garfield. She goes to car boot sales charity shops anywhere that she can get her hands on anything to do with Garfield. She's been collecting them for 5 years, and has not ever organized her collection . Statement of the problem My friend would like to make order of her collection and sort the items into categories. she wants to keep track of the prices she paid for them and the prices that she will end up selling them at. She would also like to keep track of how many items she has, and the condition of the items. Current manual system At present Ms Burke's collection has no organization. When she goes to car boot sales and charity shops she simply puts the Garfield item into a box filled with other Garfield items. Objectives My objectives are: To create a working easy to use system that Ms Burke can use frequently. To be able to sort the Garfield items into groups. Eliminate each software Ms works 2000 This is an integrated package that has all the usual programs in it Microsoft works word, Microsoft works database etc. ...read more.

Middle

It's a type of graphics program Microsoft access- This is the program that will be used. This is a database program, it allows you to create a database you would use it to make of order of something that is disorganized. This program is perfect for Ms Burke, as it shall make her Garfield collection understandable and organized. It fulfills all of the objectives. Alternative Methods Create a new system by using programming languages to write special software. - Advantages, Easily done by someone and the program will fit Ms Burkes needs exactly. - Disadvantages, Its expensive to get someone to program a system that suits Ms Burkes needs. Buy application software and customize it to provide a new system -Advantages, This is an extremely easy option as you can go to a local computer store and buy the software. -Disadvantages, Ms Burke would have to learn how to use the software and would also have to pay for it. Manually with cards write about each Garfield object. - Advantages, costs nothing and can be done by Ms Burke instead of someone else. - Disadvantages, This would take a lot of time and you Ms Burke would be unable to sort her Garfield items into groups easily. ...read more.

Conclusion

I will enter this into the computer by typing it into the keyboard. What Item Is This is what the item is, I will use the codes for this. I will enter this into the computer by typing it into the keyboard. Size This is the size of the item. I will enter this into the computer by typing it into the keyboard. Description This is the description of the item. I will enter this into the computer by typing it into the keyboard. Reference Number This is the number that will identify each item. I will enter this into the computer by typing it into the keyboard. Field name Type Length Codes Used Price Paid Numeric 4 Date bought Date 8 Car Boot Charity Shop Character 2 CB = Car boot CS = Charity shop Condition Numeric 1 1 is for really bad 2 is for not as bad as 1. 3 is for in the middle. 4 is for good. 5 is for excellent Label Character 1 Y for Yes and N No Date sold Date 8 Price Received Numeric 4 What item is Character 2 CT= cuddly toy T= Toys BK= Books LM = Little models O= others PC= pencil case Size Character 1 S= small M= Medium L= Large Description Ref No. Numeric 4 By Marcelle Budnick ...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. I have been given the task of creating a system for a hospital to ...

    To enable patients to have more than one piece of equipment out on loan at a particular time (e.g. 2 crutches and a wheelchair) 6. At the end of each week, a full report of the location of all equipment is to be produced.

  2. Hardware and Software

    because i think CRT monitors are still considered to have a better colour range and are easier to calibrate colour accuracy. These monitors are still very popular in graphic arts where high quality reproduction is important. Benefits: 1. The designs would be seen in better and true colours because most CRT monitors are capable of displaying unlimited colours.

  1. Computer Aided Design Package

    The specifications of DeltaCAD v5.0 are shown below: Component Minimal Recommended Processor Pentium II/equivalent Pentium II/equivalent RAM 64MB 64MB Hard drive 100MB 100MB Video card 16-bit colour, 800 x 600 resolution 24-bit true colour, 1024 x 768 resolution Optical drive CD-ROM CD-ROM Pointing device Mouse Mouse Operating system Windows 95,

  2. I have been given the task to design a database for a company called ...

    Finding price from weight and total dimensions To run this query in my database the user has to fill out the weight field in the 'Parcel form' and then the Order form using that customer's parcel ID, customer ID and destination ID.

  1. You need to discuss the advantages and disadvantages of someone in your

    Sales Assistant How do you keep your records? We currently have a filing cabinet in which we keep all of our records including, customer details, sport equipment details and sales details. How often do you use the current database? Not at all Once a week Every day Several times a day What is the most restricting aspect of the current database?

  2. Introduction to Viruses

    01/14/2002 The "Donut" Virus: This is the first malicious program to infect .NET files."Donut" was developed by the notorious Czech hacker going by the pseudonym "Benny", who is a part of the "29A" virus-writers group. "Benny" is known to be the author of many proof-of-concept viruses, among which are "Stream"

  1. With diagrams compare and contrast the relative advantages and disadvantages of digital transmission over ...

    This is the analogy between the movement of the sun and earth, and the hands of the clock. The digital clock displays the time in numbers, and the time displayed only changes at each minute. In the analogue clock the hands keep moving all the time, while the digital clock is more like an on and off movement.

  2. White Soul System Designs - creating a computer system.

    This then means the customer proving where they live when a letter and proving they identity with a passport or birth certificate. As you can imagine customers would not be very impressed with this and profits may suffer. Stock records can also be misplaced.

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