Question: Question: Create an ERD based on information given. Bellissima Day Spas You are to create a system to manage appointments at Bellissima Day Spas. Bellissima
Question: Create an ERD based on information given.
Bellissima Day Spas You are to create a system to manage appointments at Bellissima Day Spas. Bellissima provides a range of salon and spa services at its three branches in Farmington Hills, Brighton, and Ann Arbor. Each branch has a manager, administrative assistant, hair stylists, and spa techs. The administrative assistant at each branch currently schedules all appointments and will be the primary user of your new system. Hair stylists provide salon services while spa techs handle manicures, pedicures, waxes, and massages. Only techs that have been certified in a specific service are allowed to perform it. Each service provided by Bellissima has a specific price and is allotted one hour (for the sake of simplicity). Clients make appointments for a specific service by stylist or tech. Obviously a stylist or tech can only serve one client at a time. Your system should provide a user-friendly interface and should handle the following functions: V Basic 1. Allow a manager to add a service. 2. Allow a customer to be added to the system. 3. Allow a customer to make an appointment, making sure there are no scheduling conflicts. 4. Allow a manager to see the appointments at his/her branch on a given date. In addition to the system, you are to provide the following documentation: class 1. A fully annotated ERD. 6 Draft week 6 Deliverable
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
