Veterinarian Office Case: Part $4$

The veterinarian office created a database to keep track of owner and pet information. It also includes tracking appointments and treatments for each pet.

The veterinarians need to retrieve the data for different reasons. Read the question and select the correct answer to that question.

Pet

PET$\_$ID int

PET$\_$BREED varchar$(17)$

PET$\_$NAME varchar$(23)$

OWNER$\_$ID int SPECIES varchar$(10)=$

Appointments

APPOINTMENT$\_$IDint PET$\_$ID int APPOINTMENT$\_$DATE date APPOINTMENT$\_$REASON varchar$(55)$ INVOICE decimal $(7,2)$ PAID char$(1)$

OWNER$\_$ID int OWNER$\_$FNAME varchar$(20)$ OWNER$\_$LNAME varchar$(30)$ OWNER$\_$ST$\_$ADDRESS varchar$(50)$ OWNER$\_$CITY varchar$(25)$ OWNER$\_$STATE char$(2)$ OWNER$\_$POSTAL$\_$CODE varchar$(15)$ OWNER$\_$PHONE int OWNER EMAIL varchar$(30)$