Question: need answer for question 7. database layout on right with primary key in respective tables underlined. need complete query answer. Consider the beer drinker's database

 need answer for question 7. database layout on right with primary

need answer for question 7. database layout on right with primary key in respective tables underlined. need complete query answer.

Consider the beer drinker's database s underlined 6 Find all drinkers who frequent every bar that serves some beers they like Name Location Tony TrotterellMontlake Drinker (name, address) Bar (name, address) Beer (name, brewer) Frequents (drinker, bar, times_a_ week) Likes (drinker, beer) Serves (bar, beer, price) 7. Find those drinkers who enjoy exactly the same set of beers as Silvie Hume Name Andrey Waterville Greek row 8. For each beer, find the bars that serve it at the lowest price Bar Beer Bhagwan's Best IPA Big Time Brewery 5.75 Prime Time Pale Ale Big Time Brewery 5.5 Mac and Jack's Amber College Inn Bud light Budweiser Heincken Rainier Beer Price Answer the following questions: Dantes Dantes Dante's Dantes 1. Find all drinkers who frequent Big 2.25 names and addresses

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!