Developed by:
Farrukh Basit Khan
Arsalan Ahmed
Shaeen Abdulla
Usama Umair
Karnel Travels Company 2011
CERTIFICATE OF COMPLETION
This is to certify that Mr. Farrukh Basit, Mr. Arsalan Ahmed, Mr.
Osama Umair & Mr. Shaheen Abdullah has successfully
designed & developed the website for Karnel Travels Company
as a part of their HDSE-1 requirements.
Submitted to: Miss Qurat-ul-Ain
Date of Submission: Dec 25, 2011
Authorized Signature
Batch Code: CF-20101 C
2
Karnel Travels Company 2011
ACKNOWLEDGEMENT
We owe a great many thanks to many people who helped and supported us in
completing this project
Foremost we would like to thank Almighty Allah for giving us strength and ability
to complete this project.
We express my thanks to the Miss.Fouzia Naqvi from (Aptech Computer
Education Shahrah-e-Faisal), for his valuable guidance and extending his great
support which made us complete our project.
Our deep sense of gratitude to our class teacher Miss. Qurat-ul-ain for his great
support, guidance and cooperation which made this project look a lot easier.
We would also thank and appreciate the people at Aptech Computer Education
for their support and our faculty members without whom this project would have
been a distant reality. We also extend our heartfelt thanks to our families and
well-wishers.
THANK YOU
Batch Code: CF-20101 C
3
Karnel Travels Company 2011
Contents
CERTIFICATE OF COMPLETION ..................................................................................................................................2
ACKNOWLEDGEMENT ...............................................................................................................................................3
1. PROBLEM DEFINITION ......................................................................................................................................5
1.1 Project Brief .........................................................................................................................................................5
2. CUSTOMER REQUIREMENT SPECIFICATION .....................................................................................................6
2.1 Project Scope .......................................................................................................................................................6
3. PROJECT PLAN ..................................................................................................................................................7
3.1 Plan ......................................................................................................................................................................7
4. HARDWARE REQUIREMENTS ............................................................................................................................8
5. SUMMARY ........................................................................................................................................................9
6. APPENDIX .......................................................................................................................................................10
6.1 Task Sheet .........................................................................................................................................................10
7. GUI STANDARD DOCUMENT ...........................................................................................................................11
7.1 Header ...............................................................................................................................................................11
7.2 Footer ................................................................................................................................................................11
8. INTERFACE DESIGN DOCUMENT .....................................................................................................................12
8.1 Home Page ........................................................................................................................................................12
8.2 Customer Registration .......................................................................................................................................13
8.3 Hotel Service Detail ...........................................................................................................................................14
8.4 Booking ..............................................................................................................................................................15
9. ADMIN PANEL .................................................................................................................................................16
9.1 Booking ..............................................................................................................................................................16
9.2 Customers ..........................................................................................................................................................17
9.3 Dashboard .........................................................................................................................................................18
9.4 Travel Place .......................................................................................................................................................19
9.5 Travel Service.....................................................................................................................................................20
10. E-R DIAGRAM .............................................................................................................................................21
11. BOOKING ................................................................................................... Error! Bookmark not defined.22
Batch Code: CF-20101 C
4
Karnel Travels Company 2011
1. PROBLEM DEFINITION
1.1 Project Brief
In order to become a leader dedicated to promoting travel and active vacations and
accordingly to attract new customers by providing high quality information through
integrated media, Karnel Travels Company (the Company) needs a website via which
they want to reach out to the customers by providing various information services like
the list of tourist spot, information about the various hotels and restaurants, etc.
Right now, the Company provides the online facility where the customers can visit
online, view and order for the tours and as well the transportation.
If the Company continues to do the same, they will not be able to capture the market
share and consequently, growth will be hampered as the companies now compete on
technological factors and to reach out to customers more effectively and efficiently is
key success factor for any company.
By introducing new website, the customers will get easy access to the Company and
being user friendly complications of booking will be avoided and hence new customer
will be attracted and old customers will be serviced more efficiently and effectively.
Batch Code: CF-20101 C
5
Karnel Travels Company 2011
2. CUSTOMER REQUIREMENT SPECIFICATION
2.1 Project Scope
Objectives
The Company intends to develop a website to achieve following objectives:-
To provide customers with high quality information regarding services provided
and available.
Create an integrated web site that projects a consolidated and consistent image.
To portray image of progressive, firmly grounded travel company serving the
needs of the customers.
To increase visibility of our services options.
To provide features that makes the Company part of a member’s daily functions.
Give people the ability to bypass the phone to contact the Company.
Measure traffic.
To collect feedbacks from customers which in turn will help the Company to
improve is service quality.
Batch Code: CF-20101 C
6
Karnel Travels Company 2011
3. PROJECT PLAN
3.1 Plan
Vision
To be the world leader in services and solutions that enable and transform the
way consumers and businesses gather, manage, distribute and communicate
information.
Objective
By developing the Company’s website, the customers will have easy access to the
Company and being user friendly, complications of booking will be avoided and
hence new customer will be attracted and old customers will be serviced more
efficiently and effectively.
Batch Code: CF-20101 C
7
Karnel Travels Company 2011
4. HARDWARE REQUIREMENTS
Hardware Requirements
Database Server End User
• Pentium IV 1Ghz or over. • PIII .500Mhz
• Ram over 128MB • Ram minimum 128MB
• Hard disk require over 10 GB free • Hard disk require over 1 GB free
Software Requirements
• Microsoft Window 2000/XP/Server 2003/Vista
• Dreamweaver / JavaScript
• SQL Server 2005
• Mozilla Fire Fox
• IE 7.0/ Netscape 6.0
Technology details
.NET
MS SQL Server 2005
Batch Code: CF-20101 C
8
Karnel Travels Company 2011
5. SUMMARY
Purpose of project
The purpose of this project is to give a sample project to work on real life projects.
These applications help us build a larger more robust application.
Why we undertook this project?
We undertook this project to give a prototype for the travel companies so that
our views and innovation might bring in benefits for them.
Participants
Mr. Farrukh Basit
Mr. Arsalan Ahmed
Mr. Shaheen Abdullah
Mr. Osama Umair
Methodology
This project has been carried out using ASPX. After analyzing problem statement,
we have come up with an idea to create a system where customers order their
travel and tours booking and on travel agency confirmation, they will be notified
through email about their booking confirmation.
There is also have a search system where customer can find their targeted
location and service, they can do advance search as well, so they will filter the
result in more meaningful manner.
Batch Code: CF-20101 C
9
Karnel Travels Company 2011
6. APPENDIX
6.1 Task Sheet
P
R Project Activity Plan
O Title Prepared By:
J Date of Preparation of
E Farrukh Basit, Activity Plan.
C Karnel Travels Arsalan Ahmed,
T Company Shaeen Abdullah,
Osama Umair
Sr. # Task Actual Team Mate Status
Start Date Name
1. Problem Review 28th Nov 2011 All Members Done
2. Template/ Layout of 10th Jan 2011 Farrukh Basit Done
Website
3. Database Connecting/ 15th Jan 2011 Arsalan Ahmed Done
Configuration
4. Main Page Template 7th Jan 2011 Farrukh Basit Done
5. User Signup/User Login 16th Jan 2011 Shaheen Done
Abdullah
6. Search 22th Jan 2011 Farrukh Basit Done
7. Forms Validation 18th Jan 2011 Arsalan Ahmed Done
8. Listing Pages 20th Jan 2011 Farrukh Basit Done
9. Programming 20th Jan 2011 Farrukh Basit Done
10. Database on SQL 08th Jan 2011 Arsalan Ahmed, Done
Server 2005 Shaheen
Abdullah
11. Documentation 24th Jan 2011 Shaheen Done
Abdullah, Usama
Umair
Batch Code: CF-20101 C
10
Karnel Travels Company 2011
7. GUI STANDARD DOCUMENT
We use 1024x768 Pixels.
We use Karnel Travel Company banner.
We use Table and Div in the project.
We use main table is center.
We use Source Code
7.1 Header
7.2 Footer
Batch Code: CF-20101 C
11
Karnel Travels Company 2011
8. INTERFACE DESIGN DOCUMENT
8.1 Home Page
This is the homepage of the website of the company. It guides the user/customer
to his/her desired information. Customers can login from this screen using their
registered Login ID and Password as show on top right corner. Navigation tabs are
made namely Home, About Us, Hotels etc, which provides detailed information
regarding that particular service. On the left hand, a search screen is provided for
the ease of the customers to search service according to their requirements.
Batch Code: CF-20101 C
12
Karnel Travels Company 2011
8.2 Customer Registration
This screen is made for the purpose of registration of customers. Customer
intending to be registered will input some information required by the company
and accordingly he will be registered and an email will be sent to him for
confirming his registration.
Batch Code: CF-20101 C
13
Karnel Travels Company 2011
8.3 Hotel Service Detail
This is the screen showing the Hotels service detailed information. When
navigated to Hotel from Home page, this screen appears which shows the list of
hotels of the company and their booking rates and also a button is shown namely
“Book now” which is used to book the desired hotel.
Batch Code: CF-20101 C
14
Karnel Travels Company 2011
8.4 Booking
When the customer navigates to “Hotels” and click “Book Now”, this screen
appears which ask for some information of the customer and accordingly books
his desired hotel. If the customer is not registered, he can only check the cost and
cannot book the hotel using this screen.
Batch Code: CF-20101 C
15
Karnel Travels Company 2011
9. ADMIN PANEL
9.1 Dashboard
This is the Dashboard area of the website administration area. Where you can
view latest bookings, total summary of different categories, and also can see
latest travel places and services.
Batch Code: CF-20101 C
16
Karnel Travels Company 2011
9.2 Customers
Here you can add new customer, and view old customers data, in order to give
customer support if they needed.
Batch Code: CF-20101 C
17
Karnel Travels Company 2011
9.3 Booking
Here you can add new bookings and see recent and old bookings.
Batch Code: CF-20101 C
18
Karnel Travels Company 2011
9.4 Travel Place
Here you can add new travel locations and also you can see recent and older
locations.
Batch Code: CF-20101 C
19
Karnel Travels Company 2011
9.5 Travel Service
Here you can add new travel services and also you can see recent and older
services.
Batch Code: CF-20101 C
20
Karnel Travels Company 2011
10. E-R DIAGRAM
An entity-relationship diagram is an abstract and conceptual representation of
data. Entity-relationship is a database modeling method, used to produce a type
Batch Code: CF-20101 C
21
Karnel Travels Company 2011
of conceptual schema or semantic data model of a system. Diagrams created by
this process are called entity-relationship diagrams, ER diagrams, or ERDs.
Batch Code: CF-20101 C
22
Karnel Travels Company 2011
11. Final Checklist
We will be delivering the following as part of our final submission.
Testing & quality plan
Check list of validations
S# LIST OF OPTION TO BE CHECKED VALIDATION STATUS
1. Fields in form should not be null. Yes
2. All numeric Field have a default value of 0. Yes
3. Hyperlink has tool tips texts. Yes
4. Home page has only forward link. Yes
5. All Pages have some either Forward Link or Yes
to Home.
6. The Site name for Publishing is Unique. Yes
7. Customer Area. Yes
8. Button is Working is properly. Yes
9. Searching and Booking is Perfect Yes
Batch Code: CF-20101 C
23