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, 04.07.2019 18:10
The temperature of air decreases as it is compressed by an adiabatic compressor. a)- true b)- false
Answers: 2
question
Engineering, 04.07.2019 18:10
Air is to be cooled in the evaporator section of a refrigerator by passing it over a bank of 0.8-cm-outer-diameter and 0.4-m-long tubes inside which the refrigerant is evaporating at -20°c. air approaches the tube bank in the normal direction at 0°c and 1 atm with a mean velocity of 4 m/s. the tubes are arranged in-line with longitudinal and transverse pitches of sl- st 1.5 cm. there are 30 rows in the flow direction with 15 tubes in each row. determine (a) the refrigeration capacity of this system and (b) pressure drop across the tube bank. evaluate the air properties at an assumed mean temperature of -5°c and 1 atm. is this a good assumption?
Answers: 1
question
Engineering, 04.07.2019 18:10
Ariver flows from north to south at 8 km/h. a boat is to cross this river from west to east at a speed of 20 km/h (speed of the boat with respect to the earth/ground). at what angle (in degrees) must the boat be pointed upstream such that it will proceed directly across the river (hint: find the speed of the boat with respect to water/river)? a 288 b. 21.8 c. 326 d. 30.2
Answers: 3
question
Engineering, 04.07.2019 18:10
Items are similar to the free issue items, but their access is limited. (clo5) a)-bin stock items free issue b)-bin stock controlled issue c)-critical or insurance spares d)-rebuildable spares e)-consumables
Answers: 1
You know the right answer?
Suppose we have a stream of tuples with the schema grades(university, courseid, studentid, grade) as...
Questions
question
Mathematics, 18.11.2020 20:50
question
Mathematics, 18.11.2020 20:50