QUESTION 1

1. 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? (50 words)