Sale!
Placeholder

Design, Develop & Deploy a sustainable website for the YSBA

10,000 3,000

Product Description

Summary
The Yorkshire Schools Badminton Association (YSBA) is the only badminton association dedicated for children in Leeds. The YSBA wanted to produce a series of web pages to help YSBA members find out any information that they needed. The objective of this project was to produce a website that caters players, parents, coaches and committee members.
The minimum requirements for this website were:
• Recommendation of a Potential Hosting Solution
• Design Documentation of the Website
• Produce Prototype, which Addresses the Issue of Content Update
• Varying Levels of Access Control and Usability in Mind
The potential further enhancements for this website are listed below:
(Uncompleted enhancements in italic)
• Member Login
• Registration to YSBA website
• Updateable Web pages incorporating easy to use forms
• Administrator password protected pages
• High Level of Usability (e.g. 3-clicks to any page)
• Deploy website onto YSBA web server
• Personalised Member Area/Pages
These minimum requirements and the majority of further enhancements were successfully implemented. The YSBA website was created using PHP in conjunction with a MySQL database. It was developed and tested on the School of Computing’s ‘CSMS5’ server, and can be found at the following link.
http://csms5.soc.leeds.ac.uk/iszpgm/website/index.php
It is hoped that the website can be moved to the YSBA web server in the near future and be made available for YSBA members on a permanent basis. The YSBA web server address is www.ysba.org.uk.

Contents
ACKNOWLEDGEMENTS……………………………………………………………………………………………………………………………I
SUMMARY…………………………………………………………………………………………………………………………………………………II
CONTENTS……………………………………………………………………………………………………………………………………………….III
1 – PROBLEM DEFINITION………………………………………………………………………………………………………………………..1
1.1 – INTRODUCTION…………………………………………………………………………………………………………………………………….1
1.2 – OVERVIEW OF THE YSBA……………………………………………………………………………………………………………………..1
1.3 – PROBLEM ANALYSIS…………………………………………………………………………………………………………………………….1
1.4 – AIMS & OBJECTIVES…………………………………………………………………………………………………………………………….2
1.4.1 – Aim…………………………………………………………………………………………………………………………………………….2
1.4.2 – Primary Objectives………………………………………………………………………………………………………………………2
1.4.3 – Minimum Requirements…………………………………………………………………………………………………………………2
1.4.4 – Further Enhancements…………………………………………………………………………………………………………………..3
1.5 – METHODOLOGY REVIEW/RESEARCH……………………………………………………………………………………………………….4
1.5.1 – Different methodologies…………………………………………………………………………………………………………………4
1.5.2 – Chosen Methodology & Purpose……………………………………………………………………………………………………6
1.5.3 – Use Case Diagram………………………………………………………………………………………………………………………..6
1.5.4 – Iterations in Prototyping………………………………………………………………………………………………………………..6
1.6 – ORGANISATION OF THE REPORT……………………………………………………………………………………………………………..7
1.7 – PROJECT MANAGEMENT/SCHEDULE……………………………………………………………………………………………………….7
2 – ANALYSIS & RESEARCH……………………………………………………………………………………………………………………..8
2.1 – CURRENT WEBSITE DETAILED ANALYSIS………………………………………………………………………………………………..8
2.1.1 – Overview of Website……………………………………………………………………………………………………………………..8
2.1.2 – Usability Analysis & Current Status………………………………………………………………………………………………..9
2.1.3 – Initial Meeting with Peter Hainsworth…………………………………………………………………………………………..12
2.1.4 – Lessons to be Learned…………………………………………………………………………………………………………………12
2.2 – USER REQUIREMENTS…………………………………………………………………………………………………………………………13
2.2.1 – Functional Requirements…………………………………………………………………………………………………………….13
2.2.2 – Non-Functional Requirements………………………………………………………………………………………………………14
2.3 – POTENTIAL HOSTING OPPORTUNITIES……………………………………………………………………………………………………14
2.4 – PLATFORM TO BE USED……………………………………………………………………………………………………………………….14
2.4.1 – Potential Technologies to Use………………………………………………………………………………………………………14
2.4.2 – Chosen Technologies & Why………………………………………………………………………………………………………..18
3 – DESIGN…………………………………………………………………………………………………………………………………………………19
3.1 – PROTOTYPING APPROACH TO OPTIMISE DESIGN…………………………………………………………………………………….19
3.1.1 – Feedback Loops & Iterations……………………………………………………………………………………………………….19
3.1.2 – Number of Iterations?…………………………………………………………………………………………………………………19
3.1.3 – How to Deal with Users Problems and Initial Feedback………………………………………………………………….19
3.1.4 – Solving Problems & Comments on Initial Feedback………………………………………………………………………..19
3.2 – ARCHITECTURE FOR THE SYSTEM…………………………………………………………………………………………………………20
3.2.1 – Presentation Layer………………………………………………………………………………………………………………………20
3.2.2 – Business Logic (Application Layer)……………………………………………………………………………………………….21
3.2.3 – Database Layer…………………………………………………………………………………………………………………………..21
3.3 – PRESENTATION LAYER DESIGN…………………………………………………………………………………………………………….21
3.3.1 – Navigation…………………………………………………………………………………………………………………………………21
3.3.2 – Forms Usage……………………………………………………………………………………………………………………………..22
3.3.3 – Look & Feel……………………………………………………………………………………………………………………………….22
3.3.4 – Usability & HCI Issues………………………………………………………………………………………………………………..23
3.3.5 – Passwords………………………………………………………………………………………………………………………………….24
3.3.6 – Browser Capabilities & Compatibilities…………………………………………………………………………………………24
3.3.7 – Assumed Variables………………………………………………………………………………………………………………………24
3.3.8 – Prioritisation………………………………………………………………………………………………………………………………24
3.4 – DATABASE DESIGN…………………………………………………………………………………………………………………………….24
3.4.1 – Database Schema……………………………………………………………………………………………………………………….24
3.4.2 – ER Diagram……………………………………………………………………………………………………………………………….25
3.5 – APPLICATION LAYER/BUSINESS LOGIC………………………………………………………………………………………………….26
IV
3.5.1 – Satisfy Requirements……………………………………………………………………………………………………………………26
3.5.2 – Membership……………………………………………………………………………………………………………………………….26
3.5.3 – Security (Access Rights/Levels)…………………………………………………………………………………………………….26
3.5.4 – Hierarchy of Files and Proposed File Naming System……………………………………………………………………..27
3.5.5 – Validation of Input………………………………………………………………………………………………………………………28
3.6 – POST INSTALLATION USER SUPPORT…………………………………………………………………………………………………….28
4 – IMPLEMENTATION OF SYSTEM………………………………………………………………………………………………………29
4.1 – PRESENTATION LAYER………………………………………………………………………………………………………………………..29
4.1.1 – Look & Feel……………………………………………………………………………………………………………………………….29
4.1.2 – CSS (Cascading Style Sheets)………………………………………………………………………………………………………30
4.1.3 – JavaScript…………………………………………………………………………………………………………………………………31
4.1.4 – Navigation…………………………………………………………………………………………………………………………………31
4.1.5 – Iterations/Feedback……………………………………………………………………………………………………………………32
4.1.6 – Things to Keep in Mind………………………………………………………………………………………………………………..33
4.2 – DATABASE IMPLEMENTATION………………………………………………………………………………………………………………33
4.2.1 – Database Tables…………………………………………………………………………………………………………………………33
4.2.2 – MySQL Queries………………………………………………………………………………………………………………………….33
4.2.3 – Connecting to the CSMS5 Database………………………………………………………………………………………………35
4.3 – APPLICATION LAYER/BUSINESS LOGIC………………………………………………………………………………………………….35
4.3.1 – Business Processes……………………………………………………………………………………………………………………..35
4.3.2 – Creating a PHP Session for Member Login……………………………………………………………………………………35
4.3.3 – Arranging Files Logically…………………………………………………………………………………………………………….36
4.3.4 – Validation of Fields…………………………………………………………………………………………………………………….36
4.4 – USER SUPPORT………………………………………………………………………………………………………………………………….36
4.4.1 – Online Help………………………………………………………………………………………………………………………………..36
4.4.2 – Website User Manual………………………………………………………………………………………………………………….37
4.4.3 – Administration Manual………………………………………………………………………………………………………………..37
4.4.4 – Backup & Recovery Guide……………………………………………………………………………………………………………37
4.4.5 – Handover Procedures & General Guidelines………………………………………………………………………………….37
5 – TESTING & EVALUATION…………………………………………………………………………………………………………………38
5.1 – METHODS OF TESTING………………………………………………………………………………………………………………………..38
5.1.1 – Black Box Testing……………………………………………………………………………………………………………………….38
5.1.2 – Unit Testing……………………………………………………………………………………………………………………………….39
5.1.3 – Integration Testing………………………………………………………………………………………………………………………39
5.1.4 – User Acceptance Testing……………………………………………………………………………………………………………..40
5.1.5 – Summary of Test Methods……………………………………………………………………………………………………………40
5.2 – TESTING CRITERIA’S………………………………………………………………………………………………………………………….41
5.2.1 – Black Box Testing Criteria…………………………………………………………………………………………………………..41
5.2.2 – Unit Testing & Integration Testing Criteria…………………………………………………………………………………..41
5.2.3 – User/Administrator Acceptance Testing Criteria…………………………………………………………………………….41
5.2.4 – Communication Techniques………………………………………………………………………………………………………….41
5.3 – TEST & EVALUATE USER DOCUMENTATION………………………………………………………………………………………….42
5.4 – USER ACCEPTANCE RESULTS………………………………………………………………………………………………………………42
5.4.1 – User Acceptance Summary………………………………………………………………………………………………………….42
5.4.2 – Download Speed/Times………………………………………………………………………………………………………………..42
5.4.3 – Entering Data (Registration & Login)……………………………………………………………………………………………43
5.4.4 – Navigation…………………………………………………………………………………………………………………………………43
5.4.5 – Usability……………………………………………………………………………………………………………………………………43
5.4.6 – Efficiency…………………………………………………………………………………………………………………………………..44
5.4.7 – Sample Documents………………………………………………………………………………………………………………………44
5.5 – ADMINISTRATOR ACCEPTANCE RESULTS……………………………………………………………………………………………….45
5.5.1 – Administrator Acceptance Summary……………………………………………………………………………………………..45
5.5.2 – Robustness…………………………………………………………………………………………………………………………………45
5.5.3 – Ease of Administration…………………………………………………………………………………………………………………45
5.5.4 – Scalability…………………………………………………………………………………………………………………………………45
5.6 – INSTALLATION EVALUATION (GO-LIVE)………………………………………………………………………………………………..46
5.6.1 – User Website………………………………………………………………………………………………………………………………46
5.6.2 – Administration Website………………………………………………………………………………………………………………..46
5.6.3 – Process of Handover & Technical Problems…………………………………………………………………………………..46
5.7 – FULFILMENT OF REQUIREMENTS & ENHANCEMENTS………………………………………………………………………………47
V
5.7.1 – Did I Meet the Minimum Requirements?………………………………………………………………………………………..47
5.7.2 – Did I Meet Any Further Enhancements?………………………………………………………………………………………..47
5.8 – METHODOLOGIES USED………………………………………………………………………………………………………………………47
5.8.1 – Effective Methodology?……………………………………………………………………………………………………………….47
5.9 –FURTHER WORK THAT COULD BE DONE……………………………………………………………………………………………….47
5.9.1 – Potential Further Enhancements…………………………………………………………………………………………………..47
5.10 COMPARISON TO OTHER WEBSITE………………………………………………………………………………………………………….48
6 – CONCLUSION……………………………………………………………………………………………………………………………………..49
6.1 – SUMMARY OF ACHIEVEMENTS…………………………………………………………………………………………………………….49
6.2 – PROBLEMS ENCOUNTERED…………………………………………………………………………………………………………………..49
6.3 – CHANGES I WOULD DO IN HINDSIGHT…………………………………………………………………………………………………..50
REFERENCES…………………………………………………………………………………………………………………………………………..51
APPENDICES…………………………………………………………………………………………………………………………………………….53
APPENDIX A – PROJECT REFLECTION……………………………………………………………………………………………………………53
APPENDIX B – INITIAL MEETING WITH PETER HAINSWORTH……………………………………………………………………………55
APPENDIX C – YSBA USE CASE DIAGRAM……………………………………………………………………………………………………56
APPENDIX D –PROJECT GANTT CHART…………………………………………………………………………………………………………57
APPENDIX E – WEBSITE MEETING WITH YSBA COMMITTEE……………………………………………………………………………58
APPENDIX F – USER MANUAL……………………………………………………………………………………………………………………..60
APPENDIX G – ADMINISTRATOR MANUAL…………………………………………………………………………………………………….67
APPENDIX H – BACKUP & RECOVERY GUIDE………………………………………………………………………………………………..71
APPENDIX I – HANDOVER PROCEDURES & GENERAL GUIDELINES……………………………………………………………………72
APPENDIX J – DATAFLOW DIAGRAM…………………………………………………………………………………………………………….73
APPENDIX K – CODE LISTINGS…………………………………………………………………………………………………………………….74
APPENDIX L – DATABASE TABLES NAMES & EXAMPLE (MEMBERS)…………………………………………………………………87
APPENDIX M – USER ACCEPTANCE QUESTIONNAIRE………………………………………………………………………………………88
APPENDIX N – USER ACCEPTANCE GRAPH……………………………………………………………………………………………………89
APPENDIX O – SAMPLE DOCUMENTS……………………………………………………………………………………………………………90
APPENDIX P – ADMINISTRATOR ACCEPTANCE QUESTIONNAIRE……………………………………………………………………….91
APPENDIX Q- ADMINISTRATOR ACCEPTANCE GRAPHS……………………………………………………………………………………

GET THE COMPLETE MATERIAL

INQUIRES:

OUR SERVICES: