Answered step by step
Verified Expert Solution
Link Copied!

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)
HAS_BEAN (COFFEE, BEAN_NAME)
BEAN (BEAN_NAME, FROM_LOCATION)
The relation DRINKS tells us which people drink which coffees. People can drink more than one coffee. The HAS_BEAN 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 1/2 point, except for 2(c), which is worth 1/2 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Oracle Databases On The Web Learn To Create Web Pages That Interface With Database Engines

Authors: Robert Papaj, Donald Burleson

11th Edition

1576100995, 978-1576100998

Students also viewed these Databases questions

Question

Why We Listen?

Answered: 1 week ago