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

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

Recommended Textbook for

Database Basics Computer EngineeringInformation Warehouse Basics From Science

Authors: Odiljon Jakbarov ,Anvarkhan Majidov

1st Edition

620675183X, 978-6206751830

More Books

Students also viewed these Databases questions

Question

1. What is the meaning and definition of banks ?

Answered: 1 week ago

Question

2. What is the meaning and definition of Banking?

Answered: 1 week ago

Question

3.What are the Importance / Role of Bank in Business?

Answered: 1 week ago