Given the following relation: Faculty (fname, title, departm…

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 mean prices of houses in a particular Clarksville neighb…

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 second-grade students at Harrison Elementary School go o…

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?