createtable.sql

来自「一个基于swing组件的java程序」· SQL 代码 · 共 45 行

create table Admininfo(
	ano varchar(10) primary key,
	aname nvarchar(20) not null,
	code varchar(20) not null,
)

create table Department(
	dno varchar(6)primary key,
	dname nvarchar(20)not null,
)

create table Student(
	sno varchar(10) primary key,
	sname nvarchar(20) not null,
	sex nvarchar(4) not null,
	dno varchar(6),
	code varchar(20) not null,
	foreign key (dno) references Department(dno),
) 



create table Course(
	cno varchar(6) primary key,
	cname nvarchar(20) not null,
	credit varchar(4) not null,
)


create table DC(
	dno varchar(6),
	cno varchar(6),
	major nvarchar(3)not null,
	primary key(dno,cno),
	foreign key(dno) references Department(dno),
	foreign key(cno) references Course(cno),
)

create table SC(
	sno varchar(10),
	cno varchar(6),
	primary key (sno,cno),
	foreign key(sno) references Student(sno),
	foreign key(cno) references Course(cno),
)