Given the following assumptions:

• Each book has a unique ISBN number;
• Each author has a unique name;
• Each publisher has a unique name;
• A book can have multiple authors;
• An author can write more than one book;
• A publisher can publish more than one book;
• A book has only one publisher;
• A publisher has only one address.

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(planeID, type, seats))