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. The estimate of number of records for searching department name = “Biology” where “Biology” is a primary key in table Department = _______