数据库系统概论实验01交互式SQL..docVIP

（一）数据定义 CREATE TABLE Student (SNO INT PRIMARY KEY, SNAME CHAR(8) NOT NULL, SEX CHAR(2), DEPTNO INT); CREATE TABLE Course (CNO INT, CNAME CHAR(20) NOT NULL, TNO INT, CREDIT INT, PRIMARY KEY(CNO,TNO)); CREATE TABLE SC (SNO INT, CNO INT, GRADE INT, PRIMARY KEY(SNO,CNO)); CREATE TABLE Teacher (TNO INT PRIMARY KEY, TNAME CHAR(8) NOT NULL, DEPTNO INT); CREATE TABLE Dept (DEPTNO INT PRIMARY KEY, DNAME CHAR(20) NOT NULL); ALTER TABLE Student ADD SAGE INT; ALTER TABLE Student ALTER COLUMN SAGE SMALLINT; DROP TABLE Student; DROP TABLE