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

    a record has to be modified, it must first be located in the appropriate filing cabinet, then the data that needs amending is crossed out using a pen or blotted over using correctional fluid before the new data is to be put in.

  2. Marked by a teacher

    Information Age

    3 star(s)

    think this website clearly meet the needs of the students as only the basic points are given here. Also the tests are really simple and are really easier in comparison to the level of the students so therefore might not help the students in relying on to this website only.

  1. Marked by a teacher

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

    This si done through manual calculations within his office. Ellis Redding as head of administration is in charge with all of the paperwork which comes through EVDOP Live. With the current system that EVDOP Live employs, Mr. Redding has o use a paper based system to complete the various forms of administration that he needs to do.

  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. Data Processing Task. Mr Peters, the man who runs this particular Samsung store ...

    have been identified: * All of the staff of the business will be using this system but obviously managers will use it more frequently. All of the staff have trained computer skills as they deal with computers every day but not a lot of them will be familiar with a database so therefore I have to make it user friendly.

  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. Cunha & Ribeiro Ltd: Stock Control & Invoice Database

    The Current System Fact Recording: 1 In order to confirm the problem given to me by Mr. Ribeiro, I have devised the following questionnaire for him to answer that also contains the answers that he has given me: 1. Is your current system electronic or paper-based?

  2. Database Coursework on a Rental System: Design

    qryManufacturerDetails Query Type: Parameter Query Purpose: To locate and view a particular manufacturer's details Tables used: tblManufacturer Criteria: [Please enter a manufacturer] in Manufacturer name field. 13. qryUpdateDateOfLastRental Query Type: Update Query Purpose: To update date of Customer's last rental on their details Tables used: tblRentals, tblCustomer.

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