Question

A local home owners association (HOA) has a policy that requires residents to register their pets with the Association and to pay a yearly fee for each animal (the cost is different for dogs vs. cats). Further, the animal is required to wear tags. Currently, the register of pets is kept in an Excel file (see below).

For this exercise:

• Use draw.io (Links to an external site.)Links to an external site. or MS Visio to design a database (in 3NF) to replace this spreadsheet.
• Include arrows to indicate relationships between tables.
• Include PK and FK indicators to indicate the Primary and Foreign keys.
• Indicate recommended indexed columns with an asterisks.
• Use the picture to help build design.
  lle de Fisther Ranndy Du $25.00 88AS MouthCat Mixed 12.00 22MK Blue Eyes Cat 12.00 99U Nuse 1276 Giant Boston 3 2212 Splclman Walsh9 44299 313G MN Foxle Dog Mixed $25.0023RT Dog Great Dan $25.00 7GYT Dcg Terricr 25.Co Walters 4 450 Fred Butler Wler De
  

Answer 1

Owner Details Table
ownerNo (PK)
*FirstName
*LastName
Street
DaytimePhone
EveningPhone

Pet Details Table
PetTagNum (PK)
ownerNo (FK)
PetType (FK)
*PetName

Pet Breed Table
PetType (PK)
PetBreed

Pet Fee Table
PetType (PK)
PetFee

OwnerDetails ownerNo (PK) *FirstName *LastName Street DaytimePhone PetBreed EveningPhone PetType (PK) PetBreed PetDetails PetTagNum (PK) PetFee ownerNo (FK) PetType (PK) PetType (FK) PetFee *PetName