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

specification I have created this database for a local secondary school called The Connaught School. The database is being created to be used by any member of staff working at the school.

Extracts from this document...

Introduction

Specification Introduction 1.1 Background I have created this database for a local secondary school called The Connaught School. The database is being created to be used by any member of staff working at the school. The Connaught school is located in Hampshire in the Town of Aldershot. The database will be used to store pupils GCSE grades they received in the 2007 exams. It will also contain list of subjects and personal information. The school has open for over thirty years and was originally called Heron wood. The school contains an estimated two and half thousand pupils and year eleven consists of three hundred pupils. The Head teacher of school is Mr. Hanna which has been head for twelve years. The deputy head is Mr. Flower which has been deputy for ten years. The school contains over fifty teachers and helpers. It furthermore has a learning support team which helps the less able pupils. The school accepts boys and girls of any religion and any race. The uniform includes of black blazers, green and black tie, white shirts, black trousers, and black shoes. ...read more.

Middle

In Addition searching for files can be very time consuming. As the school is tremendously busy they have no time to waste. Throughout this process the files can get easily mixed up which creates a major setback. Also as it comes to making reports for each pupil it is awfully difficult and the calculations can be hard to work out. Another problem is that the files are stored in an overly large filing cabinet which takes up a great deal off room. This is not ideal as it will eventually run out of space and furthermore there is no room to expand. The files can also become dusty and tattered which leads to the files becoming unreadable, in addition to this the files are not backed up. The main problem the school faces is that the files are misplaced or lost which is not uncommon. The school can no longer afford to cope with theses problems. By creating this data base for The Connaught school it allows all pupils information to be stored such as pupil ID and GCSE Grades. ...read more.

Conclusion

Showing achieved grade Who achieved A in Science Purpose: Show which pupil reached maximum grade Where: Screen and printer Content: Grade Standard features: Date Processing: Alphabetically. Showing achieved grade Who achieved A in Maths Purpose: Show which pupil reached maximum grade Where: Screen and printer Content: Grade Standard features: Date Processing: Alphabetically. Showing achieved grade Who have the same surname Purpose: Show who are related Where: Screen and printer Content: Surname Standard features: Date Processing: Alphabetically Who lives in Aldershot Purpose: Show who lives in Aldershot Where: Screen and printer Content: Address Standard features: Date Processing: Alphabetically Bar chart List how many A's in each subject Purpose: List how many A's in each subject Where: Screen and printer Content: x axis shows subject names, y axis show total number of A's Standard features: Logo, Date Processing: calculate all numbers of A's in each subject 2.3 What the system must achieve time-wise and size-wise Create new pupil record in 1 minute The time taken to access a pupil record must be less than five seconds Print results at five pages a minute Loads all data in under 30 seconds Accessing pupil record must take less than 10 seconds Must store up to 5000 pupil records ...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 Information Systems and Communication 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 Information Systems and Communication essays

  1. Marked by a teacher

    Database Coursework on a Vehicle Rental System: Analysis

    5 star(s)

    less than 30 seconds; * Date to be returned will be calculated automatically from the fields Number of Nights and Date of Rental; * Total price of the rental will be calculated automatically from the fields Number of Nights and Daily Rental rate, taking into account the miles travelled by

  2. Marked by a teacher

    Information Age

    3 star(s)

    The website should provide more details of the flight and also give information. The information was also given in the Shetland news paper, which clarified that Gatwick being a busy airport's website should be made reliable and easier for the people to use it as much information was not given

  1. Marked by a teacher

    I have been asked to create an ICT solution for a local events and ...

    new system in order to move on and improve from the previous stages of the company. Currently in terms of advertising and publicity, it can be seen that EVDOP is losing a substantial amount of money through their preferred form of advertising, which is leafleting and handing out promotional cards.

  2. Peer reviewed

    Testing Database

    4 star(s)

    Command buttons should open the correct form. 2 Add /edit Customer details and Campaign's Manually add and edit details All customer details added and edited correctly (and errors detected correctly where necessary 3 Add/edit Customers details and Wants. Add and edit details manually Customer's details in Wants should be added correctly and edited.

  1. I have been asked to write a report on current working practice and I ...

    out the key process they need to go through and the functions they need to perform to complete this project. They look at the project as whole and then divide it into the small possible components. To plan their time effectively they look at the animation more clearly.

  2. Data Processing Task. Mr Peters, the man who runs this particular Samsung store ...

    * When a new customer is added or a new order is taken it would be taken down using handwriting by either a blue or black pen. Other people in the company will obviously have different handwriting and they mightn't be able to read the other persons handwriting so this will cause confusion within the company.

  1. User Guide to my minibus hire database.

    - Beside the "Town" label there will be a data entry box, type in the town of the customer's address into this box. - Beside the "County" label there will be a dropdown data entry box, select the county of the customer's address from the drop down list, the default value for every new customer will be "Kent".

  2. PC comparison and Specification

    5 USB Version 2.0 USB Port Type A SPDIF Port 1 Features Special Buttons Power button, WLAN On/Off Built-in Microphone YES Built-in Camera Built-in 'Motion Eye' Digital Camera YES Frames per Second Max.30 Image Sensor (Mega Pixels) 1.3 Motion Pictures max.

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