اين الخطا في Er , Mapping

http://www.tntup.com/file.php?file=74abd07...62c474ffc898ee7


ارفقت لكم الملف به ER,MAPPING واكتشفت ان هناك خطا في تمثيل flight connection وهذا السيناريو لها :

Each flight has a maximum number of seats depending on the aircraft used for this flight. For each stopover of a flight, the number of seats currently available must be known. Moreover, a price is associated with a flight connection. Flight connections as well as stopovers of flights must be connected (e.g. flying from A to B and then from C to E is not a flight connection, whereas flying from A to B and then from B to C is).
Moreover, temporal constraints must hold with respect to flight connections and with respect to stopovers of a flight in that the arrival time has to be at least 60 minutes before the departure time of the next stopover of the flight or flight connection. Customers typically request to go from city A to city B and want to find all connections that are available from city A to city B and their price.
The price of a flight is computed as follows:
• a price (in Saudi Riyal) is associated with each stopover of a flight;
• the price of a flight connection is computed by adding the prices of the stopovers of the flight connection;
• However, connections that involve 2 stopovers are discounted by 20%,
If a customer requests a reservation for a flight connection either all stopovers of that connection are reserved, or the request is rejected if there is at least one stopover for which no place is available. Moreover, a unique reservation number is associated with the successful reservation of a customer. A reservation can have one of three states: “Confirmed”, “Canceled”, “Waiting List”
[/size]