You are the DB Designer for ABCD Airlines. The company maintains a large fleet and a huge flight schedule. Not only is it imperative that information about flights, aircraft, and pilots be up-to-date; it is equally important that all data integrity be optimized to the highest degree. You are required to create the tables used to keep track of pilots and aircraft. Every pilot in the company has a batch number and every aircraft has a serial number. It is important that at any given time, flight controllers can know which aircraft had been flown by which pilot and when. Information about pilots in recorded in the Pilots table. Information about aircrafts is recorded in the Aircrafts table. You want a table that will facilitate the matching and combining of different aircraft with different pilots at certain dates. You would:

247.

You are the DB Designer for ABCD Airlines.
The company maintains a large fleet and a huge flight schedule. Not only is it imperative that information about flights, aircraft, and pilots be up-to-date; it is equally important that all data integrity be optimized to the highest degree.
You are required to create the tables used to keep track of pilots and aircraft. Every pilot in the company has a batch number and every aircraft has a serial number.
It is important that at any given time, flight controllers can know which aircraft had been flown by which pilot and when. Information about pilots in recorded in the Pilots table.
Information about aircrafts is recorded in the Aircrafts table. You want a table that will facilitate the matching and combining of different aircraft with different pilots at certain dates.
You would:

Create an AircraftSerialNumber column in the Pilots table

Create a PilotBatchNumber column in the Aircrafts table

Create a PilotBatchNumber column in the Aircrafts table and create an AircraftsPilots table and include the PilotBatchNumber from the Aircraft table. Make the PilotBatchNumber the PRIMARY KEY of the AircraftsPilots table and include a Date column.

Create an AircraftSerialNumber column in the Pilots table and create an AircraftsPilots table and include the AircraftSerialNumber from the Pilots table. Make the AircraftSerialNumber the PRIMARY KEY of the AircraftsPilots table and include a Date column.

Create an AircraftsPilots table and include the PilotBatchNumber from the Pilots table and the AircraftSerialNumber from the Aircrafts table. Make the PilotBatchNumber and the AircraftSerialNumber the composite PRIMARY KEY of the AircraftsPilots table and include a Date column.

View Description

No description found.