create database teach;
use teach;
create table student(
sno char(5) primary key,
sname varchar(20) unique,
ssex char(1),
sage int,
sdept varchar(15));
insert into student values(95001,'李勇','M',20,'CS');
insert into student values(95002,'刘晨','F',19,'IS');
insert into student values(95003,'王名','F',18,'MA');
insert into student values(95004,'张立','M',18,'IS');
create table course(
cno int primary key,
cname varchar(20),
cpno int,
ccredit tinyint check(ccredit between 1 and 4));
insert into course values(1,'数据库',5,4);
insert into course values(2,'数学',null,2);
insert into course values(3,'信息系统',1,4);
insert into course values(4,'操作系统',6,3);
insert into course values(5,'数据结构',7,4);
insert into course values(6,'数据处理',null,2);
insert into course values(77,'C语言',6,4);
create table sc(
sno char(5) not null,
cno int not null,
grade decimal(8,1));
insert into sc values(95001,1,92.0);
insert into sc values(95001,2,85.0);
insert into sc values(95001,3,88.0);
insert into sc values(95002,2,90.0);
insert into sc values(95002,3,80.0);
select * from student;
select * from course;
select * from sc;
结果