Exam 3: Data Modeling

In Unified Modeling Language (UML)the options for minimum multiplicity values are 0,1,and 2.

Identify the classes and associations in the following narrative and draw a class diagram with multiplicities: Dr.Jeff runs Fountain Valley Veterinary Clinic.He treats many animals and each animal is usually a pet belonging to one owner; however,Dr.Jeff sometimes treats injured animals even if the owner is unknown.In a typical visit to the clinic,each animal could receive one or more clinic services (such as tests,shots,and surgical treatments).The clinic collects one payment from the owner for all the clinic services performed in each visit.The owners pay for the visit when they pick up their pet,so the clinic does not track cash receipts separately.It only tracks pet visits and whether or not payment was received for that visit.Each payment is deposited into one clinic bank account.The clinic does not track which employee performs the services or collects payments.The clinic records information about the pets and their owners on their first visit.

Which of the following is the best description of an association?

A database should have exactly the same number of tables as there are Classes in the Unified Modeling Language (UML)Class diagram from which the database is developed.

Business rules set criteria for branching in activity models.