Question: Consider a database with the following schema Person (name, age, gender) name is a key Frequents (name, iceCreamShop) (name, ice cream shop) is a key

Consider a database with the following schema

Person (name, age, gender) name is a key

Frequents (name, iceCreamShop) (name, ice cream shop) is a key

Eats (name, flavor) (name, flavor) is a key

Sells (iceCreamShop, flavor, price) (iceCreamShop, flavor) is a key

Find all the ice cream shops frequented by males over 21 years old.

Find all the names of females that eat vanilla ice cream but not chocolate.

Find all the names of males that eat either strawberry or/and pistachio ice cream.

Find all the ice cream shops where Sam likes at least one of their flavors and each cost less than $5.

For each person, find all ice cream flavors the person eats that are not served by any ice cream shop the person frequents. Return the name of the person and the ice cream flavor in pairs.

Find an ice cream shop that is frequented by people older than 30 but younger than 40 years old.

Find the ice cream shop with the most expensive scoop of vanilla ice cream, if theres more than one return all that apply.

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!

1. Consider a database with the following schema: Person (name, age, gender) name is a key Frequents (name, iceCreamShop) (name, ice cream shop) is a key Eats (name, flavor) (name, flavor) is a key...

1. Consider a database with the following schema: Person (name, age, gender) name is a key Frequents ( name, pizzeria) (name, pizzeria) is a key Eats (name, pizza) (name, pizza) is a key Serves...

write SQL queries for the C) Find the maximum price of a pizza served by each pizzeria under $25.00 d) Find all pizzerias that are frequented by only males. Hint: There may be pizzerias frequented by...

Hello Chegg, Looking for an answer for this question, Sorry its a bit long. Thank you very much! 1. Consider a database with the following schema: Person (name, age, gender) Frequents (name,...

1. Consider a database with the following schema: Person (name, age, gender) // name is a key Frequents (name, pizzeria) // [name, pizzeria) is a key Eats (name, pizza) // [name,pizza) is a key...

(b) Consider a database with the following schema: Person ( name, age, gender) (name) is a key Frequents ( name, pizzeria) (name, pizzeria) is a key Eats ( name, pizza ) (name, pizza) is a key Serves...

Consider a database with the following schema: Person (name, age, gender) name is a key Frequents (name, pizzeria) (name, pizzeria) is a key Eats (name, pizza ) Serves (pizzeria, pizza, price)...

Consider the following relational schema: Person (name, age, gender) name is a key Frequents (name, pizzeria) (name, pizzeria) is a key Eats (name, pizza) (name, pizza) is a key Serves (pizzeria,...

Suppose the relation R 1 ( A , B ) and R 2 ( B , C , D ) have the following tuples: Compute the theta - join of R 1 and R 2 with conditions R 1 . B = R 2 . B AND R 1 . A

Ringgold Corporation has outstanding at December 31, 2014, 50,000 shares of $20 par value, cumulative, 6% preferred stock and 200,000 shares of $5 par value common stock. All shares were outstanding...

1. Nokia Inc. has two user departments, Wireless Communications & Digital Communications. The two support departments are Technical Support (TS) & Research & Development (R&D). The...

6 5 - 6 8 Describe the level surfaces of the function. 6 5 . f ( x , y , z ) = x + 3 y + 5 z 6 6 . f ( x , y , z ) = x 2 + 3 y 2 + 5 z 2 6 7 . f ( x , y , z ) = y 2 + z 2 6 8 . f ( x , y , z ) = x 2...

management theories

Given the increased complexity of employees work and the demand for certain competencies, will online modules be an effective way to train employees at Elevated? What other cost-effective methods of...

You work in an organization that focuses on wine sales and marketing. Recently, there have been a number of complaints about a particular customer service representative in terms of the accuracy of...

In groups of 3-or 4, develop a list of behaviours or skills that would improve your performance as a team member. For each behaviour or skill, identify 1-or 2 training methods that would be...