Estimate the average number of students in a course

Assignment Help Basic Computer Science
Reference no: EM131215028

Suppose we have a stream of tuples with the schema

336_30c283d0-f233-41d9-bc0c-bab131e16eb0.png

Assume universities are unique, but a course ID is unique only within a university (i.e., different universities may have different courses with the same ID, e.g., "CS101") and likewise, student ID'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.

(a) For each university, estimate the average number of students in a course.

(b) Estimate the fraction of students who have a GPA of 3.5 or more.

(c) Estimate the fraction of courses where at least half the students got "A."

Reference no: EM131215028

Questions Cloud

Recognise the importance of bloom taxonomy : By the end of this topic you should be able to.. Describe difference between educational aims & learning  outcomes and Explain the importance of learning outcomes
How many times each word has occurred in the text file : The values in this dictionary should be a count of how many times each word has occurred in the text file. Second, add the word into a data structure that is keeping track of word information for the completion process.
Swapping the processes : What are conditions on which deadlock can occur while swapping the processes?
Accomplish my goals sincerely : 1. Overview of the companies you learned about 2. Profile of your selections and the reasons you chose them 3. Summary of why you believe this will help me accomplish my goals Sincerely,Harrison Kirby
Estimate the average number of students in a course : For each university, estimate the average number of students in a course.
Data of the current instruction : What holds the data of the current instruction then copies it to the IR. I think its connected to data bus's?
Determine the best predictors of the emotional intelligence : Describe the statistical analyses used and the multiple regression that is best suited for this type of measurement. Determine the best predictors of the emotional intelligence (EI) test scores. Identify other external variables that could influence ..
Motives for e-attacks on information networks : What are some of the motives for e-attacks on information networks? Have attackers and their motives changed over time? If so, what have been the implications of these changes in terms of outcomes,
Create a mind-map with your life at its centre : CVE80010: Principles of Sustainability - identify a few diverse aspects of your life from which you can start tracing to environmental impacts from. Maybe it's your house or apartment; maybe your choices at the supermarket; or maybe it's flying h..

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Problem regarding the constant-growth model

From the constant-growth model, the amount of internally-funded growth is 12.5% and a maximum P/E ratio of 20 would be paid for Merck under these circumstances.

  Discuss the different types of transaction failures

Discuss the different types of transaction failures. What is meant by catastrophic failure?

  Compare the benefits of the virtualization computing tech

Compare the benefits of the virtualization computing technology with past successful or unsuccessful telecommunications technologies you have in place. With four references.

  The proliferation of mobility and mobile applications

Instructions: The proliferation of mobility and mobile applications in enterprise networks has increased the importance of mobile VPNs to provide secure communication channels to support mobile users in a wide variety of organizations

  Finding a mincost maxflow of the new network

These flows all have the same (maximal) value, but their costs (the sum of the products of edge flows and edge costs) differ. The maxflow in the center has minimal cost (no maxflow has lower cost).

  Analyze faster processor chip result increase in performance

Analyze the following statement: "Using the faster processor chip results in corresponding increase in performance of a computer even if main memory speed remains same."

  Current design model of it

In the current design model of IT service provision at NSI, the service desk function is provided in-house by TAFE employees. Consider the option of outsourcing the service desk.

  Describe and contrast maintenance and validation

Describe and contrast maintenance and validation techniques.

  Determine the smallest lever force p

Determine the smallest lever force P needed to prevent the wheel from rotating if it is subjected to a torque of M = 250 N .m The coefficient of static friction between the belt and the wheel is µs = 0.3.

  How many interleavings of transactions are serializable

If the order of incrementation in T2 were reversed [i.e., inc2 (B) followed by inc2 {A)], how many serializable interleavings would there be?

  Two instance variables

Two instance variables

  What is percentage of time processor is blocked due to dma

Consider a device of 50MBPS is operated in cycle stealing mode of DMA as and when 8byte word is available. It is transferred into the memory in 40ns. What is the percentage of time processor is blocked due to DMA.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd