Sale!
Placeholder

Online Database Driven System for Urban Lifestyle Letting

10,000 3,000

Product Description

Summary
During Easter 2004, Urban Lifestyle Letting set up a basic, static website in order to have some
sort of Internet focal point. The website contained the companies contact details and had a
separate webpage for every property that was available for rent. The main problem that was
noticeable was that none of the staff at ULL had any knowledge of HTML and web development.
A custom made solution had to be created as the user’s requirements were not supported by any
existing solutions.
Urban Lifestyle Letting wanted a dynamic web-based system which could be easily updated
through a password protected administration area. Furthermore, Urban Lifestyle Letting also
wanted a number of message boards that would allow tenants to post requests. This would allow
members of staff to answer the queries in quiet moments during the day in order to reduce the
number of telephone calls happening during peak periods.
In order to plan the development of the system, requirements were gathered from the end user
through a number of meetings and telephone calls. A vast number of tools and methodologies
were analysed in order to see which ones were best suited to the development of the system. The
system was thoroughly designed, implemented and tested in order to produce a high quality
solution. Finally, the system was evaluated to determine its success and how well it met the needs
of the end user.

TABLE OF CONTENTS
CHAPTER 1 – INTRODUCTION 1
1.1 – Introduction to the company 1
1.2 – Problem Definition 1
1.3 – Project Aim 2
1.3.1 – Risk and Mitigation 2
1.4 – Project Objectives 2
1.5.1 – Minimum Functional Requirements 2
1.5.2 – Non-functional Requirements 3
1.6 – Project Extensions 4
1.7 – Deliverables 5
1.8 – Project Schedule 5
1.8.1 –Initial Schedule 5
CHAPTER 2 – BACKGROUND RESEARCH 6
2.1 – HTML Dreamweaver MX 2004 7
2.2 – Database Management Systems (DBMS) 7
2.2.1 – Introduction 7
2.2.2 – MySQL 7
2.2.3 – MS Access 8
2.2.4 – MS SQL Server 2000 8
2.2.5 – PostgreSQL 9
2.2.6 – Conclude and Evaluate 9
2.3 – Server-Side Scripting Languages 9
2.3.1 – Introduction 9
2.3.2 – PHP 10
2.3.3 – ASP 10
2.3.4 – CGI 10
2.3.5 – JSP 11
2.3.6 – Conclude and Evaluate 11
2.4 – Client-Side Scripting Languages 11
2.4.1 – Introduction 11
2.4.2 – JavaScript 11
2.4.3 – VBScript 12
2.4.4 – Conclude and Evaluate 12
2.5 – Software Development Methodologies and Approaches 13
Online Database Driven System for Urban Lifestyle Letting
2.5.1 – Introduction 13
2.5.2 – Traditional Functional Decomposition 13
2.5.3 – Object-Oriented Approaches 13
2.5.4 – Software Development Life Cycle (SDLC) Models 14
2.5.4.1 – The Waterfall Model 14
2.5.4.2 – Rapid Application Development (RAD) 14
2.5.4.3 – Spiral Model 15
2.5.4.4 – Rational Unified Process (RUP) 16
2.5.4.5 – Conclude and Evaluate 16
2.6 – Information Systems Project Management 16
2.7 –Methods of Communication with the User 17
2.8 – Customer Resource Management (CRM) 17
2.9 – Live Help 18
2.10 – Conclusion 19
CHAPTER 3 – DESIGN 20
3.1 – Introduction to the design 20
3.2 – Presentation Tier 21
3.2.1 – Human Computer Interaction (HCI) 21
3.2.2 – User Interface Design 21
3.2.3 – Check Against Acceptance Tests 22
3.3 – Application Tier 24
3.3.1 – Application Design 24
3.4 – MySQL database design (data modelling) – Database server 27
3.4.1 – Normalisation 27
3.4.2 – Keys 27
3.4.3 – ER Diagram 27
3.4.4 – Relationships 28
3.4.5 – First Normal Form (1NF) 28
3.4.6 – Second Normal Form (2NF) 28
3.4.7 – Third Normal Form (3NF) 28
3.4.8 – Data Types 30
3.4.9 – Design Summary 30
CHAPTER 4 – IMPLEMENTATION 30
4.1 – Introduction to the Implementation 30
4.2 – Installation 31
Online Database Driven System for Urban Lifestyle Letting
4.3 – Uploading the Live System onto the World Wide Web 31
4.4 – Presentation Tier Implementation 31
4.4.1 – Presentation Tier Challenging Aspects 31
4.4.1.1 – Search Engine Optimisation (SEO) 31
4.4.1.2 – JavaScript Validation 32
4.4.1.3 – Robots.txt – Security Issue 32
4.5 – Data Storage Tier Implementation 32
4.5.1 – Data Storage Tier Challenging Aspects 33
4.5.1.1 – Quick Search 33
4.5.1.2 – Backup Database Code 33
4.5.1.3 – Restore Database Code 34
4.5.1.4 – Storing Images Using MySQL 34
4.6 – Application Tier Implementation 34
4.6.1 – Reusing of code 35
4.6.2 – Application Tier Challenging Aspects 35
4.6.2.1 – Password Protection 35
4.6.2.2 – Contact Details 36
4.6.2.3 – Automated Live Help Feature 36
4.6.2.4 – Image sizes 37
4.7 – User Documentation 38
4.8 – Implementation Summary 38
CHAPTER 5 – TESTING 38
5.1 – Test Plan 39
5.2 – Unit Testing 39
5.3 – Security checking 40
5.4 – Website Checklist Testing 40
5.5 – System Performance Testing 40
5.6 – Acceptance Testing 41
5.7 – System Changeover 41
5.8 – Testing Summary 42
CHAPTER 6 – EVALUATION 42
6.1 – Introduction to the Evaluation 42
6.2 – Minimum Functional Requirements Reviewed 42
6.3 – Non-Functional Requirements Reviewed 43
6.4 – Project Extensions Reviewed 44
Online Database Driven System for Urban Lifestyle Letting
6.5 – Deliverables 46
6.6 – Technology/Tools Selection 46
6.7 – Time Management 47
6.8 – User Evaluation 47
6.9 – Methodology Chosen 49
6.10– User Satisfaction 49
6.11 – Summary of the Evaluation 49
CHAPTER 7 – FURTHER DEVELOPMENTS AND CONCLUSIONS 49
7.1 – Further Developments 49
7.2 – Conclusions 50
BIBIOGRAPHY 51
APPENDIX A 55
Personal Reflection 55
APPENDIX B 56
Screen Capture of Urban Lifestyle Letting’s Previous Website.
Increasing Size of a Project Equals an Increasing Chance of Failure
Risk and mitigation
Revised Project Schedule
Diagram Showing the Business Use Case for Urban Lifestyle Letting
Diagram Showing the Use Case Diagrams for the System Development
Graph Showing the Cumulative Internet Usage by Time of Day and Place of Usage.
APPENDIX D 63
Acceptance Testing
User Documentation
Web Site Review Checklis

GET THE COMPLETE MATERIAL

INQUIRES:

OUR SERVICES: