Question: Table 4- 8 shows extracts from a customers flight booking confirmation. The booking is identified by the booking reference, which in turn identifies the customer

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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Database Management Systems Questions!

Table 4-8 shows extracts from a customers flight booking confirmation. The booking is identified by the booking reference, which in turn identifies the customer id, their flight origin, and final...

I am confusing filling out the 6 tables! please help me to fill them out and also the excel calculation process! ACCY 303 Group Project: Constructive Capitalization of Operating Leases The purpose of...

Please help me with the code in Java. Thanks Project 1: Aloha Airlines Flights, Part 1 1 Task Aloha Airlines wants a proof of concept for a flight booking system; implement supplier code for them....

please just draw UML class diagram and all the object diagram. This is java assignment. i am got little confusing about the diagram. Please don't code. Project 1: Aloha Airlines Flights, Part 1 1...

CUSTOMER EMAIL CUSTOMER FAX CUSTOMER PHONE CUSTOMER ID CUSTOMER ID CUSTOMER FAX COUNTRY CODE CUSTOMER FAX AREA CODE CUSTOMER FAX NUMBER CUSTOMER ID CUSTOMER PHONE COUNTRY CODE CUSTOMER PHONE AREA...

Questions: Assume a period of time has passed. Can you Assess your communication/education plan. Has the plan been implemented as specified? Have the objectives of the plan been achieved? How have...

Please answer all the questions above in system analysis and design SECTION A (45 MARKS) There are THREE (3) questions in this section. Answer ALL Questions in the Answer Booklet. 1. A group of...

Airline Company Case Study This document describes the data requirements for a fictional airline company, Anchor Air. In this case study, the company's key information requirements are identified....

Assuming Virgin Mobile's target segment (14-24-year-olds), how should it structure its pricing? Which of the suggested options would you recommend? In proposing your pricing plan, please be as...

How does the accounting for pension expenditures in a governmental fund differ from the accounting for pension expenses at the government-wide level? Why?

The textbook recommends that you save money every month. Even if only $__ a month. $20 10% $100 $1

Phoenix Plastic Inc. has accumulated the following data over a six-month period: Separate the machine-related costs into their fixed and variable components, using the high-lowmethod. Machine Hours...