Question: 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 tness 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 sta may choose to have a Mountain bike).

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 Databases Questions!