00:01
So, here in a question we have to translate the given er diagram into a rational scheme.
00:09
So, first let's talk about their entities and attributes.
00:17
So, first is report, report.
00:24
So, here report code, primary key, name.
00:30
The second is departure airport.
00:36
Now, here leg and then airport.
00:40
Third is arrival airport, then leg, airport.
00:50
Fourth is flight leg.
00:55
So, here is leg, primary key.
00:59
Here schedule departure time.
01:02
Here schedule arrival time.
01:04
Now, the fifth one is airplane type.
01:10
So, here type, name, max seats.
01:18
Sixth is airline company.
01:21
So, instance of primary key, arr time, weekdays.
01:29
Seventh is flight.
01:32
So, here flight number, primary key, departure airport, foreign key, arrival airport, foreign key, schedule departure time and schedule arrival time.
01:50
Now, the eighth is airplane...