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

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

Extracts from this document...

Introduction

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.

Middle

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.

Conclusion

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

    Disadvantages (How it does not meet my needs) However, as mentioned, the censoring system is heavily flawed. Often, research sites are blocked and it becomes hard to find good sources. Opinions from other people are blocked as they are often classified as 'chat'. Google Translate is also blocked for being classified as a 'proxy'.

  2. ICT PROJECT

    It will also used to summarise archive data for use in charts showing: 1. By gender 2. Form * Data entry form will be able to edit and delete student records. * Conditional formatting will allow automatic shading of cells to give visual message for highlighting grade attained and also table displaying student grades.

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

  2. GCSE Excel Project ICT

    and printed three times (Objective 2) one for the customer, one for the accounts and one for the computer construction. Analyse (9 marks) Appropriate Software identified The software being used is part of the Microsoft Office suite (Microsoft Access and Microsoft Word and Microsoft Excel)

  1. ICT Coursework (MarcoS)

    in the Order is displayed 67 Formula in cell E26 in the Invoice sheet The e-mail address of the customer chosen in the Order is displayed 68 Formula in cell E30 in the Invoice sheet The name of the project chosen in the order is displayed 69 Formula in cell

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

    FROM RATING TABLE PRODUCER COMPANY TEXT (25) COPIES NUMBER OF COPIES NUMBER LOANS TABLE ENTITY NAME ATTRIBUTE NAME ATTRIBUTE DESCRIPTION FIELD SIZE DEFAULT MODE CONSTRAINS LOANS LOAN_ID UNIQUE LOAN IDENTIFIER AUTONUMBER (LONG INTEGER) PRIMARY KEY (P.K) MEMBER_ID UNIQUE MEMBER IDENTIFIER NUMBER (LONG INTEGER) FOREING KEY (F.K) FROM MEMBER TABLE DVD_ID UNIQUE DVD IDENTIFIER NUMBER (LONG INTEGER)

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

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

    Planning of my Method- Project Planning- First I made a clear idea about my database by writing what am I going to include in my database and what all problems I am going to solve. First I researched the problem by going to the library and by asking questions to the book lovers.

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