数据库系统原理及应用实验报告.doc

Primary key (cno)

Foreign key (cpno)

Score (sno, cno, score)

Primary key (sno, cno)

Foreign key (sno)

Foreign key (cno)

Teacher (tno, tname, tsex, tbirthday, position, department, tamount, experience)

Primary key (tno)

Teaching (tno, cno, tdate, classroom, sclass)

Primary key (tno, cno)

use student_managment;

);

create table course if not exists(

cno char(6), cname char(20),

cpno char(6), ctime numeric(2),

credit numeric(2), score numeric(3),

constraint pk_course primary key (cno),

);

create table score (

);

create table teacher (

tno char(7), tname char(10),

tsex char(2), tbirthday Datetime,

position char(12), department char(16),

tamount numeric(7,2), experience char(200),

primary key (tno),

);

create table teaching (

tno char(7) ,

);