Question: Flight ( flightnumber , flighttime, airelinename, passengername, pass _ gender, pass _ dateofbirth, pilotname, pilot _ gender, pilot _ dateofbirth, departure _ city, arrival _

Flight (flightnumber, flighttime, airelinename, passengername, pass_gender, pass_dateofbirth, pilotname, pilot_gender, pilot_dateofbirth, departure_city, arrival_city, planeid, plane_type, seats).
1. Answer the following questions:
a. What is the PK for this relation in its current state? (4 pts)
b. What Normal Form is the current state of this relation? (4 pts)

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 Databases Questions!

Q:

A vertical column of 1018 hot-rolled steel is 10 in wide. An attachment has been designed to the point shown in the figure. The static load of 20 kip is applied, and the clearance a of 6.25 in has to...

Q:

Are PK Flight number & Passenger name? Since each passenger has a unique name. Maybe pilot name is also primary key? The travel office at Pilot Training College maintains information about flights...

Q:

The travel office at Pilot Training College maintains information about flights pilots, and passengers. You have been given the following assumptions: . A flight has a unique flight number, a...

Q:

The travel office at Pilot Training College maintains information about flights pilots, and passengers. You have been given the following assumptions: . A flight has a unique flight number, a...

Q:

The travel office at Pilot Training College maintains information about flights, pilots, and passengers. You have been given the following assumptions: A flight has a unique flight number, a...

Q:

The travel office at Pilot Training College maintains information about flights, pilots, and passengers. You have been given the following assumptions: A flight has a unique flight number, a...

Q:

how to solve 6.2 E 6.2E Given the following assumptions: a flight has a unique flight number, a passenger has a unique name, a pilot has a unique name; a flight is always handled by one airline; a...

Q:

NORMALIZATION The travel office at Pilot Training College maintains information about flights, pilots, and passengers. You have been given the following assumptions: A flight has a unique flight...

Q:

The travel office at Pilot Training College maintains information about flights, pilots, and passengers. You have been given the following assumptions: A flight has a unique flight number, a...

Q:

(Databases) Please answer clearly. A thumbs up for the right answer. 6. Given the following assumptions: A flight has a unique flight number, a passenger has a unique name, a pilot has a unique name;...

Q:

Given the following assumptions: Each book has a unique ISBN number; Each author has a unique name; Each publisher has a unique name; A book can have multiple authors; An author can write more than...

Q:

Identify and analyze each of the following transactions of Wolverine Corporation. The company uses the periodic system. March 3: Purchased merchandise from Spartan Corp. for $2,500 with terms of...

Q:

What is the pH at the equivalence point in the titration of a 17.2 mL sample of a 0.348 M aqueous hydrocyanic acid solution with a 0.314 M aqueous sodium hydroxide solution? pH =

Q:

Which of the following statements are correct? Check all that apply. The Dow Jones Industrial Average is an example of a stock exchange where he can purchase Warm Breeze stock. An increase in the...

Q:

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

Q:

1 What management systems are operating in African countries (and other post-colonial regions), in different ways in different industries and companies, and how successful are these systems in...

Q:

investigating the cultural contributions that non-Western (particularly postcolonial and post-Soviet) approaches can make to global managing;

Q:

developing conceptual and empirical links between theoretical formulations of cultural value dimensions and specific manifestations in HRM/people management policies and practices;