Travel and Tourism Management System:
The purpose of this project is to provide the complete information about the vehicles available for a tour. There are
2 different types of users. First the customer visits the site and enters the place from where to where he wishes to
travel. He also provides the date as when he would like to travel. Then he sends these details to the travel and
tourism agency. On the day of the tour, the customer first must show the confirmation message to the driver for
clarity and only then he will agree to drive after looking at the confirmation message. This software is user friendly
and helps in finding the vehicle sooner rather than wandering manually everywhere to find for vehicles. Before the
tour starts, half payment has to be done. After the customer returns or reaches his final destination, he must pay full
amount either through cash or through cards. After the travelling the customer can come back to the site and enter
his feedback about the travel and tourism agency. If any good feedback will be taken positively and if any negative
feedback too will be taken positively and try to improve what had lacked. The report is also generated periodically
and the database will be cleared according to the time span for faster performance. Travel and Tourism sample code is available in the below link directed. If you would like to purchase the exact
code,, mail us. A quotation will be sent. A complete support will be provided by our team to you after the purchase. Admin:
admin can manage the user and receive package from traveler & package management.
Traveler:
Traveler create the package and give to admin.
Customer:
customer can view package and booking.
Visitor:
Visitor view side and give feedback. Hardware & Software Specification Hardware Specification : Processor 2.0 GHZ RAM 2 GB Hard Disk 30 GB free space System flowchart E-R Diagram UML Diagram
Use case Diagram Activity Diagram Class Diagram Sequence Diagram Data Dictionary
1. Table Name: Login_mst
Description: To store the admin, customer, Traveler Login Details
Primary Key: User Name Sr. Name DataType Constraint Description Primary Key To store the no
1 Username Varchar(10) username
2 User_Type Varchar(10) Not null To store user type
like admin,
customer,traveler
etc. 3 Password nvarchar(10) Not null To store the
password 2. Table Name: AgeRegistration_mst
Description: To store Agent Personal Information.
Primary Key: Company_name Sr. Field Name Data Type Constraint Description no
1 Name Varchar(50) Not null To store the Name of
agent. 2 Company_Name Varchar(50) Primary Key To store Company Name. 3 Address Varchar(50) Not null To store address. 4 City Varchar(50) Not null To store city. 5 Zip_code Numeric(18,0) Not null To store Agent zip code. 6 Country Varchar(50) Not null To store country. 7 Mobile no Numeric(18,0) Not null To store mobile number. 8 Email_id Nvarchar(30) Not null To store the Email id. 9 Comment Varchar(50) Not null To store Comment. 3. Table Name: AgePackage_Management Description: To store Agent
Package Detail.
Primary Key: Tour_id Sr . Field Name Data Type Constraint Description 1 Agent_Name Varchar(50) Not Null To Store Agent Name. 2 Agent_mobile Numeric(18,0) Not Null To Store Mobile no number.
3 Company_Name Varchar(50) Not Null To Store company
Name. 4 Tour_id Numeric(18,0) Primary To Store Tour id. Key
5 Package_type Varchar(50) Not null To store Package type
like royal, Holiday. Sr . Field Name Data Type Constraint Description 6 Category Varchar(50) Not null To store tour Catrgory. 7 Tour_place Varchar(50) Not null To store the tour place. 8 Days Numeric(18,0) Not null To store tour days. 9 Amount Numeric(18,0) Not null To store tour amount. No 4. Table Name: Booking_mst
Description: it can store Booking Detail.
Primary Key: Booking_id Sr . Field Name Data Type Constraint Description 1 Booking_id Integer Primary Key To Store Booking id 2 Traveler_ name Varchar (50) Not null To store Booking
traveler name 3 Package_id Integer Not null To Store Package id 4 Package_name Varchar(20) Not null To store package
name. 5 Create Date Date Time Not null Create date of record. 6 Update Date Date Time Not null Update date of record. 5. Table Name: category_master
Description: To store travels category Detail.
Primary Key: c_id Sr . Field Name Data Type Constraint Description 1 C_id Integer Primary key To store category id. 2 Package_type Varchar(10) Not null To store the package no type. Like holiday
3 category Varchar(20) Not null To store category like
royal, delux etc. 6. Table Name: country_master Description: To store
country Detail.
Primary Key: country_id Sr . Field Name Data Type Constraint Description 1 Country_id Integer Primary Key To store the country id. 2 country Varchar(10) Not null To store the country name. no Table Name: AdmPackage_management
description: it store the Package Detail Like type, days, amount etc.
Primary Key: id
Sr.no Field Name 1 Id 2 Package Type Data Type constraint Description Numeric(18,0) Primary Key To store Package id. Varchar(30) Not null To store Package Type like
Holiday, Royal etc. 3 Category Varchar(15) Not null To store Package Category
like Group tour, adventure
tour etc. 4 Tour_Place Varchar(15) Not null To store Tour Place name. 5 Days Nchar (10) Not null To store tour package
Days. 6 Amount Varchar(20) Not null To store Amount of Tour
Packages. 8.Table Name: Feedback
Description: to store the feedback details. Sr. Field Name Data Type Constraint Description 1 Name Integer Not null To store name. 2 Emailid Varchar(30) Not null To store email id. 3 Contact_no Numeric(10) Not null To store contact no. 4 Feedback Varchar(30) Not null To store feedback status. No Tables create Booking_mst
(
Booking_id int,
Primary Key(Booking_id ),
Traveler_ name Varchar (50) not null,
Package_id int Not null,
Package_name Varchar (50) not null,
Create Date Date , Update Date Date
);
create AgePackage_Management
(
Tour_id int,
(Primary Key(Tour_id),
Agent_Name Varchar(50) Not Null, Agent_mobile int Not Null, Company_Name Varchar(50) Not Null,
Package_type Varchar(50) Not null,
Category Varchar(50) Not null, Tour_place Varchar(50) Not null,
Days int Not null,
Amount int Not null
);
create AgeRegistration_mst
(Primary Key:(Company_name),
Name Varchar(50) Not null, Company_Name Varchar(50),
Address Varchar(50) Not null,
City Varchar(50) Not null, Zip_code int Not null, Country Varchar(50) Not null, Mobile no int Not null,
Email_id Nvarchar(30) Not null, Comment Varchar(50) Not null )
Create Login_mst
(
Primary Key:(UserName),
Username
Varchar(10) Primary Key,
User_Type
Varchar(10) Not null,
Password
varchar(10) Not null )
CREATE TABLE AdmPackage_management
(
ID int NOT NULL auto_increment,
packagetype varchar(30) NOT NULL,
tourtype varchar(15),
tourplace varchar(15),
days varchar(15),
Amount varchar(15),
PRIMARY KEY (id)
); CREATE TABLE Feedback (
name int NOT NULL,
emailed varchar(20) NOT NULL,
feedback varchar(20) DEFAULT 0 NOT NULL,
contactnumber varchar(20),
PRIMARY KEY (StudentID, AssignmentID)
