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: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Basic Math
1.2K views

Approximate the area under the graph of​ f(x) and above the​ x-axis with​ rectangles, using the...

Basic Math
1.2K views

Suppose babies born after a gestation period of 32 to 35 weeks have a mean weight...

Biology
1.2K views

E decoding 5 Tropomyosin isoforms are mainly produced by A exon skipping B DNA rearrangement...

Basic Math
1.2K views

une 2017 Central High School had five members on their swim team in 2010 Over...

Basic Math
1.2K views

Investing today and looking forward a few years from now your portfolio s returns would...

Statistics
1.2K views

is studying the sell image okers as me Dy psychologist the self image SI score...

Accounting
1.2K views

Identify any 5 major external forces that give rise to opportunities and threats for a...

Accounting
1.2K views

1: 13 . 3 d 5 6 7 8 9 1 0 E R CE...

Accounting
1.2K views

Laudi Inc. follows IFRS and uses the immediate recognition method for its pension plan. The...

Accounting
1.2K views

Required: a) Prepare manufacturing account for the year ended 31 December 2022. (10 marks) (CLO2:PLO4:C3)...

Accounting
1.2K views

Mid-South Auto Leasing leases vehicles to consumers. The attraction to customers is that the company...

Finance
1.2K views

9311.73 is wrong (1 point) Suzie wants to buy a car for...