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

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

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