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: 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
Get step-by-step solutions from verified subject matter experts
