Schema Department (dept id, dept name, budget) Course (course_id, title, credits, dept_id, prerequisite) Faculty (faculty_id, name, room_id, dept_id, salary) Student fstudent_id, last _name , first_name, street, city, state, zip, birth date, major_id, phone, student type) Term {term id, term desc , start_date , end date} Section section id, course_id , section_number, term_id, faculty_id , day, max_count, start time end time, room id} Registration {student id, section id , midterm grade, final grade) Major {major_id , major desc) Location (room id, building, room_no, capacity, room_ type , room_description) Schema Department (dept id, dept name, budget) Course (course_id, title, credits, dept_id, prerequisite) Faculty (faculty_id, name, room_id, dept_id, salary) Student fstudent_id, last _name , first_name, street, city, state, zip, birth date, major_id, phone, student type) Term {term id, term desc , start_date , end date} Section section id, course_id , section_number, term_id, faculty_id , day, max_count, start time end time, room id} Registration {student id, section id , midterm grade, final grade) Major {major_id , major desc) Location (room id, building, room_no, capacity, room_ type , room_description)