create_data.txt

来自「学生成绩管理系统」· 文本 代码 · 共 51 行

create database StudentManage
on
( name= StudentManage_dat,filename='E:\myclass\database\StudentManage_dat.mdf',
  size= 10,
maxsize= 50,
filegrowth= 5
)
log on
(
 name=StudentManage_log,filename='E:\myclass\database\StudentManage_log.ldf',
size= 5MB,
maxsize= 25MB,
filegrowth= 5MB
)

create table dept
( dno varchar(50) primary key,
  dname varchar(50) not null
  
)

create table class
(cno varchar(50) primary key,
 cname varchar(50) not null,
 grade varchar(50) not null,
 dno varchar(50) not null,
foreign key (dno) references dept(dno)
)

create table student
(
  sno varchar(50) primary key,
  sname varchar(50) not null,
  sex char(4) not null,
  age int not null,
  cno varchar(50) not null
 foreign key(cno) references class(cno)
)

create table score
(
 sno varchar(50) ,
 eng float not null,
 math float not null,
 db float not null,
 java float not null,
 term  int not null,
 primary key(sno, term),
foreign key(sno) references student(sno)
 
)