酒店订餐系统ER图,数据流图DFD 第5页

酒店订餐系统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 (‘200215128’,’陈东’,’男’,’36’,’服务部’)；

 

Insert

 Into controller (Cnumber, Cname, Csex, Cage, Cdepartment)

 Values (‘200215129’,’李楠’,’女’,’28’,’服务部’)；

 

Insert

 Into controller (Cnumber, Cname, Csex, Cage, Cdepartment)

 Values (‘200215130’,’王明’,’男’,’32’,’服务部’)；

 

Update controller

Set Csex = ‘女’

Where Cname = ‘李小梅’;

 

Update controller

Set Cage = 26

Where Cnumber = ‘200215129’;

 

Update controller

Set Cdepartment = 送餐部

Where Cnumber = ‘200215130’;

 

Delete

From controller

Where Cnumber = ‘200215127’;

 

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 (‘200215128’,’100112’,’’,’发送’,’2007-5-16’)；

 

Insert

Into business (Cnumber, Lnumber, Delivery order, Date)

Values (‘200215129’,’100113’,’’,’等待’,’2007-6-16’)；

 

Insert

Into business (Cnumber, Lnumber, Delivery order, Date)

Values (‘200215130’,’100114’,’’,’返回用户’,’ ’)； 

Update business

Set Cnumber = ‘200215125’

Where Cnumber = ‘200215130’;

 

Update business

Set Lnumber = ‘100115’

Where Cnumber = ‘200215129’;

 

Update business

Set Delivery order = ‘等待’

Where Cnumber = ‘200215130’; 

Delete

From business

Where Cnumber = ‘200215127’;

上一页  [1] [2] [3] [4] [5] [6] [7] 下一页

酒店订餐系统ER图,数据流图DFD 第5页下载如图片无法显示或论文不完整，请联系qq752018766