Happy Travel (HAT) A Case Study Case Narration Section 1. Happy Travel (HAT) is a web-based company that has decided to expand its business by providing its registered customers a one-stop shop flight information system to any destination in the world. The database will assist the customer in planning his/her trip in advance as every registered airline with Happy Travel sends its entire fleet’s flight information which will then be posted on the website. This information is updated regularly to ensure the accuracy of the information. 2. However, the company is also accepting transactions over the counter to serve customers who do not have access to the Internet. They can fill-up forms that can be fed to company database at the end of the day. These forms contain passengers’ data and information for the flight they wish to avail. 3. On any given day, several airlines have flights to the same destination. On these flights, information about the plane such as the plane model, seating capacity and amenities on board are provided. 4. Information for each flight includes the flight schedule; the customer can view in advance the departure and arrival time of the flight, where the flight originated from and its destination. 5. The customer can also check whether the flight is fully booked by looking at the seat availability of the chosen flight. The seats are classified into 2 classes, namely first and economy class. The number of seats per class differs on every plane. The seat price is determined by the seat class it belongs to, the first class costs more than the economy class. The airline companies has agreed to make the prices uniform so whichever airline the customer chooses, the price is the same. The customer flying first class gets to board from the lounge section of the boarding area, whereas the customer flying on economy class will board through the normal check-in desk.   Query Description Section – (HAT Information Management Requirements) QD-Sec1. Route and Destination of a flight QD-Sec2. First Class Seat/s available in a particular flight QD-Sec3. Flights scheduled on a given date QD-Sec4. Flights going to a given destination QD-Sec5. Price of a given flight QD-Sec6. Plane to use for a given flight QD-Sec7. Planes that will fly on a given schedule/s. QD-Sec8. Arrival time of certain type of planes. QD-Sec9. Departure time of a flight in a particular destination. QD-Sec10. Number of seats available for a particular flight. QD-Sec11. List of Passengers boarding to lounge section. QD-Sec12. List of Passengers who make first class seats reservations. QD-Sec13. Seating plan of a given flight. TASKS: 1. List all the derived final well-structured relations.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

Happy Travel (HAT)
A Case Study

Case Narration Section

1. Happy Travel (HAT) is a web-based company that has decided to expand its business by providing its registered customers a one-stop shop flight information system to any destination in the world. The database will assist the customer in planning his/her trip in advance as every registered airline with Happy Travel sends its entire fleet’s flight information which will then be posted on the website. This information is updated regularly to ensure the accuracy of the information.

2. However, the company is also accepting transactions over the counter to serve customers who do not have access to the Internet. They can fill-up forms that can be fed to company database at the end of the day. These forms contain passengers’ data and information for the flight they wish to avail.

3. On any given day, several airlines have flights to the same destination. On these flights, information about the plane such as the plane model, seating capacity and amenities on board are provided.

4. Information for each flight includes the flight schedule; the customer can view in advance the departure and arrival time of the flight, where the flight originated from and its destination.

5. The customer can also check whether the flight is fully booked by looking at the seat availability of the chosen flight. The seats are classified into 2 classes, namely first and economy class. The number of seats per class differs on every plane. The seat price is determined by the seat class it belongs to, the first class costs more than the economy class. The airline companies has agreed to make the prices uniform so whichever airline the customer chooses, the price is the same. The customer flying first class gets to board from the lounge section of the boarding area, whereas the customer flying on economy class will board through the normal check-in desk.

 

Query Description Section – (HAT Information Management Requirements)

QD-Sec1. Route and Destination of a flight
QD-Sec2. First Class Seat/s available in a particular flight
QD-Sec3. Flights scheduled on a given date
QD-Sec4. Flights going to a given destination
QD-Sec5. Price of a given flight
QD-Sec6. Plane to use for a given flight
QD-Sec7. Planes that will fly on a given schedule/s.
QD-Sec8. Arrival time of certain type of planes.
QD-Sec9. Departure time of a flight in a particular destination.
QD-Sec10. Number of seats available for a particular flight.
QD-Sec11. List of Passengers boarding to lounge section.
QD-Sec12. List of Passengers who make first class seats reservations.
QD-Sec13. Seating plan of a given flight.

TASKS:

1. List all the derived final well-structured relations.


2. Write the SQL query using the final well-structured relations to generate the information requirements in the Query Description Section.

 

Associated Link:

Please refer to this previous question thread for the needed detaiis, which are found in the answer section.

https://www.bartleby.com/questions-and-answers/computer-science-question/e23246ef-765e-4144-ad98-8673b500fb1c

 

 

 

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY