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

    query is performed in which the record of the manufacturers of that particular code or name is displayed onscreen. 22. Customers file updated with date of last rental Input: - Date of Last Rental Data Collection: - This date is entered when a customer makes a rental.

  2. Marked by a teacher

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

    This would make it more relevant and accessible to the prospective customers, who can access it form a mobile device and other forms of media. This would therefore improve efficiency of the company, as they would not need to product mass amounts of leaflets which would in theory just go to waste.

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

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

    some additional time or communicate internally to see what they can do in order to complete it on time. Because they works commercially so if they falling behind on one project they can't just work on it all the time because it will impact other projects.

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

    Documentation of the program will also be necessary in order to familiarise the user with the software. * The user must be able to add new customer records, edit customer records, delete customer records and search for a particular customers record.

  2. 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".

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

  2. Evaluation of the database

    * Averages must be calculated automatically. I did include average functions which update automatically with the addition of new data and the removal of data. This allows the user to easily compare marks. * Graphs must be available for lists of selected information and an appropriate graph should be produced.

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