Database Systems for EasyTravel Group: Design, Implementation and Queries

Running head: DATABASE SYSTEMS
DATABASE SYSTEMS
Name of the Student
Name of the University
Author Note

DATABASE SYSTEMS
1
Table of Contents
Introduction......................................................................................................................................2
Software and Hardware Requirements............................................................................................2
Software requirements.................................................................................................................2
Hardware requirements................................................................................................................2
Database design...............................................................................................................................3
ER-Diagram.................................................................................................................................3
Business Rules.............................................................................................................................4
Database Implementation................................................................................................................4
All Tables.....................................................................................................................................5
Constraints...................................................................................................................................9
Insert Data....................................................................................................................................9
Queries...........................................................................................................................................14
Conclusion and Recommendation.................................................................................................18
References......................................................................................................................................20

DATABASE SYSTEMS
2
Introduction
EasyTravel Group is one of UK’s largest travel platforms. The main goal of this project is to
design and develop a booking system to enhance the business process of the company. The
approach to develop the booking system for the EasyTravel Company is based on the relational
database management system (Laudon and Laudon 2015). This report discuses, the technical
requirements, database implementation, business reports, recommendations etc. The report also
shows the user documentation to explain the implementations.
Software and Hardware Requirements
Software requirements
After analyzing the business process for the travel company EasyTravel, the development is done
with the Relational database management system. The software selected form the database
system is MySQL (DuBois 2014). The software requirements for the project is given below:
i. Xampp: It provides the SQL database software to implement and develop database
system including, apache server (West and Prettyman 2018). The version of the used
software is 3.2.4
ii. MySQL Workbench: It is a MySQL developer tool which provides the modelling,
reverse engineering, forward engineering etc. for a database administrator. The Entity
Relationship diagram is developed using the Workbench software.
Hardware requirements
The hardware requirements to run the above mentioned software and implement database are
given below:

DATABASE SYSTEMS
3
i. Windows 7 64 bit
ii. Storage: 10 GB (min)
iii. Web Browser
iv. Ram: 2 GB
Database design
ER-Diagram
Entity relationship diagram represents the Real-world objects as entities and relationship
between them. The data category are called attributes (Elmasri and Navathe 2017). An attribute
can be non-key or key attribute. Key attributes identifies each tuple uniquely in a Database
management system. Below the Entity relationship diagram represents the business process of
the EasyTravel Company.