please help me ... Question 1. A database is given to you consisting of the following three
Fantastic news! We've Found the answer you've been seeking!
Question:
please help me ...
Transcribed Image Text:
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". 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".
Expert Answer:
Related Book For
Posted Date:
Students also viewed these computer network questions
-
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...
-
Summarize the extract given below? When Paul Farmer graduated from Duke University at 22, he was unsure whether he wanted to be an anthropologist or a doctor. So he went to Haiti. As a student, Paul...
-
Cathy is planning to take the Certified Public Accountant Examination (CPA exam). Records kept by the college of business from which she graduated indicate that 83% of the students who graduated pass...
-
The following transactions took place at Willis Counseling Services, a business established by Raymond Willis. Post the following transactions into the appropriate T accounts. Transactions: 1....
-
Frosting of evaporator tubes results in (a) increased heat transfer rate (b) decreased heat transfer rate (c) increased compressor pressure (d) decreased compressor pressure
-
The shareholders' equity section of Superior Corporations balance sheet as of December 31, 2015, is as follows: The following events occurred during 2016: Jan. 5 10,000 shares of authorized and...
-
The ledger of Rios Company contains the following balances: Retained Earnings $30,000, Dividends $2,000, Service Revenue $50,000. Salaries and Wages Expense $27,000, and Supplies Expense $7,000. The...
-
a. Based on the sources and requirements listed above, create a dimensional model that will be used for the dimensionally modeled data warehouse for Big Z Inc. b. Using data from Figures 9.31 and...
-
Paid Speed $200,000 to purchase the business Each owner put $10,000 into the company bank account as Contributed Capital on April 1, 2021 Paid rent for April, May, June, on the first of each month;...
-
Consider an empty stack of integers. Let the numbers 1, 2, 3, 4, 5 and 6 be pushed onto this stack only in the order they appeared from left to right. Let S indicate a push and X indicate a pop...
-
What are the disadvantages of circular linked list?
-
How do you search for a target key in a linked list?
-
What are different operations we can perform on queues?
-
How many different pointers are necessary to implement a singly linear linked list?
-
Determine whether you have enough monies to live comfortably each year for 20 years in your dream state. Assume you have the following assets at age 65: Pension Plan worth $400,000 today. You plan to...
-
What is the order p of a B + -tree? Describe the structure of both internal and leaf nodes of a B + -tree.
-
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...
-
An engineering student wanted to know which factors influence the time (in seconds) for his car to go from 0 to 30 to 0 miles per hour. Factor \(A\) was the launch, which was either no wheel spin or...
-
The effect on engine wear of oil viscosity, temperature, and a special additive was tested using a \(2^{3}\) factorial design. Given the following results from the experiment, Interpret the effects...
-
Two machines \(X\) and \(Y\) were used to produce two types of plastic polymers, PPET and PAMI. The polymers were produced using materials BA and PP. The production was run 3 times. The \(y\) values...
Study smarter with the SolutionInn App