毕业论文论文范文课程设计实践报告法律论文英语论文教学论文医学论文农学论文艺术论文行政论文管理论文计算机安全
您现在的位置: 毕业论文 >> 课程设计 >> 正文

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

更新时间:2008-9-15:  来源:毕业论文

酒店订餐系统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
设为首页 | 联系站长 | 友情链接 | 网站地图 |

copyright©751com.cn 辣文论文网 严禁转载
如果本毕业论文网损害了您的利益或者侵犯了您的权利,请及时联系,我们一定会及时改正。