Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. advance math
  3. consider the following relation airline table

Consider the following relation AIRLINE TABLE Flight Date Flight ID Origin Destination Captain ID Captain Name Number of Passengers on the Flight April 10 111 Chicago L.A. 111 Tracy 110 April 10 222 L.A. Phoenix 222 Matt 105 April 12 111 Chicago L.A. 444 Tim 98 April 12 333 L.A. N.Y. 111 Tracy 75 April 12 444 L.A. N.Y. 333 Pat 110 April...

50.1K

Verified Solution

Question

Advance Math

Consider the following relation

AIRLINE TABLE

Flight

Date

Flight

ID

Origin

Destination

Captain

ID

Captain

Name

Number of Passengers on the Flight

April 10

111

Chicago

L.A.

111

Tracy

110

April 10

222

L.A.

Phoenix

222

Matt

105

April 12

111

Chicago

L.A.

444

Tim

98

April 12

333

L.A.

N.Y.

111

Tracy

75

April 12

444

L.A.

N.Y.

333

Pat

110

April 12

555

L.A.

Dallas

444

Tim

111

April 12

222

L.A.

Phoenix

555

Pat

107

Some of the requirements that this table is based on are asfollows:

  1. The AIRLINE is flying number of flights on various routesdaily.
  2. A flight with a particular Flight Id alwaysflies on the same route (same Origin and sameDestination).
  3. Every captain has a unique Captain Id, and anon-unique Captain Name.
  4. For each instance of a flight (a particular flight on aparticular Flight Date) we keep track of who wasthe captain of that instance of a flight and how many passengerswere on board (Number of Passengers on theFlight).
  5. A captain can fly multiple flights during the same day.

Normalize the relation to the second normal form (2NF).

Normalize the relation to the third normal form (3NF).

Answer & Explanation Solved by verified expert
3.9 Ratings (381 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

The results of a blinded study assessing the use of plasma D-dimer levels for diagnosing deep...

Advance Math
Q

All of the following are functions of the mammalian kidney. Check all that would applywater...

Biology
Q

When Beethoven wrote his Symphony No. 9, "Ode to Joy," A. he was almost completely...

Biology
Q

Past studies have indicated that the percentage of smokers was estimated to be about 34...

Statistics
Q

Required: Determine the missing amounts in each of the following four independent scenarios: a. X...

Accounting
Q

Case 13-08 Accounting for a Loss Contingency for a Verdict Overturned on Appeal In the...

Accounting
Q

Milano Pizza has a small area for in-store dining as well as offers take-out and...

Accounting
Q

please make it easy to understand 2:19. Project Lima Beet liikine - 13,000...

Accounting
Q

During Heaton Company

Accounting
Q

Journalize the transactions and the closing entries for net income and dividends. (Credit account titles...

Accounting
Q

1)Consider a loan for $35,301 that is paid off in 15 yearly payments of $3,000....

Finance
Q

Byron Books Inc. recently reported $12 million of net income. Its EBIT was $20.4 million,...

Finance