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;
}}}