Please create random 5 passengers for this database assignment and please create a relationship diagram also. After finishing create a report showing what mentioned at the bottom. I have it at the end. Please help me with this. I will rate this.
Step 4 -Create a Report using MS-Word1. A Title page with Airline Database Project2. An Executive Summary describing the purpose of the database that you designed and how the airline would be able to benefit from using the database (half to one page).3. For each table in your database, write one paragraph where you briefly describe the table, its primary key, foreign key(s) (if any), and all other attributes. Also, briefly describe how each table is related to one or more other tables and the purpose served by having those relationships. (One paragraph for each table)4. Snapshot of the Data/Relationship Diagram created in MS-Access. Make sure that the referential integrity constraint is shown for the related tables.5. Data for each table from your Access database.6. Four queries to retrieve data needed for the questions/reports that you created as part of completing Step 3. Include three things for each query:The question you want to be answered (specific to the data in your database tables).The snapshot of the design view of the query that answers the question.The snapshot of the result that you see (datasheet view) when you run the query.
What you will do Create a database to support the flight reservation system of a small airline Enter some meaningful data in the database Design queries to answer questions and create documents / reports Prepare a report for the project . Goals Simulate the process of gathering requirements for the database Apply the database design principles learned in the class Practice the query design skills learned in the class 2 Step 1 Review the assumptions Review the questions to be answered, documents / reports to be created using the database Create a list of required attributes Distribute the attributes among multiple tables Identify the Primary and Foreign Keys Create the design on paper . . To keep things simple, make the following assumptions: We are a small domestic only airline that operates only a few different flights on each day. Each flight operates only once every day - one fixed boarding time for each flight. Each flight can have two types of seats/class - Business and Economy. Each aircraft used for a flight has a fixed number of business and economy class seats. There is a fixed price for both a business and an economy class seat on each flight for any date. Reservations can be made in advance. A reservation can be made for multiple passengers. Each reservation is for a specific one-way flight only. All seats on one reservation are of the same class - either all business class or all economy class. . Questions / Documents / Reports List of passengers on a specific flight on a specific date Number of seats booked and remaining on a specific flight on a specific date in a specific class (B or E) A boarding pass (Passenger_Name, , Flight_Date, Boarding_Time, Flight_No, Starting_City, Dest_City, Class, Seat_No) for a specific passenger on a specific flight on a specific date A confirmation with flight and payment details (Date of Reservation, Flight Number, Flight Date, Start and Destination Cities, Number of Passengers, Class, Total Dollar Amount Paid) for a customer making a specific reservation 6 Boarding Pass . . Flight_No Seat_No Starting_City Dest_City Boarding_Time Class Flight_Date Passenger_Name . Design on Paper Data/Relationship Diagram Flights Flight_No (PK) Departure_City Arrival_City Business_Capacity Economy_Capacity Business_Price Economy_Price Boarding Time Customers Customer_ID (PK) Customer_FName Customer_LName Street City State Zip_Code Phone_Number Credit_Card_4Digits Passenger_Reservations Reservations Reservation_ID (PK) Reservation_Date Customer_ID (FK) Flight_No (FK) Flight_Date Seat_Class No Passengers Passengers Passenger_ID (PK) Pass_FName Pass_LName Pass_ID_No Pas_Res_No (PK) Reservation_ID (FK) Passenger_ID (FK) Seat_No Step 2 Create the tables in MS-Access Create the relationship Diagram Enter data for 5 Flights and 5 Customers Enter data for 5 Reservations Step 3 Make the necessary changes in the the four questions provided on Slide #6, based upon the specific data in your database Design the queries to answer those questions in Access O What you will do Create a database to support the flight reservation system of a small airline Enter some meaningful data in the database Design queries to answer questions and create documents / reports Prepare a report for the project . Goals Simulate the process of gathering requirements for the database Apply the database design principles learned in the class Practice the query design skills learned in the class 2 Step 1 Review the assumptions Review the questions to be answered, documents / reports to be created using the database Create a list of required attributes Distribute the attributes among multiple tables Identify the Primary and Foreign Keys Create the design on paper . . To keep things simple, make the following assumptions: We are a small domestic only airline that operates only a few different flights on each day. Each flight operates only once every day - one fixed boarding time for each flight. Each flight can have two types of seats/class - Business and Economy. Each aircraft used for a flight has a fixed number of business and economy class seats. There is a fixed price for both a business and an economy class seat on each flight for any date. Reservations can be made in advance. A reservation can be made for multiple passengers. Each reservation is for a specific one-way flight only. All seats on one reservation are of the same class - either all business class or all economy class. . Questions / Documents / Reports List of passengers on a specific flight on a specific date Number of seats booked and remaining on a specific flight on a specific date in a specific class (B or E) A boarding pass (Passenger_Name, , Flight_Date, Boarding_Time, Flight_No, Starting_City, Dest_City, Class, Seat_No) for a specific passenger on a specific flight on a specific date A confirmation with flight and payment details (Date of Reservation, Flight Number, Flight Date, Start and Destination Cities, Number of Passengers, Class, Total Dollar Amount Paid) for a customer making a specific reservation 6 Boarding Pass . . Flight_No Seat_No Starting_City Dest_City Boarding_Time Class Flight_Date Passenger_Name . Design on Paper Data/Relationship Diagram Flights Flight_No (PK) Departure_City Arrival_City Business_Capacity Economy_Capacity Business_Price Economy_Price Boarding Time Customers Customer_ID (PK) Customer_FName Customer_LName Street City State Zip_Code Phone_Number Credit_Card_4Digits Passenger_Reservations Reservations Reservation_ID (PK) Reservation_Date Customer_ID (FK) Flight_No (FK) Flight_Date Seat_Class No Passengers Passengers Passenger_ID (PK) Pass_FName Pass_LName Pass_ID_No Pas_Res_No (PK) Reservation_ID (FK) Passenger_ID (FK) Seat_No Step 2 Create the tables in MS-Access Create the relationship Diagram Enter data for 5 Flights and 5 Customers Enter data for 5 Reservations Step 3 Make the necessary changes in the the four questions provided on Slide #6, based upon the specific data in your database Design the queries to answer those questions in Access O
