Exam 8: Data Abstractions

Which of the following data mining techniques would be applied when trying to identify any underlying heterogeneity within housing patterns in a community?

Place an X in the space before those requests below that require data mining techniques rather than traditional database techniques. Leave the other spaces blank. _____ Identify all shoppers who bought dog food last week. _____ Identify items that tend to be purchased by common shoppers. _____ Identify any correlation between time-of-day and items purchased. _____ Identify the items purchased during the first hour after opening the store.

Given the relation Employees containing the attributes Name, Address, and BirthDate, what question is answered by the following sequence of operations? Temp $\leftarrow$ SELECT from Employees where BirthDate < "January 4, 1975" Result $\leftarrow$ PROJECT Name from Temp ________________________________

Which of the following data mining techniques would be applied when trying to identify traits that predict whether a citizen in a democracy will or will not vote?

Given the relation Parts containing the attributes PartName, PartNumber, and SupplierID as well as the relation Suppliers containing the attributes SupplierID, Address, FaxNumber, write a sequence of SELECT, PROJECT, and JOIN operations to obtain the supplier identifications and fax numbers for all the suppliers that supply the part whose part number is X4J26.

Given the relation below what values will be retrieved by the following SQL statement? select A, B From X Where X.B = X.C

Which of the following data mining techniques would be applied when trying to identify traits that characterize the citizens of a democracy who fail to vote?

In a relational database, information is presented as though it were stored in tables called _________________ , each of which has columns called _________________ and rows called _________________ .

Given the two relations X and Y below what value would be retrieved by executing the following SQL statement? select Y.C From X, Y Where X.A < Y.D

Translate the following query into a single SQL statement.

Which of the following file structures is commonly used for the storage of text files?

Given the relation Parts containing the attributes PartName, PartNumber, and SupplierID as well as the relation Suppliers containing the attributes SupplierID, Address, FaxNumber, write an SQL statement to obtain the supplier identifications and fax numbers for all the suppliers that supply the part whose part number is X4J26.

Describe the wound-wait protocol.

Which of the following is not a potential problem caused by multiple transactions manipulating a database at the same time?

Place an X in the space before those questions whose answers might be obtained by means of outlier analysis. Leave the other spaces blank. _____ Which are the flawed parts on a production line conveyor belt? _____ What items have not sold during the last two days? _____ What sales region generated the most orders over the last sales period? _____ Which shoppers in a busy shopping mall are potential shoplifters?

If a database contained a relation containing information about individual people (name, address, birthday, etc.) and another relation containing information about music composers (name, style, education level, etc.), how would you extend the database's design to include links between each individual and his or her favorite composer?

List four data mining techniques. _____________________ _____________________ _____________________ _____________________

Which of the following file structures is most efficient in cases in which the file is always processed in its entirety a predetermined order?

Which of the following accesses a database in terms of a database model?

Describe a scenario in which computing the total deposits in a bank while also transferring $100 from account X to account Y would result in a final sum that is $100 too great. Then describe a scenario in which the final sum turns out to be $100 too small.