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.

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.