/*CREATE DATABASE JWGL AUTHORIZATION 张铭 数据库的创建*/
CREATE TABLE S /*建立基本表s*/
(SNO CHAR(9) PRIMARY KEY,
SNAME CHAR(20) UNIQUE,
SEX CHAR(1),
AGE SMALLINT,
SDEPT CHAR(20)
);
INSERT INTO S VALUES(200915121,'李小勇','M',20,'CS');
INSERT INTO S VALUES(200915122,'刘晨','F',19,'CS');
INSERT INTO S VALUES(200915123,'王洪敏','F',18,'MA');
INSERT INTO S VALUES(200915124,'张力','M',19,'IS');
drop table S;
/*建立基本表c*/
CREATE TABLE C
(CNO CHAR(4) PRIMARY KEY,
CNAME CHAR(40),
CPNO CHAR(4),
CCREDIT SMALLINT
);
INSERT INTO C VALUES('1','数据库','5',4);
INSERT INTO C VALUES('2','数学','',2);
INSERT INTO C VALUES('3','信息系统','1',4);
INSERT INTO C VALUES('4',
CREATE TABLE S /*建立基本表s*/
(SNO CHAR(9) PRIMARY KEY,
SNAME CHAR(20) UNIQUE,
SEX CHAR(1),
AGE SMALLINT,
SDEPT CHAR(20)
);
INSERT INTO S VALUES(200915121,'李小勇','M',20,'CS');
INSERT INTO S VALUES(200915122,'刘晨','F',19,'CS');
INSERT INTO S VALUES(200915123,'王洪敏','F',18,'MA');
INSERT INTO S VALUES(200915124,'张力','M',19,'IS');
drop table S;
/*建立基本表c*/
CREATE TABLE C
(CNO CHAR(4) PRIMARY KEY,
CNAME CHAR(40),
CPNO CHAR(4),
CCREDIT SMALLINT
);
INSERT INTO C VALUES('1','数据库','5',4);
INSERT INTO C VALUES('2','数学','',2);
INSERT INTO C VALUES('3','信息系统','1',4);
INSERT INTO C VALUES('4',