1.2
Statement of problem-
At the moment in the Conaught schhol they have been using paper files stored in filing cabinets, which has caused a numerous amount of problems. This has created an insufficient system which has made it very difficult to record data over the years. It is unprofessional and inaccurate which is why I have created this data base in order to resolve their situation. During the past years The Connaught School has encountered many problems. For example searching for each individual pupil can be extremely difficult. 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. Along with this personal information can be stored such as Address, contact number and post code.
2.1
What the system must input and store
GCSE results- All results achieved
Address- Where they currently live
Phone number- Current home phone number
Pupil details- Extra information about pupils
Age- Current age
Gender- Male or Female
Subjects- List of subjects
Pupil number- Pupils ID number
Pupil grade- The grade pupil’s achieved
Photo- Recent photo of pupil
E-mail- Pupils current e-mail
2.2
What the system must process and output
Pupil list
Purpose: Show all pupils
Where: Screen and printer
Content: First name, tutor group and pupil ID
Standard features: Date
Processing: Alphabetically
Who failed English
Purpose: To show the grade in which the pupil failed at
Where: Screen and printer
Content: Grade
Standard features: Date
Processing: Alphabetically. Showing achieved grade
Who failed Science
Purpose: To show the grade in which the pupil failed at
Where: Screen and printer
Content: Grade
Standard features: Date
Processing: Alphabetically. Showing achieved grade
Who failed Maths
Purpose: To show the grade in which the pupil failed at
Where: Screen and printer
Content: Grade
Standard features: Date
Processing: Alphabetically. Showing achieved grade
Who achieved A in English
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 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