Question: please help me ... Question 1. A database is given to you consisting of the following three relations. [5] Regulars (shopname, studentno) giving the ice-cream

please help me ...

Question 1. A database is given to you consisting of the following three relations. [5] Regulars (shopname, studentno) giving the ice-cream shopname each student visits. SELLS (shopname, ice-creamtype) indicating what kind of ice-creams each parlor sells. LIKES (studentno, ice-creamtype) indicating what ice-creams each student likes. (Assume that each student likes at least one ice-cream and frequents at least one parlor) i) Find out the student numbers that are regulars at atleast one ice-cream shop that sells some ice- cream types that they like. ii) Find out the icecream shopnames where the avg number of regulars are more than the avg regulars of shopname "Gileto".

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 Computer Network Questions!

Calculate the probability that on a randomly selected day it rains AND Rafael rides his bike. Round to two places past the decimal. travels to work each day either by bus or by bike. We have data...

Design a Java class that represents a cache with a fixed size. It should support operations like add, retrieve, and remove, and it should evict the least recently used item when it reaches capacity.

CANMNMM January of this year. (a) Each item will be held in a record. Describe all the data structures that must refer to these records to implement the required functionality. Describe all the...

London School of Science & Technology Qualification Unit number and title BTEC Level 5 HND Diploma Business UNIT 6: Business Decision Making Student name and ID number Assessor name Al Hassan Barrie...

JBR-07575; No of Pages 12 Journal of Business Research xxx (2012) xxx-xxx Contents lists available at SciVerse ScienceDirect Journal of Business Research Organizational innovation as an enabler of...

PROJ6000: Principles of Project Management Assessment 3 - Project Charter Report. Length 2,000 words (+/- 10%) Task Summary After reading the project case study, use it to develop a 2,000-word...

answer the question clearly You are building a flight-control system for which a convincing safety case must be made. Would you assign the tasks of safety requirements engineering, test case...

Activity 4A To provide you with an opportunity to identify how to determine and select from options for treating risks. Refer to Case Study E - Data breach 1. You must research the topic of a...

1. Read the case study below. This will form the basis for your Project Charter, because you will assume that you are the project manager for this project. 2. After reading the case study, begin to...

The Royal Botanic Gardens Victoria website describes the Melbourne Gardens as having: "been a treasured part of Melbourne's cultural life for more than 170years-much loved by generations of...

The International Publishing Group is raising $10 million by issuing 15-year bonds with a coupon rate of 8.5 percent. Coupon payments will be made annually. Investors buying the bonds today will earn...

Evaluating the l i m i t lim x - x 3 - 2 7 x 5 + 1 0 x 4 i t comes out that lim x - x 3 - 2 7 x 5 + 1 0 x 4 = 0 Write the complete solution t o support the answer. Submit your work here: N o file...

Northern Engineering is analyzing a mining project. Annual production, unit costs, and unit' revenues are in the table. The first cost of the mine setup is $8 million. If is 15%, what is the PW? Cost...

A disoriented physics professor drives 3.25 km north, then 4.75 km west, and then 1.50 km south. Find the magnitude and direction of the resultant displacement, using the method of components in a...

Companies often try to keep accounting earnings growing at a relatively steady pace, thereby avoiding large swings in. earnings from period to period. They also try to me earnings targets. To do so...

A 5.0-m 3 tank is charged with 75.0 kg of propane gas at 25C. Use the SRK equation of state to estimate the pressure in the tank: then calculate the percentage error that would result from the use of...

A stream of air (21 mole% O 2 , the rest N 2 ) flowing at a rate of 10.0 kg/h is mixed with a stream of CO 2 . The CO 2 enters the mixer at a rate of 20.0m 3 /h at 150C and 1.5 bar what is the mole...

The return of goods to the supplier will affect the purchase account. Question 27Answer True False

A reaction is to be carried out in the packed-bed reactor shown in Figure P12-19C. PFR with heat exchange. The reactants enter the annular space between an outer insulated tube and an inner tube...

Consider the catalytic reaction as a function of the initial partial pressures 2AB+C The rate of disappearance of species A was obtained in a differential reactor and is shown below. Three graphs...

The elementary, irreversible, organic liquid-phase reaction A + B C is carried out adiabatically in a flow reactor. An equal molar feed in A and B enters at 27C, and the volumetric flow rate is 2 dm...

First, as we discussed in Chapter 12, expressions of abnormality and their underlying psychological causes are at least partly culture bound.

Cultural awareness and beliefs: Counselors are sensitive to their personal values and biases and how these may influence perceptions of clients, the clients problems, and counseling relationships.

Cultural skills: Counselors have the ability to intervene in a manner that is culturally sensitive and relevant.