Student Name:
Unit 5: Programmed Solution to a Problem
A2 Computer Science - 2022
1
, Table of Contents
1. Discussion………………………………………………………………………………………………….5
1.1. Current Form of System……………………………………………………………………………..6
1.2. The Problem…………………………………………………………………………………………..6
1.3. Aims of the Project…………………………………………………………………………………...7
1.4. Possible Limitations of the Project……………………………………………………………….....8
1.5. Using Feedback……………………………………………………………………………………...10
1.5.1. Evaluation of Feedback……………………………………………………………………...11
2. Investigation……………………………………………………………………………………………...12
2.1. Observations………………………………………………………………………………………...12
2.2. Questionnaire………………………………………………………………………………………..13
2.3. Survey………………………………………………………………………………………………..17
2.4. Interviews……………………………………………………………………………………………21
2.5. Existing Documentation……………………………………………………………………………24
2.5.1. Financial Document………………………………………………………………………….24
2.5.2. Customer Information……………………………………………………………………….24
2.5.3. Stock Information…………………………………………………………………………….25
2.6. Existing Solutions to Similar Problems…………………………………………………………...26
2.6.1. Steak of the Art – Cardiff…………………………………………………………………….27
2.6.2. Nando’s………………………………………………………………………………………..27
2.6.3. ResDiary……………………………………………………………………………………….28
2.6.4. EzChef…………………………………………………………………………………………28
2.6.5. ShopKeep POS………………………………………………………………………………..29
2.7. Data, Inputs & Processes…………………………………………………………………………...30
2.8. Limitations of the Current System………………………………………………………………...33
2.9. Stakeholders…………………………………………………………………………………………34
2.10. Aims, Objectives & Success Criteria……………………………………………………………..35
2.11. Methods to be Used for the Solution…………………………………………………………….38
3. Design…………………………………………………………………………………………………….39
3.1. Design Objectives…………………………………………………………………………………...40
3.2. Breaking Down the Problem into Sub Problems………………………………………………...40
3.3. Minimum Require for the Software to Run………………………………………………………42
2
, 3.4. Inputs………………………………………………………………………………………………...43
3.5. Outputs………………………………………………………………………………………………45
3.6. Dataflow Diagrams (DFDs)………………………………………………………………………..48
3.7. Processes Required to Provide a Comprehensive Solution…………………………………….52
3.8. Screen Designs………………………………………………………………………………………54
3.9. Files, Data Structures and Methods of Access…………………………………………………...57
3.10. Entity Relationship Diagram (ERD)……………………………………………………………..63
3.11. Algorithms………………………………………………………………………………………….65
3.12. Validation Design………………………………………………………………………………….68
3.13. System Overview…………………………………………………………………………………..70
4. Software Development………………………………………………………………………………….71
4.1. Login Form…………………………………………………………………………………………..72
4.2. Create Account Form……………………………………………………………………………….74
4.3. Main Menu Form……………………………………………………………………………………77
4.4. Customer Form……………………………………………………………………………………...78
4.5. Booking Form………………………………………………………………………………………..84
4.6. Meal Form……………………………………………………………………………………………88
4.7. Stock Form…………………………………………………………………………………………...92
4.8. SQL Database………………………………………………………………………………………..96
4.9. Search Function……………………………………………………………………………………...98
4.10. Data Model………………………………………………………………………………………..101
4.11. Recursive Algorithms……………………………………………………………………………101
4.12. Data Structures…………………………………………………………………………………...102
4.13. Maintenance Documentation……………………………………………………………………103
5. Testing…………………………………………………………………………………………………...114
5.1. Test Plan…………………………………………………………………………………………….114
5.2. Login Form…………………………………………………………………………………………114
5.3. Create Account Form……………………………………………………………………………...117
5.4. Main Menu Form…………………………………………………………………………………..120
5.5. Customer Form…………………………………………………………………………………….121
5.6. Booking Form………………………………………………………………………………………135
5.7. Meal Form…………………………………………………………………………………………..143
3
, 5.8. Stock Form………………………………………………………………………………………….152
5.9. Search Function…………………………………………………………………………………….162
5.10. Evaluation of Testing…………………………………………………………………………….164
6. Evaluation……………………………………………………………………………………………….165
6.1. Evaluation of the Programming Language Used………………………………………………165
6.2. My System Compared to Similar Commercial Systems……………………………………….166
6.3. Successful Features of My System……………………………………………………………….168
6.4. Potential Improvements to My System………………………………………………………….169
6.5. Strengths of My Own Performance……………………………………………………………...170
6.6. Weaknesses of My Own Performance…………………………………………………………...171
6.7. Future Improvements……………………………………………………………………………..171
6.8. Comparing My Solution to the Original Aims, Objectives, and Success Criteria…………...172
6.9. Problems Encountered While Developing the System………………………………………...175
6.10. Change of Approach……………………………………………………………………………..175
4
Unit 5: Programmed Solution to a Problem
A2 Computer Science - 2022
1
, Table of Contents
1. Discussion………………………………………………………………………………………………….5
1.1. Current Form of System……………………………………………………………………………..6
1.2. The Problem…………………………………………………………………………………………..6
1.3. Aims of the Project…………………………………………………………………………………...7
1.4. Possible Limitations of the Project……………………………………………………………….....8
1.5. Using Feedback……………………………………………………………………………………...10
1.5.1. Evaluation of Feedback……………………………………………………………………...11
2. Investigation……………………………………………………………………………………………...12
2.1. Observations………………………………………………………………………………………...12
2.2. Questionnaire………………………………………………………………………………………..13
2.3. Survey………………………………………………………………………………………………..17
2.4. Interviews……………………………………………………………………………………………21
2.5. Existing Documentation……………………………………………………………………………24
2.5.1. Financial Document………………………………………………………………………….24
2.5.2. Customer Information……………………………………………………………………….24
2.5.3. Stock Information…………………………………………………………………………….25
2.6. Existing Solutions to Similar Problems…………………………………………………………...26
2.6.1. Steak of the Art – Cardiff…………………………………………………………………….27
2.6.2. Nando’s………………………………………………………………………………………..27
2.6.3. ResDiary……………………………………………………………………………………….28
2.6.4. EzChef…………………………………………………………………………………………28
2.6.5. ShopKeep POS………………………………………………………………………………..29
2.7. Data, Inputs & Processes…………………………………………………………………………...30
2.8. Limitations of the Current System………………………………………………………………...33
2.9. Stakeholders…………………………………………………………………………………………34
2.10. Aims, Objectives & Success Criteria……………………………………………………………..35
2.11. Methods to be Used for the Solution…………………………………………………………….38
3. Design…………………………………………………………………………………………………….39
3.1. Design Objectives…………………………………………………………………………………...40
3.2. Breaking Down the Problem into Sub Problems………………………………………………...40
3.3. Minimum Require for the Software to Run………………………………………………………42
2
, 3.4. Inputs………………………………………………………………………………………………...43
3.5. Outputs………………………………………………………………………………………………45
3.6. Dataflow Diagrams (DFDs)………………………………………………………………………..48
3.7. Processes Required to Provide a Comprehensive Solution…………………………………….52
3.8. Screen Designs………………………………………………………………………………………54
3.9. Files, Data Structures and Methods of Access…………………………………………………...57
3.10. Entity Relationship Diagram (ERD)……………………………………………………………..63
3.11. Algorithms………………………………………………………………………………………….65
3.12. Validation Design………………………………………………………………………………….68
3.13. System Overview…………………………………………………………………………………..70
4. Software Development………………………………………………………………………………….71
4.1. Login Form…………………………………………………………………………………………..72
4.2. Create Account Form……………………………………………………………………………….74
4.3. Main Menu Form……………………………………………………………………………………77
4.4. Customer Form……………………………………………………………………………………...78
4.5. Booking Form………………………………………………………………………………………..84
4.6. Meal Form……………………………………………………………………………………………88
4.7. Stock Form…………………………………………………………………………………………...92
4.8. SQL Database………………………………………………………………………………………..96
4.9. Search Function……………………………………………………………………………………...98
4.10. Data Model………………………………………………………………………………………..101
4.11. Recursive Algorithms……………………………………………………………………………101
4.12. Data Structures…………………………………………………………………………………...102
4.13. Maintenance Documentation……………………………………………………………………103
5. Testing…………………………………………………………………………………………………...114
5.1. Test Plan…………………………………………………………………………………………….114
5.2. Login Form…………………………………………………………………………………………114
5.3. Create Account Form……………………………………………………………………………...117
5.4. Main Menu Form…………………………………………………………………………………..120
5.5. Customer Form…………………………………………………………………………………….121
5.6. Booking Form………………………………………………………………………………………135
5.7. Meal Form…………………………………………………………………………………………..143
3
, 5.8. Stock Form………………………………………………………………………………………….152
5.9. Search Function…………………………………………………………………………………….162
5.10. Evaluation of Testing…………………………………………………………………………….164
6. Evaluation……………………………………………………………………………………………….165
6.1. Evaluation of the Programming Language Used………………………………………………165
6.2. My System Compared to Similar Commercial Systems……………………………………….166
6.3. Successful Features of My System……………………………………………………………….168
6.4. Potential Improvements to My System………………………………………………………….169
6.5. Strengths of My Own Performance……………………………………………………………...170
6.6. Weaknesses of My Own Performance…………………………………………………………...171
6.7. Future Improvements……………………………………………………………………………..171
6.8. Comparing My Solution to the Original Aims, Objectives, and Success Criteria…………...172
6.9. Problems Encountered While Developing the System………………………………………...175
6.10. Change of Approach……………………………………………………………………………..175
4
