学生-课程数据库（Student course database）.docVIP

学生-课程数据库（Student course database） SQL query review questions New students - three tables of the course database: Student table: Student (Sno, Sname, Ssex, Sage, Sdept) Sno as the main code; Courses: Course (Cno, Cname, Cpno, Credeit) Cno based code; Student elective form: SC (Sno, Cno, Grade), Sno, Cno, main yards; Student No. Sno name Sname sex Ssex age Sage Department Sdept 95001 Li Yongnan 20CS 95002 Liu Chen female 19IS 95003 Wang Minnv 18MA 95004 Zhang Linan 19IS Course number Sno course name Cname advance lesson Cpno credits Credit 1 database 54 2 math 2 3 information systems 14 4 operat