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
Ajournal bearing has a journal diameter of 3.250 in with a unilateral tolerance of 20.003 in. the bushing bore has a diameter of 3.256 in and a unilateral tolerance of 0.004 in. the bushing is 2.8 in long and supports a 700-lbf load. the journal speed is 900 rev/min. find the minimum oil film thickness and the maximum film pressure for both sae 20 and sae 20w-30 lubricants, for the tightest assembly if the operating film temperature is 160°f. a computer code is appropriate for solving this problem.
Answers: 3
question
Engineering, 04.07.2019 18:20
Vibration monitoring this technique uses the noise or vibration created by mechanical equipment and in seme cases by plant systems to detemine their actual condtion. a)- true b)- false
Answers: 2
question
Engineering, 04.07.2019 18:20
Aquick transition of the operating speed of a shaft from its critical speed will whirl amplitude. (a) increase (b) limit (c) not affect (d) zero
Answers: 2
question
Engineering, 04.07.2019 18:20
Avolume of 2.65 m3 of air in a rigid, insulated container fitted with a paddle wheel is initially at 264 k, 5.6 bar. the air receives 432 kj by work from the paddle wheel. assuming the ideal gas model with cv = 0.71 kj/kg • k, determine for the air the amount of entropy produced, in kj/k
Answers: 2
You know the right answer?
Suppose we have a stream of tuples with the schema grades(university, courseid, studentid, grade) as...
Questions
question
Mathematics, 17.01.2021 17:40
question
Social Studies, 17.01.2021 17:40
question
English, 17.01.2021 17:40
question
English, 17.01.2021 17:40
question
Biology, 17.01.2021 17:40
question
Chemistry, 17.01.2021 17:50
question
History, 17.01.2021 17:50
question
Mathematics, 17.01.2021 17:50
Questions on the website: 13722361