ABSTRACT
This project ‘NRES Travel Agency’ is a real life project which can be put on the webserver either local or World Wide Web (www) in order to access it.
The project can be used as Intranet basis as well as Internet basis as per the requirement.
Since, PHP and MySQL is used as server-side technology, it can be run on IIS or Apache server. This same project can be run on Mac, Unix and Windows without any modification in the code.
The requirements for the project were Apache Server, MySQL, Dreamweaver, photoshop for the design purpose(static). We have used WAMP5 1.4.3 which comes with packed version of both Apache and MySQL Admin.
The time schedule was managed as per proposed earlier. We tried our best to submit the work on time. There are still some further enhancements which can’t be put forward in shortage of time for example, trekking packages, holiday packages and online ticketing without visiting the office.
CONTENTS
· Introduction
NRES Travel Ageny is the web based travel agency. This project ‘NRES Travel Agency’ is a real life project which can be put on the webserver either local or World Wide Web (www) in order to access it.
The application of this project is targeted to the Travel Agency which is the growing industry in the present context. This agency helps the clients for reservation of available hotels and airlines.
· Aims and objectives
The aim of this project is to build an interactive web site to replace file based database making it easier for its client and staff to find information required efficiently.
The aim of this project is making user friendly and informative website
This project is aimed to reach the following goals
User friendly interface for all users.
Clients can browse through different range of hotels availability, type rent ,number of rooms etc from anywhere
Owners can check their property status
Staff can communicate with client and private owner through medium like email.
· Database solution for this project
Getting instantly information about avaibility, type, rent and price of the property.
Providing the information quickly and efficiently.
· Purpose of this project
Change the old way of file based system with a new interactive web pages
Provides user quick and ready information.
User friendly.
- Advantages of this project
Interesting site: web side with very small size file which reduces the loading time.
Listing of information are easy to find.
User friendly.
Background
- Internet
Anyone with an access to the Internet can exchange text, data files, and programs with any other user and now a days most people use for their different needs like Studies, Research, shopping, emails jobs etc the jobs it does are endless.
- Database
A database is a collection of data that is organized so that its contents can easily be accessed, managed, and updated. data is information that has been translated into a form that is more convenient to move or process.
· Relational Database
In relational database all data is logically structured within relations(tables) .each relation has a name and is made up of named attribute (column)of data .each row contains one value per attribute. a great strength of the relational model is this simple logical structure.
- SQL
It is the language used to manipulate relational databases. . SQL is tied very closely with the relational model. In the relational model, data is stored in structures called relations or tables. SQL allows users to access data in relational database management systems, such as Access, Oracle, Sybase, Informix, Microsoft SQL Server, and others.
- PHP
PHP is a powerful server-side scripting language for creating dynamic and interactive websites. The PHP syntax is very similar to Perl and C. PHP is often used together with Apache (web server) on various operating systems. It also supports ISAPI and can be used with Microsoft's IIS on Windows. A PHP file may contain text, HTML tags and scripts. Scripts in a PHP file are executed on the server.
PHP stands for PHP: Hypertext Preprocessor
PHP is a server-side scripting language, like ASP
PHP scripts are executed on the server
PHP supports many databases ( MS ACCESS, MySQL, Informix, Oracle, Sybase, Solid, PostgreSQL, Generic ODBC, etc.)
PHP is an open source software (OSS)
PHP is free to download and use.
User manual
The website contains two parts:
1. Admin Section
2. Client Section
1.Admin Section
It has following steps:
Login Page:
Provide the Username and Password to login to access the admin control panel.
After login admin can manage all the contents of sites.
There are 10 links in the contents.
Home:
It will redirect the page to admin homepage.
Manage Flight:
Admin can add the flight name and description. The added information will be displayed above. It can be edited and delete if there is some mistakes to correct it. After insertion of flight name and description, admin can add details of the flight by clicking the “Add Details” link. After clicking this link the Add detail flight form for respective flight will be displayed. Admin can insert the details like source, destination, flight date, flight time, flight duration and price. It can be edited, deleted respectively.
Manage Hotel:
Admin can add the new hotel information like hotel category e.g., 1 star, 2 star etc, Hotel name and description. After adding information it can be edited, deleted respectively, if needed.
Mange Hotel Detail:
Firstly, Admin will ask to select hotel name to view the information of respective hotel. After selecting the hotel name, admin can add hotel detail like room selection (which was added in manage room section will come below), Number of adults and price of per day. Added information can be deleted, if needed.
Manage Room:
Here admin can manage all the type of rooms that will be available. Admin can add, edit and deleted the room information. The added room name will be displayed in Manage Hotel Detail link under room’s type.
Manage Client:
The admin can view all the registered clients detail from here.
Manage Hotel Booking:
Admin can view all the booking detail of the hotel from this link. Admin can see all the necessary information for booking like hotel name, room, no of adults, price, booked date and the detail information of client who booked it.
Manage Flight Detail:
Admin can view all the booking detail of the flight from this link. Admin can see all the necessary information like flight name, source, destination, date, time, duration, price, booked date and the detail information of client who booked it.
Manage Setting:
Admin can control his access information from here. Admin can change the password which is needed for security reason to protect from intruders.
Logout:
For security reason, admin need to logout from the control panel.
All these added information will be shown in client part. So admin need to be very precise about all the information added.
Client Section
Client will choose from what he/she needs under browse the category.
HOTEL BOOKING
For hotel booking, he will see all the hotel information available. He can choose the hotel and see all the necessary information of that hotel. He can book the hotel as per his requirements. To book hotel he needs to be registered client. If he is the registered client, he will login and confirm the booking if not he will need to be registered first.
Flight booking
For Flight booking, he will see all the flight information available. He can choose the flight airline name and see all the necessary information of that flight He can book the flight as per his requirements. To book flight he needs to be registered client. If he is the registered client, he will login and confirm the booking if not he will need to be registered first.
Register here
New user need to be registered. Registration form will be displayed to register from the link “Register here” in homepage.
After logging to the site, remember to log out for security reason from the right side.
There are lots of places where we can enhance more features later. It is made in that way that it can be scalable. It has flexibility to adjust the changes if required.
ER Diagram
Context Diagram
Fig: Context Diagram
DFD
Fig: Data Flow Diagram
Level one DFD
GANTT CHART
| Phase | Job Description | April | May | ||||
| 2ndWK | 3rd WK | 4thWK | 1stWK | 2nd WK | 3rdWK | ||
| A N A L Y S I S | Requirement Analysis | | | | | | |
| Functional Analysis | | Review | | | | | |
| Process Modeling | | | | | | | |
| D E S I G N | Interface Design | | | Review | | | |
| Menu Navigation | | | | | | | |
| Internal Design | | | | | | | |
| IM PL EM EN TA TI ON | Documentation | | | | | | Review |
| Presentation | | | | | | Review | |
| | |||||||
Conclusion
This project gives a new looking website to replace file based system. NRES Travel Agency is perfectly suited to travel and tours who are using file based system. Totally new concept for admin and client and private user it will make easier for everyone involved with this Agency.
Recommendation for further work Further works can be done on the website like including tour package, holiday package ,making some interactive pages where client can register directly etc.
Reference
Books
1 database systems by Thomas Connolly
2 information technology project management
3 mysql/php database application
Internet
www.hotscript.com
www.google.com
No comments:
Post a Comment