Case Study 3 - Perfect Pets
A practice called Perfect Pets provides private health care for domestic pets throughout America. This service is provided through various clinics located in the main cities of America. The Director has provided the following description of the current system.
Perfect Pets has many veterinary clinics located in the main cities of America. The details of each clinic include the clinic number, clinic address (consisting of the street, city, state, and zipcode), and the telephone and fax numbers. Each clinic has a Manager and a number of staff (for example, vets, nurses, secretaries, cleaners). The clinic number is unique throughout the practice.
The details stored on each member of staff include the staff number, name (first and last), address (street, city, state, and zipcode), telephone number, date of birth, sex, social security number (SSN), position, and current annual salary. The staff number is unique throughout the practice.
When a pet owner first contacts a clinic of Perfect Pets the details of the pet owner are recorded, which include an owner number, owner name (first name and last name), address (street, city, state, and zipcode), and home telephone number. The owner number is unique to a particular clinic.
The details of the pet requiring treatment are noted, which include a pet number, pet name, type of pet, description, date of birth (if unknown, an approximate date is recorded), date registered at clinic, current status (alive/deceased), and the details of the pet owner. The pet number is unique to a particular clinic.
When a sick pet is brought to a clinic, the vet on duty examines the pet. The details of each examination are recorded and include an examination number, the date and time of the examination, the name of the vet, the pet number, pet name, and type of pet, and a full description of the examination results. The examination number is unique to a particular clinic. As a result of the examination, the vet may propose treatment(s) for the pet.
Perfect Pets provides various treatments for all types of pets. These treatments are provided at a standard rate across all clinics. The details of each treatment include a treatment number, a full description of the treatment, and the cost to the pet owner. For example, treatments include:
T123 $\quad$Penicillin antibiotic course$\quad$ $50.00
T155 $\quad$Feline hysterectomy $\quad$ $200.00
T112$\quad$ Vaccination course against feline flu $\quad$ $70.00
A standard rate of $20.00 is charged for each examination, which is recorded as a type of treatment. The treatment number uniquely identifies each type of treatment and is used by all Perfect Pets clinics.
Based on the results of the examination of a sick pet, the vet may propose one or more types of treatment. For each type of treatment, the information recorded includes the examination number and date, the pet number, name and type, treatment number, description, quantity of each type of treatment, and date the treatment is to begin and end. Any additional comments on the provision of each type of treatment are also recorded.
-Write the following query in the Object Query Language (OQL) of the ODMG object model: List the names of all pets that received the T123 treatment.

Question

Case Study 3 - Perfect Pets
A practice called Perfect Pets provides private health care for domestic pets throughout America. This service is provided through various clinics located in the main cities of America. The Director has provided the following description of the current system.
Perfect Pets has many veterinary clinics located in the main cities of America. The details of each clinic include the clinic number, clinic address (consisting of the street, city, state, and zipcode), and the telephone and fax numbers. Each clinic has a Manager and a number of staff (for example, vets, nurses, secretaries, cleaners). The clinic number is unique throughout the practice.
The details stored on each member of staff include the staff number, name (first and last), address (street, city, state, and zipcode), telephone number, date of birth, sex, social security number (SSN), position, and current annual salary. The staff number is unique throughout the practice.
When a pet owner first contacts a clinic of Perfect Pets the details of the pet owner are recorded, which include an owner number, owner name (first name and last name), address (street, city, state, and zipcode), and home telephone number. The owner number is unique to a particular clinic. 
The details of the pet requiring treatment are noted, which include a pet number, pet name, type of pet, description, date of birth (if unknown, an approximate date is recorded), date registered at clinic, current status (alive/deceased), and the details of the pet owner. The pet number is unique to a particular clinic.
When a sick pet is brought to a clinic, the vet on duty examines the pet. The details of each examination are recorded and include an examination number, the date and time of the examination, the name of the vet, the pet number, pet name, and type of pet, and a full description of the examination results. The examination number is unique to a particular clinic. As a result of the examination, the vet may propose treatment(s) for the pet.
Perfect Pets provides various treatments for all types of pets. These treatments are provided at a standard rate across all clinics. The details of each treatment include a treatment number, a full description of the treatment, and the cost to the pet owner. For example, treatments include:
T123 $\quad$Penicillin antibiotic course$\quad$ $50.00
T155 $\quad$Feline hysterectomy $\quad$ $200.00
T112$\quad$ Vaccination course against feline flu $\quad$ $70.00
A standard rate of $20.00 is charged for each examination, which is recorded as a type of treatment. The treatment number uniquely identifies each type of treatment and is used by all Perfect Pets clinics.
Based on the results of the examination of a sick pet, the vet may propose one or more types of treatment. For each type of treatment, the information recorded includes the examination number and date, the pet number, name and type, treatment number, description, quantity of each type of treatment, and date the treatment is to begin and end. Any additional comments on the provision of each type of treatment are also recorded.
-Write the following query in the Object Query Language (OQL) of the ODMG object model: List the names of all pets that received the T123 treatment.

