SQL from the VetOffice Database is the source for this assignment

Database Processing Fundamentals, Design, and Implementation (Subscription)

David M. Kroenke, David J. Auer

This is the eBook of the printed book and may not include any media, website access codes, or print supplements ...

sql scripts for the Cape Codd database used in Chapter 2 are included in the student data files available at http://www.pearsonhighered.com/

How can I transfer the file to you? this does not allow me to do so?

1. Using a subquery List the first name and last name all of the cat owners Owner names are in the dbo.Owner table Pet species are in the dbo.Pet table Note the columns that list the OwnerlDs have different names in the two tables. In Pet it is named PetOwnerld and in Owner it is Ownerld. This should be your result: Results Bi Messages OwnerFname OwnerLname 1 David Tennant 2 Rose Tyler 2. Using a subquery List the pet names for all of the pets owned by Donna Noble. Hint: use an AND to check both the first and last name. If you cannot figure this out, it is ok to look for the owner with the last name of Noble This should be your result Results Bi Messages I ? Pet Name Bambi Bilbo 3. Use an inner join List the first name and last name all of the cat owners Owner names are in the dbo. Owner table Pet species are in the dbo. Pet table Note the columns that list the OwnerlDs have different names in the two tables. In Pet it is named PetOwner and in Owner it is Ownerld. List each owner name only once This should be your result: Messages Results Owner FName Owner Name David Tennant Rose Tyler 1 2 4. Use an inner join List the pet names for all of the pets owned by Donna Noble. Hint: use an AND to check both the first and last name. If you cannot figure this out, it is ok to look for the owner with the last name of Noble Results Messages Owner FName Owner Name David Tennant Rose Tyler 1 2 4. Use an inner join List the pet names for all of the pets owned by Donna Noble. Hint: use an AND to check both the first and last name. If you cannot figure this out, it is ok to look for the owner with the last name of Noble 5. Use an inner join List the Owner first name, last name, street address, city state and postal code for all owners that have dogs. 6. Use an inner join List the Owner first name, last name and phone number for all owners of German Shepherds 1. Using a subquery List the first name and last name all of the cat owners Owner names are in the dbo.Owner table Pet species are in the dbo.Pet table Note the columns that list the OwnerlDs have different names in the two tables. In Pet it is named PetOwnerld and in Owner it is Ownerld. This should be your result: Results Bi Messages OwnerFname OwnerLname 1 David Tennant 2 Rose Tyler 2. Using a subquery List the pet names for all of the pets owned by Donna Noble. Hint: use an AND to check both the first and last name. If you cannot figure this out, it is ok to look for the owner with the last name of Noble This should be your result Results Bi Messages I ? Pet Name Bambi Bilbo 3. Use an inner join List the first name and last name all of the cat owners Owner names are in the dbo. Owner table Pet species are in the dbo. Pet table Note the columns that list the OwnerlDs have different names in the two tables. In Pet it is named PetOwner and in Owner it is Ownerld. List each owner name only once This should be your result: Messages Results Owner FName Owner Name David Tennant Rose Tyler 1 2 4. Use an inner join List the pet names for all of the pets owned by Donna Noble. Hint: use an AND to check both the first and last name. If you cannot figure this out, it is ok to look for the owner with the last name of Noble Results Messages Owner FName Owner Name David Tennant Rose Tyler 1 2 4. Use an inner join List the pet names for all of the pets owned by Donna Noble. Hint: use an AND to check both the first and last name. If you cannot figure this out, it is ok to look for the owner with the last name of Noble 5. Use an inner join List the Owner first name, last name, street address, city state and postal code for all owners that have dogs. 6. Use an inner join List the Owner first name, last name and phone number for all owners of German Shepherds