Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Shampooch Doggy Spa Shampooch doggy spa is a high-end dog grooming service where spa technicians (employees) groom dogs by providing services such as bath, teeth
Shampooch Doggy Spa Shampooch doggy spa is a high-end dog grooming service where spa technicians (employees) groom dogs by providing services such as bath, teeth brushing, or nail clipping. Employees are identified by an EmpID, and have a first name and last name. Employees may have certifications in specialties such as large dogs, styling long hair, or treating dry skin. All employees must have at least one certification. Some senior employees mentor up to four junior employees. Employees have a maximum of one mentor, or may not have any mentor. All dogs are assigned to an employee to provide grooming services. An employee may groom several dogs at once, or may not have any dogs to groom at all. If a dog is getting multiple services (i.e., bath and nail clipping), the dog may be groomed by several employees. The date each service was provided and which employee provided the service to the dog should be recorded in the database. Every dog's name, breed, and weight are recorded. Since multiple dogs might have the same name, dogs are identified by combining the name of the dog with the unique identifier of their owner. Customers are uniquely identified by their phone
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