Reference no: EM133266179
You have been tasked with creating a database solution for a local pet store's grooming services. You are given the following information:
This database will need to store information about the pet grooming service performed, the animal and customer, and pet groomers.
There are several pet groomers that are employed by the store. Pet groomer information that will need to be stored: employee id, first name, last name, phone number.
Customer contact information must be stored. Animal breed, age, and name must be stored.
An appointment must be made for these pet grooming services.
The pet grooming services offered are Bath (cost: $11), Haircut (cost: $11), or Both (cost: $20).
Write SQL statements that will populate at least 5 records in each of your tables.