CREATE TABLE STUDENT(
Sno CHAR(9) PRIMARY KEY,
Sname CHAR(20) UNIQUE,
Ssex CHAR(2),
Sage CHAR(3),
Sdept CHAR(20)
);
CREATE TABLE Course(
Cno CHAR(4) PRIMARY KEY,
Cname CHAR(40),
Cpno CHAR(4),
Ccredit SMALLINT,
FOREIGN KEY (Cpno) REFERENCES Course(Cno)
);
CREATE TABLE SC(
Sno CHAR(9),
Cno CHAR(4),
Grade SMALLINT,
PRIMARY KEY(Sno,Cno),
FOREIGN KEY (Sno) REFERENCES Student(Sno),
FOREIGN KEY (Cno) REFERENCES Course(Cno)
);
ALTER TABLE Student
ADD S_entrance DATETIME;
ALTER TABLE Student
DROP COLUMN Sage;
ALTER TABLE Student
ADD Sage INT;
ALTER TABLE Student
DROP COLUMN S_entrance;
ALTER TABLE Student
ADD CHECK(Sage BETWEEN 15 AND 40);
CREATE UNIQUE INDEX Stusno ON Student(Sno);
CREATE UNIQUE INDEX Coucno ON Course(Cno);
CREATE UNIQUE INDEX SCno ON SC(Sno ASC ,Cno DESC);
DROP INDEX Student.Stusno;
DROP INDEX Course.Coucno;
DROP INDEX SC.SCno;