Sale!
Placeholder

Europacking.com : An interactive database driven website for travellers

10,000 3,000

Product Description

Summary
The main aim of the project was to design and develop a database driven website. The website
“Europacking.com” was to provide travellers with services and facilities so that they could store their
personal details, and compare itineraries.
The personal aims of this project are to
• Have a greater understanding of what web site design involves.
• To further my understanding of databases.
• To gain experience in designing and developing a project.
• To improve my skills in linking a database to a web site.
The main objectives of the project were
• To research relevant topics to help in the design and implementation of the system.
• To create a database driven web site that stores a members personal details as well as their
itinerary, which can be used to compare against others.
• To test the system
• To evaluate the system
The report will explain the design methodology used to construct the system and how it was used. It
will also describe design issues and how the system was implemented. The report will discuss the
testing of the system and whether the system worked correctly. Finally the system will be evaluated to
see whether it met the user’s requirements.

TABLE OF CONTENTS
SUMMARY II
ACKNOWLEDGEMENTS III
CHAPTER 1: INTRODUCTION 1
1.1 OVERVIEW OF THE PROBLEM 1
1.2 PROJECT AIMS 1
1.3 OBJECTIVES 1
1.4 MINIMUM REQUIREMENTS 2
1.5 FURTHER REQUIREMENTS 2
1.6 PROJECT MANAGEMENT 2
CHAPTER 2: BACKGROUND RESEARCH 4
2.1 DESIGN METHODOLOGIES 4
2.1.1. THE WATERFALL METHOD 4
2.1.2. EVOLUTIONARY MODEL 5
2.1.3. SSADM (STRUCTURED SYSTEMS ANALYSIS AND DESIGN METHODOLOGY) 6
2.2 EVALUATION OF METHODOLOGIES 7
2.3 WEB DEVELOPMENT TOOLS 7
2.3.1 DREAMWEAVER 8
2.3.2 MICROSOFT FRONTPAGE 8
2.3.3 HTML LANGUAGE 8
2.4 EVALUATION OF WEB DEVELOPMENT TOOLS 8
2.5 DATABASE MANAGEMENT SYSTEMS 8
2.5.1 SQL SERVER 9
2.5.2 ORACLE 9
2.5.3 MICROSOFT ACCESS 9
2.6 EVALUATION OF DATABASE MANAGEMENT SYSTEMS 10
2.7 CLIENT SIDE AND SERVER SIDE PROCESSING LANGUAGES 10
2.7.1 JAVASCRIPT 10
2.7.2 VBSCRIPT 10
2.8 CLIENT SIDE PROCESSING 11
2.9 EVALUATION OF CLIENT SIDE PROCESSING 11
2.10 SERVER SIDE PROCESSING 11
2.10.1 CGI (COMMON GATEWAY INTERFACE) 11
2.10.2 PHP (HYPER TEXT PRE-PROCESSOR) 12
2.10.3 ASP (ACTIVE SERVER PAGES) 12
2.11 EVALUATION OF SERVER SIDE PROCESSING 12
2.12 WEB SECURITY STRATEGIES 13
2.12.1 SECURE SOCKET LAYER 13
2.12.2 SECURE HYPERTEXT TRANSFER PROTOCOL (S-HTTP) 13
2.13 EVALUATION OF SECURITY ISSUES 13
CHAPTER 3: ANALYSIS 14
3.1 REQUIREMENTS ANALYSIS 14
Mark Maris 004-223-748
v
3.2 DATA REQUIREMENTS 14
3.3 FUNCTIONAL REQUIREMENTS 14
3.4 FURTHER FUNCTIONAL REQUIREMENTS 15
3.5 NON-FUNCTIONAL REQUIREMENTS 15
3.6 SUMMARY 15
CHAPTER 4: DESIGN 16
4.1 DATA MODELLING 16
4.2 E-R MODELLING 17
4.2.1 THE BASIC CONSTRUCTS OF THE DATABASE USING E-R MODELLING 17
4.3 OBJECT MODELLING 18
4.4 LOGICAL DESIGN 19
4.5 PHYSICAL DESIGN 19
4.6 DATA DEFINITION 19
4.7 FUNCTIONAL DEPENDENCIES 19
4.8 NORMALISATION 20
4.8.1 FIRST NORMAL FORM (1NF) 21
4.8.2 SECOND NORMAL FORM (2NF) 21
4.8.3 THIRD NORMAL FORM (3NF) 21
4.8.4 NORMALIZING THE RELATIONS 21
4.9 DATABASE SCHEMA 22
4.10 INTEGRITY CONSTRAINTS 22
4.10.1 ENTITY INTEGRITY RULES 22
4.10.2 REFERENTIAL INTEGRITY RULES 23
4.10.3 INSERT AND DELETE RULES 23
4.11 WEB SITE DESIGN 23
4.11.1 AESTHETICS: 24
4.11.2 USABILITY 24
4.11.3 FUNCTIONALITY 24
4.12 DESIGNING THE INTERFACE 25
4.12.1 BROWSER ISSUES 25
4.12.2 BANDWIDTH CONSIDERATIONS 25
4.13 WEBSITE NAVIGATION 26
4.14 ASP 26
4.14.1 ASP NAVIGATION 26
4.15. THE BASIC WAY IN WHICH THE WEB SITE WORKS 27
4.16. HUMAN COMPUTER INTERACTION (HCI) 27
4.17. SUMMARY 28
CHAPTER 5: IMPLEMENTATION 29
5.1 WEB SITE IMPLEMENTATION 29
5.2 PAGE LAYOUT 29
5.3 ASP FILES 29
5.4 HOME PAGE 30
5.5 THE LOGIN 30
5.6 REGISTRATION PAGE 31
5.7 MEMBERS PAGE 32
Mark Maris 004-223-748
vi
5.7.1 VIEW PASSPORT DETAILS 32
5.7.2 VIEW PLANNED ITINERARY 33
5.7.3 VIEW REGISTERED DETAILS 33
5.7.5 VIEW NOTICEBOARD 36
5.7.6 VIEW PHOTOS 36
5.7.7 LINKS PAGE 36
5.7.8 ERROR PAGES 36
5.7.9 ITINERARY PAGE 36
5.7.10 COUNTRIES PAGES 37
5.7.11 NOTICE BOARD PAGE 38
5.8 DATABASE IMPLEMENTATION 38
5.8.1 TABLES 38
5.8.2 RELATIONSHIPS 39
5.8.3 INTEGRITY CONSTRAINTS 39
CHAPTER 6: TESTING 40
6.1 WHITE BOX TESTING 40
6.2 BLACK BOX TESTING 40
6.3 BROWSER TESTING 40
6.4 DATABASE TESTING 41
6.5 USER TESTING 42
6.6 SUMMARY 43
CHAPTER 7: EVALUATION 44
7.1 EVALUATION CRITERIA 44
7.2 EVALUATION OF THE SYSTEM 44
7.3 EVALUATION OF DESIGN METHODOLOGY 46
7.4 FUTURE IMPROVEMENTS 46
7.3.1 FUNCTIONALITY 46
7.3.2 NON FUNCTIONAL 47
7.5 SUMMARY 47
REFERENCES 48
APPENDIX B – REFLECTION ON THE PROJECT 51
APPENDIX C – SCHEDULE 54
APPENDIX D – DATA DEFINITIONS 55
APPENDIX E – WHITE BOX TESTING 57
APPENDIX E – WHITE BOX TESTING

GET THE COMPLETE MATERIAL

INQUIRES:

OUR SERVICES: