100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
WJEC A-Level Computer Science Unit 5 £7.99
Add to cart

Other

WJEC A-Level Computer Science Unit 5

 294 views  9 purchases

This is an example of a Unit 5 coursework that achieved full UMS marks in 2022. Please do not directly copy from this document, it is only to be used as an example on how to achieve the highest bands on each individual section.

Preview 4 out of 176  pages

  • April 23, 2023
  • 176
  • 2021/2022
  • Other
  • Unknown
All documents for this subject (1)
avatar-seller
caipugh
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

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller caipugh. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for £7.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

53068 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy revision notes and other study material for 14 years now

Start selling
£7.99  9x  sold
  • (0)
Add to cart
Added