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

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

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

酒店订餐系统数据库课程设计

Create view medical food (disease, name, photo, produce, price)    //药膳菜品

As

Select disease, name, photo, produce, price

From food data

With check option;

 

Select name

From medical food

Where disease=’便秘’;

 

Select price

From medical food

Where name=’乌鸡汤’;

 

Create view snack (name, photo, produce, price)   //小吃

As

Select name, photo, produce, price

From food data

With check option;

 

Select photo

From snack

Where name=’羊肉串’;

 

Select produce

From snack

Where photo=’炒粉’;

 

4.1.2订单模式

Create schema “order list” authorization user

  Create table order list

(Lnumber char (9) primary key and unique,               //订单编号

 China-style food char (20),                           //中餐

 Western-style food char (20),                         //西餐

 medical food char(20),                              //药膳菜品

 snack char (20)                                    //小吃

); 

给用户授权,对订单有所有权力

Grant all privileges

On table order list

To user;

 

Select China-style food

From order list;

 

Select Western-style food

From order list;

 

Insert

Into order list

Values ( ‘9423’小鸡炖蘑菇’,’意大利面’,’红枣莲子羹’,’春卷’) 

Update order list

Set medical food=’乌鸡汤

Where Western-style food =’意大利面’;

 

Delete

From order list

Where snack=’麻辣烫’; 

4.2客户会员注册模块SQL语句

用户模式

Create schema “user” authorization user

  Create table user

( Unumber char (9) primary key and unique,             //会员帐号

 Uname char (20),                                  //姓名

 Usex char (4),                                     //性别                

 Ucode char (9),                                    //密码

 Telephone char(12),                                //常用电话

 Address char(40)                                   //收货具体地点

);

 

给用户授权,对用户有插入和更新权力

Grant insert, update

On table user

To user;

 

Insert

Into user

Values (‘2200501’,’李勇’,’’,’965473’,’13546798246’,’柳水路铁西街27’);

 

Insert

Into user

Values (‘2200502’,’刘岑’,’’,’358462’,’13756428456’,’环江路锦绣街172单元67’);

 

Insert

Into user

Values (‘2200503’,’王敏’,’’,’123658’,’15963248541’,’锦江小区63’); 

Update user

Set Uname=’张力

Where Usex=’’; 

Update user

Set Ucode=’124658’

Where Ucode=”123658’; 

Update user

Set Telephone=’88763512’

Where Address=’黄河路花园街93’;

 

4.3后台综合管理模块SQL语句

管理员模式

Create schema “controller” authorization controller

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

酒店订餐系统ER图,数据流图DFD 第4页下载如图片无法显示或论文不完整,请联系qq752018766
设为首页 | 联系站长 | 友情链接 | 网站地图 |

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