Consider the following many to many relationship:
An aircraft can be owned by many people.
A person can own many aircraft.
What would be the most appropriate way to handle the foreign keys to maintain this relationship?
A) Create a new table that has a foreign key reference to both aircrafts and people.
B) Create a foreign key in aircraft that references people.
C) Create a foreign key in people that references aircraft.
D) Combine the two tables into a single table that has properties of both people and aircraft.
E) This is not possible to model in MySQL and must be handled in the application logic.