The purpose of this assignment is to provide practice in conceptual database design, using the entity-relationship (ER) model Draw an ER diagram to model a database for a no-kill cat shelter, according to the following requirements Each cat has a name, ID number, age, gender and color or colors (like black and white). The status of each cat, such as available, sick, or adopted, is also maintained. The shelter tracks how many cats are currently available for adoption. Veterinarians are available to treat the shelter cats. Each vet has a name, address, and cell phone number. The vets are called by their last names (for example, Dr. Sanchez). When a cat is treated, the date of treatment and the types of treatment (such as immunization, neuter, flea bath) are recorded Cats are housed in cages, most of which can hold several cats at once. Each cage has a unique number to identify it and a maximum number of cats it can hold. The time that each cage was last cleaned is recorded. Adopters are people who adopt the shelter cats. Although cats may go home to whole families, an individual is listed as the official adopter. The adopter has a name, ID number, address, and one or more phone numbers. When a cat is adopted, the date of the adoption is recorded. For purposes of this assignment, we will make the simplifying assumption that all adoptions are fina Notes: Model only that part of the no-kill cat shelter described above. Do not try to model the entire cat shelter! Use only binary relationships. Use the ER diagram notation shown in Figure 3.14 of the text book. Do not include the notation shown at the very bottom of this figure for the structural constraint (min, max) on participation of E in R. A good description of the notation is given in Section 3.7.1 Clearly state any assumptions you make in determining the constraints for this mini-world. Do not make assumptions that counter any of the requirements listed above Diagrams may be legibly hand-drawn. Turn in your assignment, on paper, during class. Electronic submissions are not acceptable for this assignment
