/* Transcript view */
CREATE OR REPLACE VIEW transcript AS
SELECT
	student.name,
	course.course_number,
	grade_report.grade,
	section.semester,
	section.year,
	section.section_identifier AS 'section_id'
FROM
	student
	INNER JOIN grade_report ON grade_report.student_number = student.student_number
	INNER JOIN section ON section.section_identifier = grade_report.section_identifier
	INNER JOIN course ON course.course_number = section.course_number;

/* Course prerequisites view */
CREATE OR REPLACE VIEW course_prerequisites AS
SELECT
	course.course_name,
	prerequisite.course_number,
	prerequisite.prerequisite_number AS 'prerequisites'
FROM
	course
	INNER JOIN prerequisite ON prerequisite.course_number = course.course_number
