1
数据库上机
create table employ(
ecardid char(20),
eid char(20) not null,
ename char(20) not null,
esex char(20) key (mid) references manage(mid),
foreign key (eid) references employ(eid),
foreign key (shiduan) references menu(shiduan)
)
create table discount (
num char(20),
discount char(20),
dishname char(20) not null,
pingzong char(20),
primary key(num),
check (pingzong in("主菜")),
foreign key (dishname) references menu(dishname)
)
create table xiadan(
eid char(20),
shiduan char(20) not null,
dishname char(20) not null,
qty smallint,
danjia float(20) not null,
num char(20) not null,
4
primary key(eid),
foreign key (eid) references employ(eid),
foreign key (shiduan) references menu(shiduan),
foreign key (dishname) references menu(dishname),
foreign key (num) references discount(num)
)
create database restaurant
create table manage(
mcardid char(20),
mno char(20) not null unique ,
mname char(20) not null,
msex char(20) not null,
mtelenum char(20),
position char(20),
primary key (mno),
check (msex in ("男","女")),
check(position in("经理"))
)
create table employ(
ecardid char(20),
eno char(20) not null,
5
ename char(20) not null,
esex char(20) not null,
etelenum char(20),
position char(20),
primary key (eno),
check (esex in ("男","女")),
check(position in("员工"))
)
create table breakfast(
bname char(20),
bno char
数据库上机 来自淘豆网www.taodocs.com转载请标明出处.