CREATE TABLE Dept
(Dno CHAR(9) PRIMARY KEY,
Dname CHAR(20),
Mname CHAR(20),
Tel CHAR(20)
);
CREATE TABLE Staff
(Sno CHAR(9) PRIMARY KEY,
Sname CHAR(20),
Ssex CHAR(2),
Sage SMALLINT,
CONSTRAINT C1 CHECK(Sage<=60)
Post CHAR(20),
Pay CHAR(20),
Dno CHAR(9),
FOREIGN KEY (Dno) REFERENCES Dept(Dno)
);
2.对学生-课程数据库编写存储过程, 完成下述功能
/*在SC表中添加相应离散数学学生的信息*/
INSERT INTO Course VALUES(9,'离散',NULL,2);
INSERT INTO SC VALUES('20121512',9,12);
INSERT INTO SC VALUES('201215122',9,22)