数据库3.2学生-课程数据库学生选课表创建

数据库3.2学生-课程数据库学生选课表创建

打开指令   mysql -h localhost -P 3306 -u root -p

show databases;

 use student;

set names gbk;

 create table student (sno char(9) primary key,

    sname char(20) unique,

     sex char(2),

     sage smallint,

     sdept char(20)

 );

 create table course(

     cno char(4) primary key,

     cname char(40) not null,

     cpno char(4),

     ccredit smallint,

     foreign key(cpno) references course(cno)

     );

     create table sc (

     sno char(9),

     cno char(4),

     grade smallint,

     PRIMARY KEY (sno,cno),

     foreign key(sno) references student(sno),

     foreign key(cno) references course(cno)

     );

Insert into student values('201215121','李勇','男',20,'CS'),('201215122','刘晨','女',19,'CS'),('201215123','王明','女',18,'MA'),('201215125','张立','男',19,'IS');

select * from stu;

insert into course values('2','数学',null,2),('6','数据处理',null,2),('4',' *** 作系统','6',3),('7','PASCAL语言','6',4),('5','数据结构','7',4),('1','数据库','5',4),('3','信息系统','1',4);

insert into sc values('201215121','1',92),('201215121','2',85),('201215121','3',88),('201215122','2',90),('201215122','3',80);