数据库初级练习

--创建学生表

create table student(
Sno int not null,
Sname varchar(10),
Sage int,
Ssex char(10),
Sdept varchar(10)
);

insert into student values
(9512101,'李勇',19,'男','计算机系')
(9512102,'刘晨',20,'男','计算机系')
(9512103,'王敏',20,'女','计算机系')
(9521101,'张立',22,'男','信息系')
(9521102,'吴斌',21,'女','信息系')
(9521103,'张海',20,'男','信息系')
(9531101,'钱小利',18,'女','数学系')
(9531102,'王大利',19,'男','数学系');

--课程表

create table course(
Cno varchar(10),
Cname varchar(10),
Hours int
)CHARACTER SET utf8 COLLATE utf8_general_ci;
insert into course
('c01','计算机文化学',70)
('c02','VB',90)
('c03','计算机网络',80)
('c04','数据库基础',108)
('c05','高等数学',180)
('c06','数据结构',72);

--选课表

create table sc(
Sno int ,
Cno varchar(10),
Grade int
)CHARACTER SET utf8 COLLATE utf8_general_ci;
insert into sc values
(9512101,'c01',90)
(9512101,'c02',86)
(95