Question: Each landscaper is assigned clients. However, when they first start, a landscaper is not assigned any clients while they are training. Each client is asked
Each landscaper is assigned clients. However, when they first start, a landscaper is not assigned any clients while they are training. Each client is asked if they have a preferred landscaper. If they have no preference, a landscaper is assigned to them that becomes their preferred landscaper. Of course, they can switch their preferred landscaper at any time.
Include relationships and ER language.
It has been determined that some clients do not want a preferred landscaper and are willing to have whoever is available during their appointment. As a result, if a client prefers a specific landscaper, it is recorded. Otherwise, a client is not assigned a landscaper.
Modify the previous data model.
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
