Consider the relation schemas shown in Section below , which were generated from the E-R diagram. For each schema, specify what foreign key constraints, if any, should be created

"classroom(building,roomnumber,capacity)

department(deptname,building,budget)

course(courseid,title,credits)instructor(ID,name,salary)

student(ID,name,totcred)"

Transcribed Image Text:

course_id course_dept course course id title credits prereq instructor ID name salary prereq_id inst_dept teaches sec_course department dept_name building budget advisor section sec_id. semester Bear sec_class classroom building room number capacity stud_dept takes student ID name tot_cred sec_time_slot Figure 6.15 E-R diagram for a university enterprise. grade time_slot time slot id [day start_time end_time course_id course_dept course course id title credits prereq instructor ID name salary prereq_id inst_dept teaches sec_course department dept_name building budget advisor section sec_id. semester Bear sec_class classroom building room number capacity stud_dept takes student ID name tot_cred sec_time_slot Figure 6.15 E-R diagram for a university enterprise. grade time_slot time slot id [day start_time end_time