Quizplus · Accepted Answer

The Answer of Case Study 3 - Perfect Pets
A practice called Perfect Pets provides private health care for domestic pets throughout America. This service is provided through various clinics located in the main cities of America. The Director has provided the following description of the current system.
Perfect Pets has many veterinary clinics located in the main cities of America. The details of each clinic include the clinic number, clinic address (consisting of the street, city, state, and zipcode), and the telephone and fax numbers. Each clinic has a Manager and a number of staff (for example, vets, nurses, secretaries, cleaners). The clinic number is unique throughout the practice.
The details stored on each member of staff include the staff number, name (first and last), address (street, city, state, and zipcode), telephone number, date of birth, sex, social security number (SSN), position, and current annual salary. The staff number is unique throughout the practice.
When a pet owner first contacts a clinic of Perfect Pets the details of the pet owner are recorded, which include an owner number, owner name (first name and last name), address (street, city, state, and zipcode), and home telephone number. The owner number is unique to a particular clinic. 
The details of the pet requiring treatment are noted, which include a pet number, pet name, type of pet, description, date of birth (if unknown, an approximate date is recorded), date registered at clinic, current status (alive/deceased), and the details of the pet owner. The pet number is unique to a particular clinic.
When a sick pet is brought to a clinic, the vet on duty examines the pet. The details of each examination are recorded and include an examination number, the date and time of the examination, the name of the vet, the pet number, pet name, and type of pet, and a full description of the examination results. The examination number is unique to a particular clinic. As a result of the examination, the vet may propose treatment(s) for the pet.
Perfect Pets provides various treatments for all types of pets. These treatments are provided at a standard rate across all clinics. The details of each treatment include a treatment number, a full description of the treatment, and the cost to the pet owner. For example, treatments include:
T123 $\quad$Penicillin antibiotic course$\quad$ $50.00
T155 $\quad$Feline hysterectomy $\quad$ $200.00
T112$\quad$ Vaccination course against feline flu $\quad$ $70.00
A standard rate of $20.00 is charged for each examination, which is recorded as a type of treatment. The treatment number uniquely identifies each type of treatment and is used by all Perfect Pets clinics.
Based on the results of the examination of a sick pet, the vet may propose one or more types of treatment. For each type of treatment, the information recorded includes the examination number and date, the pet number, name and type, treatment number, description, quantity of each type of treatment, and date the treatment is to begin and end. Any additional comments on the provision of each type of treatment are also recorded.
-Write the following query in the Object Query Language (OQL) of the ODMG object model: List the names of all pets that received the T123 treatment.

Case Study 3 - Perfect Pets a Practice Called Perfect \quad

Case Study 3 - Perfect Pets
a Practice Called Perfect $\quad$