• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  • Level: GCSE
  • Subject: ICT
  • Word count: 1300

I.T. Project – Converting a Card Index System to a Database

Extracts from this document...


I.T. Project - Converting a Card Index System to a Database Analysis and Initial Ideas The present system is based on the manual card index system so most of the work is done by hand, however due to the ever increasing growth of technology, and the internet, a wide range of resources are now being made easily accessible. British Airways has recently introduced booking online, where customers can book a flight and accommodation all over the Internet. Being such a big company as British Airways, most of their bookings are made through travel agents who book the flights and pass the information on to them. Question 1 - Could you describe the current system being used by Question 2 - How are these cards stored? Question3 - What problems do you encounter at the moment? Software Available MICROSOFT OFFICE 2000 WORD PROCESSOR - MICROSOFT WORD 2000 A word processing package is a program or set of programs used to edit, format, store and print documents. Word processors have many important unique features: * Spelling and Grammar Checker Misspelt words, or grammatical errors can be identified and corrected by the words in the computers dictionary. Correct words, identified by the spell check as wrong can be added to the dictionary. ...read more.


It may be something as simple as a list of names and addresses or details of the CDs in your personal collection, or it may contain details of all the customers, products, orders and payments in a large organisation. When made reference to, the word 'database' is assumed to be data held on a computer, but manual databases also exist. Some smaller business (a garage) may hold a card index file with details about a customer and their car. The main difference between a manual and computerised databases is the speed at which data can be accessed. PRESENTATION GRAPHICS - MICROSOFT POWERPOINT 2000 Presentation graphics software such as PowerPoint is useful for putting together a presentation which can be delivered using a computer attached to a projection device, using transparencies and an ordinary overhead projector or as a self-running presentation in, say a shopping centre or cinema. The software allows the user to quickly create 'slides' combining text, graphics and pictures and to create animation or sound effects and 'transition' effects between slides. OPERATING SYSTEM - MICROSOFT WINDOWS 98 Hardware Available These are the specifications of the PC I am using at Home: OPERATING SYSTEM WINDOWS(r) 98 PLUS! CPU INTEL(r) CELERONTM / 333MHZ RAM 64MB FOR WINDOWS(r) ...read more.


I have already started to go through sample projects showing me how to go about certain tasks with a book titled 'Successful I.T. Projects in Excel', written by P.M Heathcote. End User Requirements > Provide detailed reports showing customer booking for every working day. > Produce summary reports for flight bookings in order of popularity. > Allow data entry for new customers. > Provide easy access for amendments to customer details and flight details. > Automatic backup for all centralised records daily and weekly. > Provide an exception report for outstanding customer debts or extreme bank credit limits. > The system should record financial details concerning money in/outstanding. > Allow queries on the current flight availability. Quantitative Criteria > Printed tickets are to be generated within 15 minutes. > Accessing and amending customer/Fight/Airport details should be instantaneous. > Queries are processed promptly on customer request. > Backup should occur automatically every 24 hours. > Flight details processed every Friday (1 hour max) > Exception reports are produced quickly on demand within a minute. Qualitative Criteria > The system should provide a workable Human Computer Interface system according to different users, i.e. simple menu selections or buttons > The company logo is consistent on all forms and reports. > Amount of available screen data is kept to a minimum (increase usability) > Help systems are easily accessible. > > > > British Airways Booking System ...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. Different types of technology How I use ICT at home and at school

    Any small error that could easily be fixed would need the ICT administration office, wasting more and more time. The school is also too virus-amateur. What I mean by this is that they don't know how to handle viruses. To my knowledge, they don't have any anti-virus software installed.


    student's name, gender, overall percentage mark, grade obtained and an automatic comment on progress. Design Choice of Software I think that Microsoft Excel is the best option of software because it has got many features such as: * It has advanced functionality such as pivot table, sort, forms, Vlookup, average, write protection.

  1. GCSE Calculator Project

    These were the addition, subtraction, divide and multiply functions. I can safely say that I have met this objective as my calculator can correctly perform these functions. As the people I am creating this calculator is for the elderly side of the population. I made one of my objectives to make sure that the sizes of the buttons were big enough for the people to read.

  2. Creating a computer system for a video rental shop

    So if we know the video ID, we can determine all video's details To check for the 3NF, It shows that all non-key attributes are mutually independent. There is no calculated attributes in the entity The forth table is transaction line Transaction number Video ID Date of returning All the

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

    data type, which is text, including the telephone number, the reason for this is because the numeric data type will not allow a leading zero as text data type will. On members id the data type is autonumber, which is a numeric number automatically, generate by the system and the

  2. Benefits of using my IT system in the Travel Agents.

    to send them to a college because it will be too expensive, so the solution to this is that you can pay an expert staff member to teach them. This will be beneficial because you are saving on a lot of your money.

  1. Computer project Alevels

    The design of the macro is shown below. Condition Action [text4]="Administrator" And [text6]="MediCare" MsgBox ... OpenForm Not [text4]="Administrator" And [text6]="MediCare" MsgBox [text4]="Administrator" And Not [text6]="MediCare" MsgBox Not [text4]="Administrator" And Not [text6]="MediCare" MsgBox 5.1.9. Structure Charts (DFDs) In this section I have used data flow diagrams to describe my proposed solution.

  2. Computer study project outline - library and book club database.

    tell a good book?s review we get excited and try to find the book in the library or try to search that book in a book store. With Search a Book the student can check whether the book is in the library or not if not then the person can see where they can buy the book.

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