Question: 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

 The database table structure in the image shows an 'Employee table',

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 id Bike table Bike name A Road B Hybrid 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)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!