Question

I need a list of business rules and corresponding ERD for a simple, very basic Pet Store.
Don’t think Petco or PetSmart, think little shop with only one location. They sell puppies, kittens, fish, and some reptiles. They also sell fancy food, toys, and beds for all these pets. Basically, the store sells things (2 entities), by whom (entity), to who (entity), and how (entity).
I need two things: First, information containing the operation and business rules for a simple Pet Store.
Second, I need an ERD representing the Entities and Relationships as dictated by the Business Rules.

Answer 1

Answer :

Maintain a category list to keep track of different types of categories and the number of pets for each.

· Maintain a table for each category with all the instances of that category and required information for each instance.

· Maintain a table for all the toys, food, utilities along with mapping with a specific pet.

· Maintain a table to maintain the different transaction that occurs as the pets and other add-ons are sold.

· Maintain a table for customer information.

· CRUD operation for each table they maintain.

ERD Diagram

NOTE : PLEASE GIVE ME UP VOTE. THANK YOU.