Figure $3-28$: BITM$520-$ Project $4$

Submit either an access database with each of your queries numbered in the database or

submit a Word document with the query syntax. You will be graded $1$ pt per question

based on the accuracy of the query results.

Use the following tables for your answers to the questions

PET$\_$OWNER $($OwnerID$,$ OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail$)$

PET $($PetID$,$ PetName, PetTyoe, PetBreed, PetDOB, OwnerID$)$

PET$\_3($PetID$,$ PetName, PetTyoe, PetBreed, PetDOB, PetWeight, OwnerID$)$

BREED $($BreedName$,$ MinWeight, MaxWeight, AverageLifeExpectancy$)$

Sample data for these tables are shown in Figures $3-26$ and $3-27.$ For each SQL statement you

write, show the results based on these data.

Figure $3-26$ :

PET$\_$OWNER Data

Figure $3-27$:

PET Data Figure $3-28$:

PET$\_3$ Data

Figure $3-29$:

BREED Data

$3\mathrm{.}1$ Write an SQL statement to display all columns of all rows of PET. Do not use the

asterisk $(*)$ notation.

$3\mathrm{.}2$ Write an SQL statement to display all columns of all rows of PET. Use the asterisk $(*)$

notation.

$3\mathrm{.}3$ Write a SQL statement to display the breed and types of all pets.

$3\mathrm{.}4$ Write an SQL statement to display the breed, type, and DOB of all pets having the type

Dog.

$3\mathrm{.}5$ Write an SQL statement to display the PetBreed column of PET.

$3\mathrm{.}6$ Write an SQL statement to display the PetBreed column of PET. Do not show

duplicates.

$3\mathrm{.}7$ Write an SQL statement to display the breed, type, and DOB for all pets having the type

Dog and the breed Std$.$ Poodle.

PET$\_3$ Data

Figure $3-29$:

BREED Data

$3\mathrm{.}1$ Write an SQL statement to display all columns of all rows of PET. Do not use the

asterisk $(*)$ notation.

$3\mathrm{.}2$ Write an SQL statement to display all columns of all rows of PET. Use the asterisk $(*)$

notation.

$3\mathrm{.}3$ Write a SQL statement to display the breed and types of all pets.

$3\mathrm{.}4$ Write an SQL statement to display the breed, type, and DOB of all pets having the type

Dog.

$3\mathrm{.}5$ Write an SQL statement to display the PetBreed column of PET.

$3\mathrm{.}6$ Write an SQL statement to display the PetBreed column of PET. Do not show

duplicates.

$3\mathrm{.}7$ Write an SQL statement to display the breed, type, and DOB for all pets having the type

Dog and the breed Std$.$ Poodle.