You are designing a system to crowdsource student evaluations of college courses. As part of this...
Fantastic news! We've located the answer you've been seeking!
Question:
Transcribed Image Text:
You are designing a system to crowdsource student evaluations of college courses. As part of this system, you want to store a table of reviews containing the following information (for each review): • Review Date  Date (3 bytes) • Academic Year  int32 • Academic Quarter  char[10] • Course IDchar[5] • Rating (0.0 to 5.0)  float32 • Grade in the course  char[2] • Estimated Hours Per Week  int32 • Review (text)  char[224] Question 2.1 What is the size of each row in bytes? Question 2.2 Assume that this data is stored on a HDD in 64MB IO blocks and these blocks are grouped in 2x64MB 10 blocks. How many rows can be stored per 64MB 10 block? Question 2.3 How many 2x64MB blocks would you need to store 2 million rows? Question 2.4 Relevant information: • According to the registrar, this quarter there are 16500 students (undergrad and graduate) enrolled. • Of these, about 1500 are grad students finishing their degree, which will be excluded. • Of the remainder, some are grad students who might be doing research fulltime and not taking classes. Let's consider this and approximate that there are exactly 15,000 classtaking students at Stanford. • Let's assume that on average each classtaking student takes 3 classes per semester (including the summer semester). • Let us also assume that writing course evaluations is optional and 50% of students who take a course will write an evaluation. (Note: If a student chooses not to write an evaluation, no row is added to the table.) After 10 years (30 semesters), how large in MB will the table of course reviews be? Round your answer to 1 decimal place. Question 2.5 Q2.52.7 follow from 2.4. How many 64MB blocks would be needed to store the table of course reviews? Question 2.6 Now, let's say you would like to read from your table and retrieve a particular evaluation (row). Let's make the following assumptions about the hardware that is used to store the table: • Your data is all stored on HDDs • Use the numbers given in the notes/instructions for all calculations. How long would it take in hours to retrieve an evaluation (row) if the table rows are stored randomly on HDD (we must access and scan every row)? Round your answer to 1 decimal place. Question 2.7 How long would it take in seconds if the rows are grouped in 64MB blocks (which are randomly stored on HDD)? Note: in your calculations, please use a whole number of blocks (round up: e.g. 16.1 blocks → 17 blocks).
Expert Answer:
Answer rating: 100% (QA)
Question 2 1 Size of each row in bytes Review Date 3 bytes assuming a standard date format Academic Year 4 bytes int32 Academic Quarter 10 bytes char 10 Course ID 5 bytes char 5 Rating 4 bytes float32 View the full answer
Related Book For
Project Management The Managerial Process
ISBN: 9781260570434
8th Edition
Authors: Eric W Larson, Clifford F. Gray
Posted Date:
Students also viewed these databases questions

List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...

You are designing a system that must have reliability at least 0.95 at 10,000 hours of operation. If you can reasonably assume that the time to failure is exponential, what MTTF must you achieve in...

The following table describes a randomized trial comparing an experimental medication to a placebo for treatment of reflux. Experimental Treatment Placebo (n = 100) Patient Characteristics (n = 100)...

How are cost center managers commonly evaluated?

Civil engineering consulting firms that provide services to outlying communities are vulnerable to a number of factors that affect the financial condition of the communities, such as bond issues and...

The 8bit ASCII word Bye is to be transmitted to a device address 39 and endpoint 2. List the Output and Data 0 packets and the Handshake packet for a Stall for this transmission prior to NRZI...

1. Do you consider Numis relationships with its producers as important to its marketing as the relationships with its customers? 2. How does Numi use technology to enhance its customer relationships?...

Read the following link and answer the following describe the activities of the Supervisory Board of Daimler AG, which were related to supervision, working culture, corporate governance, and audit of...

Erica and Bob participate in a friendly Hackathon that allows each to solve one question a day out of the three offered. There will be one easy, one medium and one hard question, with points awarded...

According to the National Center for Education Statistics, 57% of the students at the College of DuPage in Glen Ellyn, Illinois, are male. A random sample of 10 students from the College of DuPage is...

Identify the arrangement (I, II, or III; all molecules are CH 2 Cl 2 ) that should possess the strongest intermolecular attractions, and justify your selection. H II III

In Problems 1528, find the area bounded by the graphs of the indicated equations over the given interval. Compute answers to three decimal places. y = x + 2; y = 0;0 x 3

Explain why f(x, y) = x 2 has a local extremum at infinitely many points.

In Problems 6166, find f xx (x, y), fry (x, y), f yx (x, y), and f yy (x, y) for each function f. f(x, y) = x 2 y 2 + x 3 + y

In Problems 3142, find the indicated secondorder partial derivative for each function f(x, y). fyy(x, y) if f(x, y) = (1 + 2xy)8

On the day of their surgery, each patient goes through several activities as shown in the table below. The number of parallel stations shown are based on the fraction of available capacity dedicated...

Use a calculator to evaluate the expression. Round your result to the nearest thousandth. V (32 + #)

How important is a fun culture for innovation?

Ken Buttrey scratched his head as he looked over an email from John Barbata. Ken was the team lead on the Jasper Jones project. He and 13 other developers were charged with creating Jasper Jones...

Safety is a major concern when working on projects abroad. Select a country that you would consider dangerous to work in and look up the travel advisory provided for that country by the U.S. State...

Generally, it is acceptable for an allfemale fitness center to hire only female fitness instructors based on indications of customer preference and on privacy concerns. True or False

The Age Discrimination in Employment Act (ADEA) protects against employment discrimination based on the notion that an employee is either too old or too young. True or False

It will likely be harder for a male coach of a collegiate womens basketball team than a female coach to attempt to win a lawsuit that seeks pay equal to that of the person coaching the mens...
Question Categories