The Database used for this is the VetOffice database. I cant add that Database File here but tell me how and I will send it.

Thanks

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