How can you organize a table that has 3 foreign keys (FKs) and they are all Master Keys?

Question

MySQL

How can you organize a table that has 3 foreign keys (FKs) and they are all Master Keys?

Table A, all PK and FK fields
Table B, all PK and FK fields
Table C, airline_code FK, flight_number PK
Task, create a CONSTRAINT for Table A.
An entry is created in Table A only when the Airline Code matches the Aircraft Model ( Table B) and Flight Number (Table C)
If the design needs to be redesigned, explain how it can be presented.

Answer 1

For example, in table B the primary key is composite, and in A there is a forenkey with a unique constraint.