You are designing a system to crowdsource student evaluations of college courses. As part of this...
Fantastic news! We've Found the answer you've been seeking!
Question:
![You are designing a system to crowdsource student evaluations of college courses. As part of this system, you](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/09/6514116194aa4_1695813984172.jpg)
![Of the remainder, some are grad students who might be doing research full-time and not taking classes. Let's](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/09/6514116b1edd8_1695813993934.jpg)
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 ID-char[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 full-time and not taking classes. Let's consider this and approximate that there are exactly 15,000 class-taking students at Stanford. • Let's assume that on average each class-taking 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.5-2.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). 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 ID-char[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 full-time and not taking classes. Let's consider this and approximate that there are exactly 15,000 class-taking students at Stanford. • Let's assume that on average each class-taking 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.5-2.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 21 Size of each row in bytes Review Date 3 bytes assuming a standard date format Academic Year 4 bytes int32 Academic Quarter 10 bytes char10 Course ID 5 bytes char5 Rating 4 bytes float32 Gr... 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
-
Discuss the major policy controls of the Federal Reserve. Include in your discussion the relative effectiveness of open-market operations, the discount rate, and the legal reserve requirement.
-
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...
-
Find the extreme values of (x, y) = x 2 + 2y 2 subject to the constraint g(x, y) = 4x 6y = 25. (a) Show that the Lagrange equations yield 2x = 42, 4y = -62. (b) Show that if x = 0 or y = 0, then the...
-
Consider an ANOVA table of the following form. Use a = .05 for all parts of this problem. In each case, decide what effects (if any) are significant, and what conclusions to draw, based on a two-way...
-
Exercises 4749 will help you prepare for the material covered in the next section. In each exercise, graph the functions in parts (a) and (b) in the same rectangular coordinate system. a. Graph f(x)...
-
Personal probability versus data. Give an example in which you would rely on a probability found as a long-term proportion from data on many trials. Give an example in which you would rely on your...
-
Chain AB supports a horizontal, uniform steel beam having a mass per unit length of 85 kg/m. If the maximum tension in the cable is not to exceed 8kN, determine (a) The horizontal distance a from A...
-
The controller of Ivanhoe Industries has collected the following monthly expense data for use in analyzing the cost behavior of maintenance costs. Total Maintenance Costs Total Machine Hours Month...
-
Bug-Off Exterminators provides pest control services and sells extermination products manufactured by other companies. The following six-column table contains the company's unadjusted trial balance...
-
In 2 0 0 5 , a shrine of what orisa was recognized as a UNESCO World Heritage Site? a . Olodumare b . Osun c . Orunmila d . Shango
-
What is a transistor, and what are its types?
-
Discuss the emerging role of nanotechnology in electrical engineering, focusing on its applications in enhancing electrical components like batteries, supercapacitors, and sensors.Explore the...
-
1. As resistors are added in parallel to an existing circuit, what happens to the voltage drop measured across each resistor? 2. In the circuit shown on the right, which path (left or right) will...
-
On November 1, Jesper Company loaned another company $110,000 at a 9.0% interest rate. The note receivable plus interest will not be collected unti March 1 of the following year. The company's annual...
-
What are the four types of poultry production systems? Explain each type.
-
How important is a fun culture for innovation?
-
Ken Buttrey scratched his head as he looked over an e-mail 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...
-
15. A primary government can be either a general purpose government or a special purpose government. What is the difference in these two? How does an activity qualify as a special purpose government?
-
17. What is the difference between a blended component unit and a discretely presented component unit?
-
16. The Willingham Museum qualifies as a component unit of the City of Willingham. How does an activity or function qualify to be a component unit of a primary government?
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App