Sale!
Placeholder

A Database Driven Website for A Commercial Vehicle Dealer

10,000 3,000

Product Description

SUMMARY
The Aim of The Report
To produce a database driven website that can be maintained by a non IT specialist for a
commercial vehicle dealer. The company currently has a website but it has been under
construction for over a year.
Minimum Requirements
The minimum requirements were agreed as follows:
Website that displays a list of current vehicles in stock
Database to hold stock with user friendly system for adding and removing vehicles.
A requirements form on the website to allow customers to submit the vehicle type
they are looking for.
Training Manual for staff (Non IT specialist).
Marketing of Website – Advice to client on how to get the site seen by customers.
In Addition to producing a website it was hoped that this project would help provide better
structure and organisation of my client’s vehicles. Research into the way my client operates
was carried out. As a result, of this research provided the opportunity for recommendations
to be made with a hope of making improvements.
The aims and objectives of this project were successfully completed and implemented. The
website was created using ASP and Microsoft Access database. It was developed and
tested from my personal web space but has since been moved to a host provider. The site
can be found at the following address:

CONTENTS PAGE
1. INTRODUCTION…………………………………………………………………………
1.1. The Company……………………………………………………………………….
1.1.1. Organisation…………………………………………………………………
1.1.2. Working Practices…………………………………………………………..
1.1.3. The Need…………………………………………………………………….
1.2. The aims and Requirements………………………………………………………
1.2.1. The Aim of the Report………………………………………………………
1.2.2. Minimum Requirements……………………………………………………
1.3. System Development………………………………………………………………
1.4. Deliverables…………………………………………………………………………
1.5. Scope of the Project………………………………………………………………
1.6. Structure of the Report
1
1
1
1
1
1
1
2
2
2
3
3
2. RESEARCHING PACE SERVICES……………………………………………………
2.1. Research Methods………………………………………………………………….
2.1.1. Questionnaires………………………………………………………………
2.1.2. Interviews…………………………………………………………………….
2.1.3. Method Selected……………………………………………………………
2.1.4. Observations of Competitors………………………………………………
2.2. Interview Results……………………………………………………………………
2.2.1. Stock Control………………………………………………………………..
2.2.2. Paceservices.co.uk…………………………………………………………
2.2.3. IT Resources…………………………………………………………………
2.2.4. Website Brief…………………………………………………………………
4
4
4
4
4
4
5
5
5
6
6
3. PACESERVICES.CO.UK REQUIREMENTS…………………………………………
3.1. Website Contents……………………………………………………………………
3.2. Database Requirements……………………………………………………………
3.3. Maintenance Issues………………………………………………………………..
3.4. Access Issues……………………………………………………………………….
3.4.1. Web Browsers……………………………………………………………….
3.4.2. Authentication Issues………………………………………………………
7
7
7
7
8
8
8
4. BACKGROUND RESEARCH………………..………………………………………..
4.1. Database Architecture……………………………………………………………..
4.2. Choosing Development Tools…………………………………………………….
9
9
10
Stuart M Read IV
4.2.1. Database…………………………………………………………………….
4.2.2. Scripting Language…………………………………………………………
4.2.3. HTML Editor…………………………………………………………………
10
12
12
5. DESIGN AND IMPLEMENTATION……………………..…………………………….
5.1. User Interface Design………………………………………………………………
5.2. Interface………………………………………………………………………………
5.3. Database Design……………………………………………………………………
5.3.1. Pictures………………………………………………………………………
5.3.2. Integrity………………………………………………………………………
5.3.3. Security………………………………………………………………………
5.4. Online Contact Form………………………………………………………………
5.5. Hosting……………………………………………………………………………….
5.6. Problems Encountered on Implementation………………………………………
13
14
14
14
15
15
15
16
16
16
6. EVALUATION…………………………………………………………………………….
6.1. Unit Testing………………………………………………………………………….
6.1.1. Unit Testing Results…………………………………………………………
6.2. User Acceptance Testing…………………………………………………………..
6.2.1. Advantage and Disadvantages of Usability Questionnaires……………
6.2.2. Questionnaire Design………………………………………………………
6.2.3. User Acceptance Results…………………………………………………..
6.3. Future Work………………………………………………………………………….
6.3.1. Minor Tasks………………………………………………………………….
6.3.2. Major Tasks………………………………………………………………….
18
18
18
18
19
20
20
21
21
21
7. CONCLUSIONS………………………………………………………………………….
7.1. Conclusion……………………………………………………………………………
7.2. Reflection…………………………………………………………………………….
22
22
22
REFERENCES……………………………………………………………………………….. 24
APPENDIX A – Project Schedule
APPENDIX B – Interview Transcript
APPENDIX C – Testing
APPENDIX D – User Manual
APPENDIX E – Marketing Report

DOWNLOAD (CHAPTER 1-5)