quiz4Sec3 - CS351/Sec. 3 Quiz No. 4 Nov. 30, 2005 Consider...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
CS351/Sec. 3 Quiz No. 4 Nov. 30, 2005 Consider a student file with the following attributes: StNo, Major, Status, DOB. n= 20,000 (no. of records). Selectivities of the Major and Status attributes are given as follows. Major Selectivity Status Selectivity CS 0.20 Prob 0.15 Music 0.30 Satis. 0.50 Business 0.15 Honor 0.20 Other 0.35 H. Honor 0.15 Assume that the values of the attributes are independent of each other. (Note: selectivity means the probability of observing a certain attribute value for a randomly chosen record.) Estimate the number of students that will satisfy the following queries.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/01/2011 for the course CS 351 taught by Professor Fazlıcan during the Spring '11 term at Bilkent University.

Ask a homework question - tutors are online