(1)CREATE TABLE Student(Sno CHAR(6)PRIMARY KEY,SnameVARCHAR(12),Ssex CHAR(2),Sage INT,Sdept VARCHAR(16));

(2)INSERT INTO course VALUES(k106',程序设计基础，陈瑞，100);

(3)DELETE FROM Student WHERE Sdept='生命科学AND Ssex='男；

(4)UPDATE SC SET Grade=Grade+10 WHERE Cno='S316;