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

Other questions on the subject: Engineering

image
Engineering, 04.07.2019 18:10, genyjoannerubiera
Assuming compressible flow of air and that the measurements are done at flagstaff a pitot static tube that gives the difference of total and static pressure measures 0.35 m of mercury. what is the velocity of air? assume the temperature to be 300k. (submit your excel or matlab calculation sheet)
Answers: 1
image
Engineering, 04.07.2019 18:20, cdyshaylia55
Water vapor initially at 10 bar and 400 °c is contained within a piston-cylinder assembly. the water lost heat to the surrounding according to isochoric (iso-volumetric) process until its temperature is 150 °c. the water is then condensed isothermally to saturated liquid. for the water as a system, calculate the work in kj/kg
Answers: 2
image
Engineering, 04.07.2019 19:10, jrcspiderman2003
Asteel wire of 2 mm diameter is fixed between two points located 2 m apart. the tensile force in the wire is 250n, if its density of steel is given by 7830 kg/m3 the fundamental frequency of vibration hz? ?
Answers: 3
image
Engineering, 04.07.2019 19:10, lexie223
Acircular aluminum shaft mounted in a journal is shown. the symmetric clearance gap between the shaft and journal is filled with sae 10w-30 oil at t 30°c. the shaft is caused to turn by the attached mass and cord. develop and solve a differential equation for the angular speed of the shaft as a function of time.
Answers: 2
You know the right answer?
Suppose we have a stream of tuples with the schema grades(university, courseid, studentid, grade) as...

Questions in other subjects:

Konu
Spanish, 12.11.2019 07:31