You were hired to design a database for a small veterinary practice.

All of its data was being stored in an amateurish fashion in a spreadsheet a part of which is shown below.

List all the tables you are going to implement. Also list all the columns of these tables. Your tables should be at least in a $3$NF$.$

Decide which columns can be NULL

Indicate all Primary, Foreign, and Unique Keys.

Indicate all relationships between the tables

We have the following $$business rules$$:

An animal may be owned by more than one person

A person may own more than one animal

Animal owners reside in different countries and are billed in the currencies of their residence

Some bills might have to be re$-$sent, if they are not paid within $30$ days

Fee charged is up to the discretion of the vet providing the service

Supplies are being tracked

You may expand the categories of data as you see fit.