Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started