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

    If equipment is due for return or renewal during the following week, that patient must be contacted, with a standard letter. DESIGN Feasibility of Using a Computer Based System: It has been required that I should produce a computer based system for the hospital.

  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 mid ranged software solution that I think would be suitable to the task the company requires is to use TurboCAD, this keeps the software costs down while still trying to keep the drawing time down on this as well.

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

    If the weight of the parcel is 8 Kg then the price of sending that parcel should be �9.10 as you can see from the appendix. I tested this data by firstly telling the system that the parcel was 8 Kg in weight, the parcel ID, as you can see from below, is 19.

  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. White Soul System Designs - creating a computer system.

    Stock records can also be misplaced. This may lead to the staff members thinking they had ordered new stock but to have it never arrive. This is a problem when a customer has specifically requested that item of stock and has to find out that it will not be delivered till the next stock delivery.

  1. An I.T. System to Track Share Prices

    MS Access This software is a relational database and is not a spreadsheet so cannot be compared. Lotus 123 Simple user interface with many facilities. In some ways better than Excel. Same as excel. Claris Works Spreadsheet Simple to use with common basic functions.

  2. Program Code Program DVD_Program; Uses Menuunit, CRT, dos; ...

    to save record...'); Gotoxy (12, 19); Write(' Press Esc to clear values'); ch:= #0; ch:= ReadKey; If (ch:= #13) then Begin Seek (video, filesize (video)); Write (video, two_rec); Gotoxy (12, 20); TextColor (red+ blink); Write ('Record was saved'); Delay (800); End; Restore_Screen; Window (1, 2, 80, 24); Until (ch= #13);

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