I'm assuming that you're working with some sort of DBMS here (Database Management System)

I did a bit of work with SQL last year so i may be able to help.

Are you provided with some sort of database/schema as reference?

Yea i have this to enter commands and stuff,

[ Register or Signin to view external links. ]


Here is the tables that might be needed,

[ Register or Signin to view external links. ]

[ Register or Signin to view external links. ]

By the schema, he means the names of all the different tables.

Ideally, you would have an entity-relationship diagram that will define each table and the attributes given for each one.

e.g.

Pet
- Species
- Breed
- Name
- Age

Appointment
- Date
- Vet_ID
- Job
- Pet

etc. with each table showing the relationship between other tables. (1-to-1 or 1-to-many)

Something like this:
[ Register or Signin to view external links. ]


To work out the total cost prescribed by each vet, I would create a new compound attribute that combined each unique vet with their total cost. Increment the value for each attribute depending on which vet had set the prescription.