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.

Transcribed Image Text:

TABLE 4-8 Booking Reference Date B03343 01/12/2018 Customer Email john@flightdets.com From SIN Place of Embarkation To Singapore MLE Place of Disembarkation Male Eligible Air Miles 2111