Question: A veterinary clinic wants to create a database for its operations. It needs to track: animals, their owners, the visits to the clinic, and which
A veterinary clinic wants to create a database for its operations. It needs to track: animals, their owners, the visits to the clinic, and which vet they see on each visit. An animal can have just one owner, but an owner can have one or more animals. An animal can have lots of visits, but during each visit, just one animal is seen/treated. A vet can have one or more visits with animals, but during a visit, each animal sees/or is treated by just one vet.
Please show cardinality, but you don't need to show attributes or primary keys.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
