I'm currently trying to create a pet store database in access for a class assignment.
Scenario: The pet store provides three services an adoption service, medical service and a pet treatment service.
The adoption service is where customers can come in and choose from a list of pets then pay an adoption fee and take the pet home.
The medical service is where customers can bring their pets in for surgery, vaccinations, neutering and things of that nature.
The pet treatment service is where customers either choose from a grooming service or a wash and cut service and things in that nature.
I have my tables but I'm not sure how the relationships are suppose to work. I was wondering if someone out there could give a little insight to my little dilemma.
Tables I've got so far are as follows.
I may have tables that are missing and tables that shouldn't be in here.
Any help would greatly be appreciated.
I also posted an image below on how I created the relationships.