一、第四次作业
二、处理表
1、ALTER TABLE Student MODIFY COLUMN Sage SMALLINT;
2、CREATE INDEX idx_Course_Cno ON Course(Cno); SHOW INDEXES FROM Course;
3、ALTER TABLE SC ADD CONSTRAINT PK_SC PRIMARY KEY (Sno, Cno);
4、CREATE VIEW stu_info AS SELECT S.Sname, S.Ssex, C.Cname, SC.Score FROM Student S JOIN SC ON S.Sno = SC.Sno JOIN Course C ON C.Cno = SC.Cno;
5、ALTER TABLE Course DROP INDEX idx_Course_Cno;