Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the following set of relations, which describe coffee and coffee drinkers: DRINKS ( PERSON , COFFEE ) HAS _ BEAN ( COFFEE , BEAN
Consider the following set of relations, which describe coffee and coffee drinkers:
DRINKS PERSON COFFEE
HASBEAN COFFEE BEANNAME
BEAN BEANNAME, FROMLOCATION
The relation DRINKS tells us which people drink which coffees. People can drink more than one coffee. The HASBEAN relation tells us what coffee beans go into each type of coffee. A coffee can have many beans. And the BEAN relation tells us which location each coffee bean comes from; a bean can grow in multiple relations.
Write Tuple relational calculus expressions to compute each of the following. Again, you can abbreviate attribute names. Each is worth point, except for c which is worth point.
a Which locations contribute a bean to a coffee consumed by Chris
b Which people don't drink any of the coffees that are consumed by "Chris"?
c Which people drink a set of coffees that together contain all of the beans from Hawaii
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