There are four relations as follows: Student (id(PK), name,…

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…

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 =        

In class we replicated the McDaniels et al. (2014) Builders…

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?