Blog

Given the following relation: Faculty (fname, title, department, address). Suppose each tuple is 40 bytes long, 100 tuple per page, and the relation contains 1,000 pages. Considering the following query: Select title, fname from Faculty E where E.title=’Professor’. Suppose that a B+tree index on department is the only index of the relation. There are 5 different department stored in the table. What is the estimated reduction factor of the query condition.

The graph shows the number of students in each of Marie’s classes. Marie’s Chorus class has how many more students than her Science class?

Determine whether the number describes a population parameter or a sample statistic: The freshman class at a university has an average SAT math score of 514.

A data display that is appropriate for categorical data is:

Use a graphing calculator to find the equation for the line of best fit for the data in the table. 

The mean prices of houses in a particular Clarksville neighborhood is $360,000, with a median price of $355,000. Someone purchased a large plot of land and constructed a substantial house valued at $540,000. How will the value of the new home affect the values of all homes in the nieghborhood?

The team score 80 points. How many points did Garrett score?

The second-grade students at Harrison Elementary School go on an apple-picking field trip. When they return, they create a pictograph showing the number of apples each class picked. The second-grade students altogether pick a total of 210 apples. How many apple symbols should go next to Mrs. Quill’s class? 

The median of the data set in the graph is:

Salespeople who are internal pioneers of new technology are usually annoying to their manager.