Question
Need to solve this in Relation Algebra Queries Schema: Member(MName, Phone, Street, MCity, Province, Postal) CaughtReport(Phone, TagID, Date, Time, BID, SwimID, Weight, Condition) Pound(PName, PCity)
Need to solve this in Relation Algebra Queries
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started