Sale!
Placeholder

Leeds Beer, Cider and Perry Festival: a beer purchasing system

10,000 3,000

Topic Description

 ALL listed project topics on our website are complete material from chapter 1-5 which are well supervised and approved by lecturers who are intellectual in their various fields of discipline, documented to assist you with complete, quality and well organized researched materials. which should be use as reference or Guild line...  See frequently asked questions and answeres



Summary
The aim of this project was to develop a system to aid the beer purchasing process at Leeds Beer, Cider and Perry Festival. Buying the beer is a complex task for such a large event. The range of ABV strengths, cask sizes and beer types affect the decision making process. The current Microsoft Excel spreadsheet system is not suitable for a number of reasons.
The Festival is organised by the voluntary consumer group, Leeds CAMRA (The Campaign for Real Ale), so a major requirement was that the system was built using free, Unix compatible technology. The provisional date for completion was the 2004 Festival held from the 11th to the 13th of March. The system was successfully implemented by this deadline using a MySQL database server and an Apache web server configured to run PHP scripts.

Contents
1. Introduction……………………………………………………………………………………………………………1
1.1. Leeds CAMRA…………………………………………………………………………………………………1
1.2. The Beer Festival……………………………………………………………………………………………..1
1.3. Project outline………………………………………………………………………………………………….2
1.4. Project schedule……………………………………………………………………………………………….2
2. Analysis………………………………………………………………………………………………………………….4
2.1. Purchasing issues……………………………………………………………………………………………..4
2.2. The current system……………………………………………………………………………………………6
2.3. Organisational issues…………………………………………………………………………………………7
2.4. User requirements…………………………………………………………………………………………….8
2.5. Methodology………………………………………………………………………………………………….10
2.6. Technology…………………………………………………………………………………………………….11
2.6.1. Operating system…………………………………………………………………………………….11
2.6.2. Storage…………………………………………………………………………………………………..12
2.6.3. User interface………………………………………………………………………………………….12
2.7. Conclusion……………………………………………………………………………………………………..15
3. Design…………………………………………………………………………………………………………………..16
3.1. Database design………………………………………………………………………………………………16
3.1.1. Initial design…………………………………………………………………………………………..16
3.1.2. Nulls……………………………………………………………………………………………………..17
3.1.3. Initial schema………………………………………………………………………………………….18
3.1.4. Normalisation…………………………………………………………………………………………18
3.1.5. Decomposition………………………………………………………………………………………..21
3.1.6. Integrity constraints…………………………………………………………………………………22
iii
Leeds Beer, Cider and Perry Festival: a beer purchasing system Jamie MacLean
3.2. Interface design………………………………………………………………………………………………23
3.2.1. Usability issues……………………………………………………………………………………….24
3.2.2. Browser interface issues…………………………………………………………………………..25
3.2.3. Usability framework………………………………………………………………………………..26
3.3. Conclusion……………………………………………………………………………………………………..28
4. Implementation…………………………………………………………………………………………………….29
4.1. Installation……………………………………………………………………………………………………..29
4.2. Interface prototype………………………………………………………………………………………….29
4.3. Database creation……………………………………………………………………………………………30
4.4. Security and privacy………………………………………………………………………………………..31
4.5. System operations…………………………………………………………………………………………..31
4.5.1. Viewing data…………………………………………………………………………………………..31
4.5.2. Entering and editing data………………………………………………………………………….32
4.5.3. Deleting data…………………………………………………………………………………………..34
4.5.4. Reports…………………………………………………………………………………………………..34
4.5.5. Backup…………………………………………………………………………………………………..36
4.6. Other implementation issues…………………………………………………………………………….36
4.7. Converting to Linux………………………………………………………………………………………..37
4.8. Testing…………………………………………………………………………………………………………..38
4.8.1. Test plan………………………………………………………………………………………………..38
4.8.2. The delivery……………………………………………………………………………………………39
4.9. Conclusion……………………………………………………………………………………………………..39
5. Evaluation…………………………………………………………………………………………………………….40
5.1. The system…………………………………………………………………………………………………….40
5.1.1. User requirements……………………………………………………………………………………40
5.1.2. User acceptance tests……………………………………………………………………………….42
iv
Leeds Beer, Cider and Perry Festival: a beer purchasing system Jamie MacLean
5.1.3. Usability evaluation…………………………………………………………………………………43
5.2. The development process…………………………………………………………………………………45
5.2.1. Methodology…………………………………………………………………………………………..45
5.2.2. Schedule………………………………………………………………………………………………..46
5.2.3. The development stages……………………………………………………………………………46
5.3. Further enhancements……………………………………………………………………………………..48
5.4. Conclusion……………………………………………………………………………………………………..50
References…………………………………………………………………………………………………………………….51
Appendix A – Personal reflection……………………………………………………………………………………54
Appendix B – User interview………………………………………………………………………………………….56
Appendix C – SQL file…………………………………………………………………………………………………..59
Appendix D – Test plan…………………………………………………………………………………………………61
Appendix E – Final file lis

GET COMPLETE MATERIAL