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,
Personal trainer table and a Bike table' Consider the following business rules:

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 (ie, clients that they train), An employee can only have one bike. A type of bike can be assigned to many employees (.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 Jane Kadabra 002 Kay Smith 003 Sally Jones 004 Tom Blink 001 Bike id Bike table 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 Keys) in this table structure so that we can link the tables? (50 words) For the toolbar, press ALT-F10(PC) OF ALT-EN-F10 (Mac)

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!