Entity relationship model chart- ERD MODEL CHART ( The models may be drawn in LucidChart and placed in a Word document, or you may draw them by hand on a piece of paper and submit a clear photograph of the drawing. )

 

Question 26 (100 points) First Urban Rescue (FUR) takes in cats and dogs that are no longer wanted in their old home, and tries to find them new homes. For each pet taken in by FUR, the pet is given a name if it doesn't already have one. The breed, name, approximate age, height, weight, and date arrived at FUR is recorded for every pet that comes in. For each breed, FUR keeps the breed name, the normal size of that breed ("very small", "small", "medium", "large", or "very large"), a general description of the breed, and whether it is a canine or feline breed. Every pet is associated with one and only one breed. FUR may have several pets of a given breed. It is possible that there is data about certain breeds for which FUR has never had a pet of that breed. One of the first things that FUR does with new pets is to ensure that they receive the proper vaccinations. For each vaccination available, the disease that it prevents, the type of vaccine, and a description of the vaccination are recorded. A pet will typically receive many vaccinations, although some pets don't need any. A vaccination can be given to several different pets, although some new vaccinations are occasionally developed that haven't been used on any pet yet. Each time a pet receives a vaccination, the date administered must be recorded. When a person adopts a pet, the person's name and address are recorded along with the adoption date of that pet. A person can adopt several pets. Unfortunately, adoptions do not always work out, so a pet can be returned. If a pet is returned, the date of return for that adoption must be recorded. Therefore, it is possible for a pet to be adopted more than once. Not all pets get adopted. Only people that have adopted a pet are recorded in the system.