Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Schema: Member(MName, Phone, Street, MCity, Province, Postal) CaughtReport(Phone, TagID, Date, Time, BID, SwimID, Weight, Condition) Pound(PName, PCity) PoundGround(PName, PoundGroundID, Location, NickName) breed(BID, BName, Descriptions) Q1.

Schema: Member(MName, Phone, Street, MCity, Province, Postal) CaughtReport(Phone, TagID, Date, Time, BID, SwimID, Weight, Condition) Pound(PName, PCity) PoundGround(PName, PoundGroundID, Location, NickName) breed(BID, BName, Descriptions)

Q1. Find the pair of member and PoundGround where the member caught the most dogs in total weight in that pound. Say, over the years, John caught 300kg of dogs in pound10, 101 in pound8, 60 in pound11, while lola caught 102kg in pound 10, 10 in Pound11, 120 in pound 12. The result should display John, his phone number, pound10 and 300kgs

Q2. Based on the frequency of catch reports submitted, find the name of the most frequently visited Pound. Note that a member visited multiple Poundgrounds of the same Pound on the same day is considered ONE visit.

Q3. For member(s) who have caught at least one dog in Rockwood Pound, find the one(s) that never caught any Labradors in that pound. Your result should display the names of the members and their phone numbers.

Q4. Based on the catch reports, find the most recent day when Shawn mendes and Austin Butler Caught dogs on the same day but at different Poundgrounds of the same Pound.

Q5. Find the name of the Pounds where there has been at least one catch report submitted for each breed of dog except bulldog. In other words, every dog breed except bulldog has been caught in that Pound.

Q6. Find out how many times Lilly Collins and John Cena caught some germansSheps on the same day

Thanks in advance!

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions