mysql第四次作业

(1)

alter table student change sno sno smallint;

(2)

 create index Cno_index on Course(Cno);

(3)

create unique index sc_index on sc(sno , cno asc);

(4)

create view stu_info as select Sname ,Ssex,Cname,Score from student join sc on student.sno=sc.sno join course on course.cno = sc.cno;

(5)

 drop index cno_index on course;
drop index sc_index on sc;