Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This is part of an SQL assignment about an airline reservation system. I need help creating a completed sql statement for the information in part
This is part of an SQL assignment about an airline reservation system. I need help creating a completed sql statement for the information in part 3.
I need someone to help put it together to complete it and thank you...
(Part 1) How would l Do a COMPLETE/CORRECT ER Model (SLQ) Mapping to relational Database on this? SQL statements for Entities and Relationships Creation 1. Make sure the data type and data size are appropriate for each attribute. For example, data type TINYINT is better than INT for the attribute age. Do not forget to include a suitable Primary Key and/or Foreign Key in your definition of each table. SLQ for loading data for each relation 2. Make sure to include one sample record from each table here and you need SLQ statements for 10 business functions. Each flight has a limited number of available seats Online Airline Reservation System The main objective of the online system is to create a convenient and easy-to-use online system for passengers trying to buy airline tickets. The system is based on a relational database with its flight management and reservation functions. There are number of flights that go from/to different cities at different dates and times. Users of the system should be able to retrieve flight information between two given cities with the given dates times of travel from the database. A route from city A to city B is sequence of connecting flights from A to B such that: a) there are at most two connecting stops, excluding the starting city and destination city of the trip, b) the connecting time is between one to two hours. Each flight has a limited number of available seats. The system will support two types of user privileges, Customer and Employees. Customer will have access to customer functions making a new reservation (one-way, round-trip multi-city, flexible data time, and confirmation), canceling an existing reservation, and viewing his/her itinerary. The employees will have access to both customers and flight management functions. The flight customers who have seats reserved on a given fight, 2) all flights for a given airport, 3) flight roster and schedule, 4) get all flights whose arrival and departure times are on time delayed, and 5) total sales for a given flight, and administrating flight information by 1) dding a flight, deleting a flight adding a new airport, updating fare for flights, adding a new flight leg ating departure arrival tintes for flight leg instances instance, andStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started