subject
Engineering, 22.11.2019 05:31 kharmaculpepper

Suppose we have a stream of tuples with the schema grades(university, courseid, studentid, grade) assume universities are unique, but a courseid is unique only within a uni- versity (i. e., different universities may have different courses with the same id, e. g., "cs101") and likewise, studentid’s are unique only within a university (different universities may assign the same id to different students). suppose we want to answer certain queries approximately from a 1/20th sample of the data. for each of the queries below, indicate how you would construct the sample. that is, tell what the key attributes should be. that is, tell what the key attributes should be.
(a) estimate the average number of courses per university.
(b) estimate the fraction of students who have a gpa of 3.7 or more.
explain briefly but clearly how you will create the sample and why.

ansver
Answers: 3

Another question on Engineering

question
Engineering, 03.07.2019 14:10
The y form of iron is known as: a) ferrite b) cementite c) perlite d) austenite
Answers: 3
question
Engineering, 04.07.2019 18:20
Find the kinematic pressure of 160kpa. for air, r-287 j/ kg k. and hair al viscosity of air at a temperature of 50°c and an absolute (10 points) (b) find the dynamic viscosity of air at 110 °c. sutherland constant for air is 111k
Answers: 3
question
Engineering, 04.07.2019 19:10
With increases in magnification, which of the following occur? a. the field of view decreases. b. the ambient illumination decreases. c. the larger parts can be measured. d. the eyepiece must be raised.
Answers: 1
question
Engineering, 06.07.2019 03:10
Two slings are used to lift a girder of length l and uniform weight per unit length. what is the best position for the slings if the bending moment due to the weight of the girder is to be kept to a minimum?
Answers: 2
You know the right answer?
Suppose we have a stream of tuples with the schema grades(university, courseid, studentid, grade) as...
Questions
Questions on the website: 13722367