【数据库】实验一 建表 和 插入

create table studednt(
	Sno int PRIMARY KEY,
	Sname VARCHAR(10),
	Ssex VARCHAR(5),
	Ssage int,
	Sdept VARCHAR(10)
);

INSERT INTO student  VALUES 
(95002,'刘晨','女',21,'IS'),
(95003,'王敏','女',18,'MA'),
(95004,'张力','男',19,'IS')

CREATE TABLE Course(
	Cno int primary key,
	Cname VARCHAR(20),
	Cpno int,
	Ccredit int
);

INSERT INTO course  VALUES 
(1,'数据库',5,4),
(2,'数学',NULL,2),
(3,'信息系统',1,4),
(4,'操作系统',6,3),
(5,'数据结构',7,4),
(6,'数据处理',NULL,2),
(7,'PASCAL语言',6,4)

create table sc(
	Sno int,
	Cno int,
	grade int,
	PRIMARY KEY(Sno,Cno),

	CONSTRAINT Cno FOREIGN key (Cno) References course (Cno),
	CONSTRAINT Sno Foreign key(Sno) References student(Sno)
)

INSERT INTO SC VALUES
(95001,1,92),
(95001,2,85),
(95001,3,88),
(95002,2,90),
(95003,3,85)