Blog

What should a phlebotomist do if a patient experiences a hematoma during a venipuncture?

Which type of consent is required for emergency treatment when the patient is unconscious and unable to give consent?

Given a relation: Student (SID, SName, major, age, city). The data file contains 1000 pages and each page contains 100 tuples. Suppose there is a B+tree index on city and it is unclustered. There are 100 different cities stored in the table and uniform distribution is assumed for the values. The index file contains 20 pages. Given the query: Select * from Student where city=”Rochester”, which of the query plan is more efficient?

The Human Resources Department at Corporation ABC uses the salaries of 200 of its 1200 employees to determine an average salary. Identify the population in this scenario.

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?