Table 4-8 shows extracts from a customer’s flight booking confirmation. The booking

Table 4-8 shows extracts from a customer’s flight booking confirmation. The booking is identified by the booking reference, which in turn identifies the customer id, their flight origin, and final destination. This booking reference also states the number of air miles eligible, which can also be calculated from the origin and destination.

a. Develop a diagram that shows the functional dependencies in the BOOKING relation.
b. Convert BOOKING to third normal form if necessary. Show the resulting table(s) with the sample data presented in BOOKING.