数据库第四次作业

create database mydb15_indexstu;
use mydb15_indexstu;

create table student( sno int primary key auto_increment, sname varchar(30) not null unique,ssex varchar(2)check (ssex='男'or ssex='女')not null,sage int not null,sdept varchar(10) default'计算机 'not null);

create table course(cno int primary key not null, cname varchar(20) not null);

create table sc(sno int not null, cno varchar(10) primary key not null, score int not null);

 #1

alter table student modify sage smallint not null ;

#2???
create unique index my_index on course(cno);
show index from course;

#3???
create unique index sc_index on sc (sno asc ,cno asc );
show index from sc;

#4
create or replace view stu_info as select mydb15_indexstu.student.sname,mydb15_indexstu.student.ssex,mydb15_indexstu.course.cname,sc.score from student join course on mydb15_indexstu.student.sname = course.cname join sc on  sc.cno = course.cno;

#5
drop index sc_index on sc;
drop index my_index on course;