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:20
What is the heat treatment of metals? what is the benefit of it? why and how it's useful? answer in details, do not write by hand.
Answers: 3
question
Engineering, 04.07.2019 19:10
Asteam is contained in a rigid tank with a volume of 1 m3. initially, the pressure and temperature are 7 bar and 500 oc, respectively. the temperature drops due to cooling process. determine: (1) the temperature at which condensation begins in °c, (2) the fraction of the total mass that has condensed when the pressure decreased to 0.5 bar. (3) the volume in m3 occupied by saturated liquid at the final state?
Answers: 3
question
Engineering, 04.07.2019 19:10
When subject to a steady load (within elastic range) over a long period of time, what is the major difference in material behavoir between steel and plastic?
Answers: 2
question
Engineering, 06.07.2019 03:10
Steel balls 12 mm in diameter are annealed by heating to 1150 k and then slowly cooled to 400 k in an air att 325 k and h -20 w/m2 k. assume the properties of the steel to be k- 40 w/m k,p 7800 kg/m3, and cp 600 j/kg k. a. determine whether lumped system method can be used to analyze this problem and if so why" b. determine the time required for the cooling process. c. determine the total amount of heat lost from each ball to the ambient air
Answers: 1
You know the right answer?
Suppose we have a stream of tuples with the schema grades(university, courseid, studentid, grade) as...
Questions