Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
This is Database Project Report
Typology: Assignments
1 / 30
This page cannot be seen from the preview
Don't miss anything!
Department of Computer Science and Engineering (CSE) Bangladesh University of Business and Technology (BUBT) Mirpur-2, Dhaka-1216, Bangladesh.
Tourism Management system have been integral part of an individual’s life, whether a person is wealthy, affluent, well educated, disadvantaged and poverty stricken or belong to socio-economically backward section of the society. People engaged into travel and tourism for a variety of purpose such as religious, cultural, sports, education, employment, medical, seeing wildlife, adventure, ecotourism, business and so forth. "Tourism Management System” is web application to tourism management. This system wake to provide service facility to tourism management company and also to the customer. Tourism has turned out to be an economic booster contributing to the economic development of many countries over the last few decades. People see holidays as a necessity, and not as luxury in the present scenario. Tourism calls for coordination and cooperation between travel agents, tour operators, and tourists. Tourism has a few major elements − destinations, attractions, sites, accommodation, and all ancillary services. The main focus of this system is to help the user to easily tour booking and manage booking together with generating of tickets for travel or vacation purposes. This project has been developed to carry out the processes easily and quickly, which is not possible with the manuals systems, which are overcome by this software.
Chapter 1 Introduction
Tour Management system is a dynamic website for tourism business. It is dynamic and responsive web design. It is also called travel technology solution for agencies & tour operation. Nearly Everyone goes on a vacation for this ‘a Tourism management system’ would play a vital role in planning the perfect trip. The tourism management system allows the user of the system access all the details such as location, events, etc. The main purpose is to help tourism companies to manage customer and hotels etc. The system can also be used for both professional and business trips. The proposed system maintains centralized repository to make necessary travel arrangements and to retrieve information easily. Tourists are more attractive for cultural diversity of the world. Bangladesh is one of the most beautiful country in the south Asia. Rangamati, Cox’s Bazar, Saint-Martin, Sundarbans, Sylhet, Moulvibazar are the famous tourist place in Bangladesh as well as in Malaysia, Singapore, Bangkok, Maldives, Nepal, India have attractive tourist places.
Figure 1 :Tourism Management System
Tourism industry is related with maximizing the experience of tourists, travel management and tour operations. With the increase in people travelling for different purposes from across the world to our country, the need of expert services in this domain is witnessing an upsurge. Thus, the scope of tourism management in India is on a rise and is expected to facilitate high career prospects. With the right set of knowledge and skills, one can gauge the immense opportunities to establish a successful career in this industry. Professional tourism education endows students with the fundamental knowledge of different aspects, tools and techniques through which they can acquire essential expertise and skills required to serve customers in this domain. On completion of the education program, one becomes capable to access various job opportunities available in this domain. Various job profiles include tour operator, travel manager, holiday consultant, event manager, etc. in cruises, airlines, hotels, tourism departments and more.
The Tourism Management System is a web based application and maintains a centralized repository of all related information. The Objective of this project is to develop a system that automates the process and activities a travel agency and customer details. The purpose is to design a system using which one can perform all operations related to travelling and sightseeing.
We need a strong Database whereas data will be store of everyone. Chapter 2 Requirement Specifications
The Tourism Management System is a web based application. The main purpose of “TourismManagement System” is to provide a convenient and easy way for a customer to book hotels, flight, train and bus for tour purposes. To run this System, Software and Hardware Requirements are necessary. Requirements which are needed are given below briefly. Hardware Requirements: Processor – At least 2.0 GHZ RAM – At least 2GB Software Requirements: Operating System – Windows. Runtime Environment – Net Framework 4. Frond End – PHP, HTML, CSS, JavaScript, BOOTSTRAP. Back End – MySQL Editor Tools – Atom, Notepad ++,Sublime Text 3 Other Graphics Tools – Adobe Photoshop. Web Browser – Google Chrome, Firefox, or any compatible update browser.
There are two kinds of languages have used in “Tour Management System”. One is Programming Language and other is Database
Language. Front End, I have used PHP, JavaScript, HTML, CSS & Back End, I have used MySQL Database Language in my “Tourism Management System” Programming Language & Markup Language: PHP, JavaScript, HTML Color Script Language: CSS Database Language: MySQL Statements transaction
JavaScript: This language helps to make dynamic Website. I have used JavaScript at home page for “Slideshow & Time”. PHP: This language helps to develop logical function in Website. I have used PHP in different section for creating function such as “Database Connection”, “Admin/User Login Validation”, “Data Insert, Update, Retrieve and Delete”. HTML: This is markup script Language for creating web page. I have used it different section in my “Tour Management System” Such as for making “Header & Footer” in home page. Inbound and Outbound Title’s information. CSS: Cascading Style Sheet is a Style sheet language that mostly used to design website. I have used this style sheet language in different section at my project. Such as “Admin Panel” Design, Home Page “Top Navigation Drop Down Bar” design.
Manage Pages Change Password Admin Dashboard Guest users can: Visit the Website Guest user can inquire 3.2 Data Flow Diagram: Figure 2 :Data Flow Diagram
admin (CREATE TABLE admin (id int(11) NOT NULL, UserName varchar(100) DEFAULT NULL, Password varchar(100) DEFAULT NULL, updationDate timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE tblbooking ( BookingId int(11) NOT NULL, PackageId int(11) DEFAULT NULL, UserEmail varchar(100) DEFAULT NULL, FromDate varchar(100) DEFAULT NULL,
ToDate varchar(100) DEFAULT NULL, Comment mediumtext DEFAULT NULL, RegDate timestamp NULL DEFAULT current_timestamp(), status int(11) DEFAULT NULL, CancelledBy varchar(5) DEFAULT NULL, UpdationDate timestamp NULL DEFAULT NULL ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE tblenquiry ( id int(11) NOT NULL, FullName varchar(100) DEFAULT NULL, EmailId varchar(100) DEFAULT NULL, MobileNumber char(10) DEFAULT NULL, Subject varchar(100) DEFAULT NULL,
CREATE TABLE tblpages ( id int(11) NOT NULL, type varchar(255) DEFAULT '', detail longtext DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE tbltourpackages ( PackageId int(11) NOT NULL,
PackageName varchar(200) DEFAULT NULL, PackageType varchar(150) DEFAULT NULL, PackageLocation varchar(100) DEFAULT NULL, PackagePrice int(11) DEFAULT NULL, PackageFetures varchar(255) DEFAULT NULL, PackageDetails mediumtext DEFAULT NULL, PackageImage varchar(100) DEFAULT NULL, Creationdate timestamp NULL DEFAULT current_timestamp(), UpdationDate timestamp NULL DEFAULT NULL ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin
Chapter 4 TESTING
There are some Screen Shoot Interface of my “Tourism Management System’s” are given below. Home Figure 5 :Home Page
Admin Login Figure 6 :Admin Login Page