Blog

There are four relations as follows: Student (id(PK), name, dept_name(FK), gpa, major, phone, advisor_name) Department (dept_name(PK), building, budget) Takes (id(PK, FK), course_id(PK, FK), sec_id(PK, FK), semester(PK, FK), year(PK, FK) , grade) Course (course_id(PK), title, dept_name(FK), credit_hours) Note.  PK = Primary key, and FK = Foreign key. Given: the number of records in table Student = 1,000.              the number of records in table Course = 100.              the number of records in table Takes = 5,000.              the number of records in table Department = 10.   Given Student.id Ո Takes.id = . What is the estimate of number records for Student  Takes =  _______

Consider the join operation between relation r and s ( sθ  r ),  θ  is  r.A = s.B with the following information: Relation r contains 6,000 tuples and has 12 tuples per block. Relation s contains 5,000 tuples and has 5 tuples per block. There are 33 buffer blocks available in Memory. V(A, r) = 6,000 and V(B, s) = 5,000.          Find total cost (the number of block transfers) using Block Nested Loop Join =        

T1 deletes 0044.    What are operations for each timeline (t1, t2 and t3)? t1 A t2 B t3 C A _______ B _______ C _______

On the whole, when comparing prototype and exemplar theories of categorization, which theories do a better job of capturing human categorization performance? 

_________ memories are those that are typically spared in patientis with anterograde amnesia and are not associated with conscious recall in neurologically unimpaired people.

In a lexical decision task participants respond fastest when:

Analogies are

Treisman’s attenuation model explains the cocktail party effect through:

In class we replicated the McDaniels et al. (2014) Builders and Diggers category learning experiment. Half of the class learned to categorize Builder and Digger animals using a simple rule, while the other half focused on perceptual similarities. At test, new animals of two types were presented: good transfer items and bad transfer items. Good transfer items were perceptually similar to the category for whom the rule applied. Bad transfer items met the rule for belonging to one category, but were more perceptually similar to the other category. What was the pattern of reuslts in this experiment? 

Murphy & Allopenna’s (1994) finding that causal categories are learned faster than arbitrary ones supports: