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 tablePersonal 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 ie clients that they train
An employee can only have one bike. A type of bike can be assigned to many employees ie 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
