View Example
CREATE VIEW StudentInstructorSection AS
SELECT st.ID as s_ID, st.dept_name AS s_dept_name,
st.name AS s_name, st.tot_cred,
se.course_id, se.sec_id, se.year, se.semester,
se.building, se.room_number, se.time_slot_id,
i.ID AS i_ID, i.name AS i_name, i.salary,
i.dept_name AS i_dept_name
FROM student st, takes ta, section se, teaches te, instructor i
WHERE st.ID=ta.ID AND
ta.course_id=se.course_id AND
ta.sec_id=se.sec_id AND
ta.year = se.year AND
ta.semester = se.semester AND
te.course_id=se.course_id AND
te.sec_id=se.sec_id AND
te.year = se.year AND
te.semester = se.semester AND
te.ID = i.ID;