Computer Science Project Report
OCR GCE A
Hambrough Primary School
Room Booking System Project
H446-03
Centre Number:
Candidate Number:
Candidate Name Usman Mir
, H446-03 – Project CONTENTS
Analysis
3.1.1 Problem Identification 3
Problem Definition 5
Computational Approach 6
3.1.2 Stakeholders 10
Identified and described relevant stakeholders 10
3.1.3 Research 12
Similar solutions to my problem 13
Essential features of a Computational Solution 22
Limitations of proposed solution 24
3.1.4 Proposed solution 26
Software Requirements 26
Hardware Requirements 26
Success Criteria 28
Design 35
3.2.1 Decomposition 36
Breaking down the problem 37
3.2.2 Description of Solution 44
Structure of the solution 45
Algorithms 58
Usability features 72
Key variables/data structures/classes/Validation 81
Developing the Solution 100
3.3.1 Iterative development process & 3.3.2 100
Evidence 100
Module 1 – Create Account 101
Module 2 – Login 140
Module 3 – Customers 147
Module 4 – Managers 159
Evaluation 201
3.4.1 Testing for inform evaluation 202
Evidence of testing the solution and Usability features 202
Evidence of the testing the robustness 223
3.4.2 Success of the solution 234
Cross reference to success criteria 234
3.4.3 Describe the final product 242
Usability features Evidence feedback 242
3.4.4 Maintenance and development 245
Maintainability of the solution 245
Further development of the solution 247
,3.1.1 Problem Identification
Description of Client
Hambrough Primary School is a state public school that provides educational services to young
students in their local area. Hambrough Primary is located in Southall, London, and Louise Singleton
has been the head teacher since 2010. According to the BBC, 78% of the students in Hambrough are
expected to meet the Level 4 boundary in English and Maths and only 29% for level 6.
For financial reasons, Hambrough has now allowed customers to hire their rooms/halls to increase
their cash inflow. Their rooms are usually booked for wedding ceremonies and other celebrations.
They also provide other Add-ons for a higher price, such as Wi-Fi, Cafeteria Area.
The head teacher of Hambrough Primary has approached me via email to create a bespoke
hall/room booking system. There are more than a total of 20 different rooms available to hire at this
high school of various sizes that contain different facilities. Therefore this system needs to be
capable of accurately booking in customers without the problem of double bookings. They would
like a system which allows customers to access and view their account, as well as most importantly
make reservations. The finance department will also need frequent updates on bookings as they will
need to add the inflow of cash to their forecast.
Dear Usman Mir,
Good Afternoon Mr Mir, I understand that you study computer science and have some
experience with creating software/programs.
The reason I have contacted you today is that I require a program that will resolve a problem
currently at my school. As the head teacher of this school, I must ensure all staff is comfortable
with their work, however, due to a few changes; our receptionist is struggling to complete her
work. Therefore, I need you to create a program that will work on behalf of this teacher and
manage room bookings for this school.
Our receptionist had previously handled all bookings with a notepad and had documented all
bookings by hand. However, we have recently decided to increase the number of rooms for
bookings and have now become inconvenient to handle bookings without a computer.
Please visit or contact me personally for further information on this problem
07862725657 or Visit me at Hambrough Primary.
Yours Sincerely
Louise Singleton
, With the contact details provided, I called them and asked how their usual procedure was carried
out. Below is an image that depicts the process of how bookings are currently managed at
Hambrough Primary School.
OCR GCE A
Hambrough Primary School
Room Booking System Project
H446-03
Centre Number:
Candidate Number:
Candidate Name Usman Mir
, H446-03 – Project CONTENTS
Analysis
3.1.1 Problem Identification 3
Problem Definition 5
Computational Approach 6
3.1.2 Stakeholders 10
Identified and described relevant stakeholders 10
3.1.3 Research 12
Similar solutions to my problem 13
Essential features of a Computational Solution 22
Limitations of proposed solution 24
3.1.4 Proposed solution 26
Software Requirements 26
Hardware Requirements 26
Success Criteria 28
Design 35
3.2.1 Decomposition 36
Breaking down the problem 37
3.2.2 Description of Solution 44
Structure of the solution 45
Algorithms 58
Usability features 72
Key variables/data structures/classes/Validation 81
Developing the Solution 100
3.3.1 Iterative development process & 3.3.2 100
Evidence 100
Module 1 – Create Account 101
Module 2 – Login 140
Module 3 – Customers 147
Module 4 – Managers 159
Evaluation 201
3.4.1 Testing for inform evaluation 202
Evidence of testing the solution and Usability features 202
Evidence of the testing the robustness 223
3.4.2 Success of the solution 234
Cross reference to success criteria 234
3.4.3 Describe the final product 242
Usability features Evidence feedback 242
3.4.4 Maintenance and development 245
Maintainability of the solution 245
Further development of the solution 247
,3.1.1 Problem Identification
Description of Client
Hambrough Primary School is a state public school that provides educational services to young
students in their local area. Hambrough Primary is located in Southall, London, and Louise Singleton
has been the head teacher since 2010. According to the BBC, 78% of the students in Hambrough are
expected to meet the Level 4 boundary in English and Maths and only 29% for level 6.
For financial reasons, Hambrough has now allowed customers to hire their rooms/halls to increase
their cash inflow. Their rooms are usually booked for wedding ceremonies and other celebrations.
They also provide other Add-ons for a higher price, such as Wi-Fi, Cafeteria Area.
The head teacher of Hambrough Primary has approached me via email to create a bespoke
hall/room booking system. There are more than a total of 20 different rooms available to hire at this
high school of various sizes that contain different facilities. Therefore this system needs to be
capable of accurately booking in customers without the problem of double bookings. They would
like a system which allows customers to access and view their account, as well as most importantly
make reservations. The finance department will also need frequent updates on bookings as they will
need to add the inflow of cash to their forecast.
Dear Usman Mir,
Good Afternoon Mr Mir, I understand that you study computer science and have some
experience with creating software/programs.
The reason I have contacted you today is that I require a program that will resolve a problem
currently at my school. As the head teacher of this school, I must ensure all staff is comfortable
with their work, however, due to a few changes; our receptionist is struggling to complete her
work. Therefore, I need you to create a program that will work on behalf of this teacher and
manage room bookings for this school.
Our receptionist had previously handled all bookings with a notepad and had documented all
bookings by hand. However, we have recently decided to increase the number of rooms for
bookings and have now become inconvenient to handle bookings without a computer.
Please visit or contact me personally for further information on this problem
07862725657 or Visit me at Hambrough Primary.
Yours Sincerely
Louise Singleton
, With the contact details provided, I called them and asked how their usual procedure was carried
out. Below is an image that depicts the process of how bookings are currently managed at
Hambrough Primary School.
