Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i want step 3 and 4 for this project, step 1 and 2 are provided. i have a deadline of 5 hours so please ill
i want step 3 and 4 for this project, step 1 and 2 are provided. i have a deadline of 5 hours so please ill upvote if u finish it
CSCI 335 Database Project (15%) Airline Company An airline company is interested in implementing a database system to manipulate the flights that it organizes. The airline company has a certain number of airplanes. Each airplane has a unique code, a number of seats and a production year. An airplane belongs to a certain airplane model. Each model has a unique model number and is provided by a certain company. We have different airplanes of each model. Each flight is identified by a flight number, a scheduled departure time and a scheduled arrival time. We want also to keep track of the airport from which the flight is scheduled as well as the destination airport. Each airport is identified by a unique code, its name and the country in which it is located. Journeys of each flight are organized on a daily basis. Each journey is identified by a date, its actual departure time, its actual arrival time, and the number of passengers, in addition to the airplane that performs the journey. We want to keep track of the seats occupied, where each seat is identified by a seat number, a passenger name, nationality, age and phone number. Step 1: Data Modeling - Create an ER diagram, Step 2: Map ER diagram into a relational model, Later: Step 3: Put the tables in the 3rd normal form, Step 4: Create your tables and fill them with few records of logical data, Unique id: Airline_id, Model_id, Flight_number, Airport_id, date, seat_no Dept_time: Departure Time Arr time: Arrival time Pass_name: Passenger Name Occ status: Occupied Status No. of Pass: Number of Passenger No.of_seats Company Airline id Production_year Model id Airline Has Model Name Airport_id Country Has Dept_time Airports Flight_Number Goes to Pass_name Seat_no Schedule 200 Nationality Destination Occ_Status Age Arr_time Tracks Seats Flights Dept_time Arr_time Date No.of_Pass Books Journey Relational Model: PK: Primary key FK: Foreign Key Airline PK Airine id No. Of Seats Production year Model PK Model_id Company FK Airline_id Flights PK Flight_number Dept_time Arr_time Destination Airport PK Airport_id Destination Name Country FK Flight_id Schedule FK Airline_id Journey PK Date Dept_time Arr_time No. of Passenger Schedule FK Flight_id Seats PK Seat_number Occ_status Pass_name Nationality Age phone_number FK Flight_idStep 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