Please create ERDs for the following two examples and have them ready to upload. Please show cardinality for each one:
A small 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.
Joe runs a small car vehicle service company. Up to now, he has been keeping track of all his customer data on paper. He now needs a database. He needs to be able to track: the car that was brought in (the VIN is the primary key), who is the current owner of the car, each time the car was serviced and which mechanic preformed the service. A car can have just one owner, but an owner can have multiple cars. Each car can have multiple service visits, but during each service just one car is worked on. A mechanic can perform multiple services, but during each service just one mechanic is working on the car.
