Computer Science > QUESTIONS & ANSWERS > Illinois Institute Of TechnologyCS 101Homework2_Solution (All)
Homework 2 Solution 1. Sampling (20 points) Exercise 4.2.1 : 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 university (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/15th 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. (a) For each university, estimate the average number of courses per university. (b) Estimate the fraction of students who have a GPA of 3.7 or more. Solution [Show More]
Last updated: 3 years ago
Preview 1 out of 5 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Can't find what you want? Try our AI powered Search
Connected school, study & course
About the document
Uploaded On
Jun 23, 2021
Number of pages
5
Written in
All
This document has been written for:
Uploaded
Jun 23, 2021
Downloads
0
Views
53
Scholarfriends.com Online Platform by Browsegrades Inc. 651N South Broad St, Middletown DE. United States.
We're available through e-mail, Twitter, and live chat.
FAQ
Questions? Leave a message!
Copyright © Scholarfriends · High quality services·