Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

image text in transcribed

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_id

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data And Databases

Authors: Jeff Mapua

1st Edition

1978502257, 978-1978502253

More Books

Students also viewed these Databases questions

Question

What is digital literacy? Why is it necessary?

Answered: 1 week ago