Question: how to solve 6.2 E 6.2E Given the following assumptions: a flight has a unique flight number, a passenger has a unique name, a pilot

how to solve 6.2E
6.2E Given the following assumptions: a flight has a unique flight number, a passenger has a unique name, a pilot has a unique name; a flight is always handled by one airline; a flight can have multiple passengers, a passenger can be on multiple flights; a flight has one pilot, a pilot can operate multiple flights: a flight is always handled by exactly one airplane; normalize the following relation: Flight (Flightnumber, Flighttime, airline (airlinename), passenger (passengername, gender, date of birth), pilot (pilotname, gender, date of birth), departure_city, arrival_city, airplane (planet.type, seats)) 6.3E Given the following EER model for an electricity market
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
