先创建三个表,分别为student,course,SC(即学生表,课程表,选课表)
建表语句:
create table student(
Sno int,
Sname varchar(255),
Sage int,
Sex varchar(10),
Sdept varchar(100),
primary key(Sno)
);
create table course(
Cno varchar(10),
Cname varchar(255),
hours int,
primary key(Cno)
);
create table sc(
Sno int,
Cno varchar(10),
Grade int
);
insert into student values
(9512101,'李勇',19,'男','计算机系'),
(9512102,'刘晨',20,'男','计算机系'),
(9512103,'王敏',20,'女','计算机系'),
(9521101,'张立',22,'男','信息系'),
(9521102,'吴斌',21,'女','信息系'),
(9521103,'张海',20,'男','信息系'),
(9531101,'钱小利',18,'女','数学系'),
(9531102,'王大利',19,'男','数学系');
insert into course val