酒店订餐系统ER图,数据流图DFD 第5页
Create table controller
(Cnumber char (9) primary key and unique, //管理员编号
Cname char (20), //管理员姓名
Csex char (4) //管理员性别
Cage smallint, //管理员年龄
Cdepartment char (20) //管理员部门
);
给管理员授权，对管理员有全部权力
Grant all privileges
On table controller
To controller;
Insert
Into controller (Cnumber, Cname, Csex, Cage, Cdepartment)
Values (‘
Insert
Into controller (Cnumber, Cname, Csex, Cage, Cdepartment)
Values (‘
Insert
Into controller (Cnumber, Cname, Csex, Cage, Cdepartment)
Values (‘
Update controller
Set Csex = ‘女’
Where Cname = ‘李小梅’;
Update controller
Set Cage = 26
Where Cnumber = ‘
Update controller
Set Cdepartment = 送餐部
Where Cnumber = ‘
Delete
From controller
Where Cnumber = ‘
Delete
From controller
Where Cname = ‘王强’;
Delete
From controller
Where Cdepartment = ‘送餐部’;
Create table business //配送交易
(Cnumber char (9) primary key and unique, //管理员编号
Lnumber char (9), //订单编号
Delivery order char(20), //执行命令
Date date //送货日期
);
给管理员授权，对配送交易有全部权力
Grant all privileges
On table business
To controller;
Insert
Into business(Cnumber, Lnumber, Delivery order, Date)
Values (‘
Insert
Into business (Cnumber, Lnumber, Delivery order, Date)
Values (‘
Insert
Into business (Cnumber, Lnumber, Delivery order, Date)
Values (‘
Update business
Set Cnumber = ‘
Where Cnumber = ‘
Update business
Set Lnumber = ‘
Where Cnumber = ‘
Update business
Set Delivery order = ‘等待’
Where Cnumber = ‘
Delete
From business
Where Cnumber = ‘
上一页 [1] [2] [3] [4] [5] [6] [7] 下一页