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

    In the proposed system all of the information will be recorded to onscreen forms. Both systems involve recording information to forms, however, the nature of the forms differ. In the current system, there is nothing in place to minimise any errors made by the member of staff entering the data onto the paper.

  2. Marked by a teacher

    Information Age

    3 star(s)

    Question 6: What similar services are available those are not available on the internet? Could these be more appropriate? Source Information There are many sources of revision besides from online. Such as revising form the textbook, revising form the past papers, notes from school, brainstorming, revising with friends, making a cards and revising.

  1. Marked by a teacher

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

    They take control over the allocation of the allocations of business funding and the provisional aspects of the business. Andrew Dufrain as head of finance ensures that the business expenditure is controlled and tries to ensure that some level of profit comes into the company.

  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. Peer reviewed

    Computer Science Info-Age & Ethics

    4 star(s)

    We also should always be extremely cautious about releasing any important information on the web. Even secured transactions are not always safe from fraud, as tools used to break into computer systems can be obtained easily.

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

    Meetings with the client help to give an insight of the final product in advance which reduces the risk of failure. After meeting with client and deciding the cost they draw storyboards by focusing on their client needs. When planning their product the first thing they do is to find

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

  2. PC comparison and Specification

    standard, Memory Stick(tm) Duo, Memory Stick(tm) PRO, Memory Stick(tm) PRO Duo, high speed data transfer and MagicGate compatible SD Slot 1 Rear Interfaces 4 Pin i.LINK(tm) (IEEE1394), 400 Mbps 1 Headphone Jack 1 Microphone Jack (Stereo) 1 Line in 1 RJ-45 Direct Port 1 USB Port (quantity)

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