solution

The database table structure in the image shows an ‘Employee table’, ‘Personal trainer table’ and a ‘Bike table’.
Consider the following business rules:

• As part of a fitness campaign, an organisation is assigning each of its employees a personal trainer and a bike.
• An employee can only have one personal trainer, but a trainer can have many employees (i.e., clients that they train).
• An employee can only have one bike. A type of bike can be assigned to many employees (i.e., many staff may choose to have a Mountain bike).

Employee table
Employee_id	Name	Address
245	Romario Jones	52 Eros St, Brisbane
265	Craig Lee	21 Mars St, Brisbane
987	Sally Ming	2 Jack St, Brisbane

Personal trainer table
Trainer_id	Trainer_name
001	Jane Kadabra
002	Kay Smith
003	Sally Jones
004	Tom Blink

Bike table
Bike_id	Bike name
A	Road
B	Hybrid
C	Mountain

Your task:What are the most appropriate Foreign Key(s) and where should we place the Foreign Key(s) in this table structure so that we can link the tables?