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.