CREATE VIEW score_view (student_id,student_name,course_name,score,course_credit)
AS SELECT score.student_id,student_name,course_name,score,course_credit
FROM course,score,student
WHERE student.student_id=score.student_id AND course.course_id=score.course_id;