2.sql

大学时做的数据库实验

use student_class
create table Student
(
sclass varchar(2),--班级
sno varchar(2),--学号
sname varchar(10) not null,--姓名
ssex varchar(2) check(ssex in('男','女')),--性别,将性别限制为男女
sage int ,--年龄
sdept varchar(5),--系别
primary key(sno,sclass)
)
insert into Student(sclass,sno,sname,ssex,sage,sdept)
values(1,1,'李勇','男',20 ,'IS') 
insert into Student(sclass,sno,sname,ssex,sage,sdept)
values(1,2,'刘晨','女',19 ,'IS') 
insert into Student(sclass,sno,sname,ssex,sage,sdept)
values(1,3,'刘朋','男',20 ,'IS') 
insert into Student(sclass,sno,sname,ssex,sage,sdept)
values(2,1,'王敏','女',18 ,'MA') 
insert into Student(sclass,sno,sname,ssex,sage,sdept)
values(2,2,'张锋','男',19 ,'MA') 
insert into Student(sclass,sno,sname,ssex,sage,sdept)
values(2,3,'李敏','男',20 ,'MA')