Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question on Database Normalization to 2NF and 3NF Consider the following relation Some of the requirements that this table is based on are as follows:
Question on Database Normalization to 2NF and 3NF
Consider the following relation Some of the requirements that this table is based on are as follows: a. The AIRLINE is flying number of flights on various routes daily. b. A flight with a particular Flight Id always flies on the same route (same Origin and same Destination). C. Every captain has a unique Captain Id, and a non-unique Captain Name. d. For each instance of a flight (a particular flight on a particular Flight Date) we keep track of who was the captain of that instance of a flight and how many passengers were on board (Number of Passengers on the Flight). e. A captain can fly multiple flights during the same day. 1. Normalize the relation to the second normal form (2NF). 2. Normalize the relation to the third normal form (3NF). AIRLINE TABLE Origin Destination Captain Flight Date Flight ID Captain Name Number of Passengers on the Flight Tracy 110 111 222 Matt April 10 April 10 April 12 April 12 111 222 111 333 Chicago LA. L.A. Phoenix Chicago LA. L.A. N.Y. 444 Tim 111 Tracy April 12 444 N.Y. 333 Pat April 12 555 L.A. Dallas 444 Tim April 12 222 Phoenix 555 PatStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started