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.