第6题:
建立部门表
create table bumen
(
Bno char(9) primary key,
Bname char(20) not null,
Bmanger char(20) ,
Btele int
)
建立员工表
create table staff
(
Stno char(9) primary key,
Sname char(20),
Stage int constraint M1 check (Stage<=60),
Sjob char(20),
Smon int,
Bno char(9),
foreign key (Bno) references bumen (Bno)