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

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

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

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

Delete

From business

Where Lnumber = ‘100111’;

 

Delete

From business

Where Delivery order = ‘返回用户’; 

Create table food data                      //菜品资料

     (System char (10),                    //菜系

Country char (20),                   //国家

Disease char (20),                    //不同疾病

Name char (20),                      //菜名

Photo,                              //照片

Produce char (200),                    //制作

Price float (6)                         //价格

     );

 

给管理员授权,对菜品资料有全部权力

Grant all privileges

On table food data

To controller;

 

建立视图

Create view China-style food (system, name, photo, produce, price)

As

Select system, name, photo, produce, price

From food data

With check option;

 

Insert

Into China-style food

Values (‘吉菜’,’小鸡炖蘑菇’,’ 图片’,’小鸡一只,蘑菇半斤……’,’35.00’);

 

Insert

Into China-style food

Values(‘川菜’,’水煮鱼’,’图片’,’鱼一条,辣椒半斤……’,’28.00’); 

Update China-style food

Set price=’30.00’

Where name=’水煮鱼’;

 

Update China-style food

Set name=’猪肉炖粉条’, produce =’猪肉半斤,粉条若干……

Where system=’吉菜’; 

Delete

From China-style food

Where name=’香辣肉丝’;

 

Delete

From China-style food

Where system=’粤菜’;

 

Create view Western-style food (country, name, photo, produce, price)

As

Select country, name, photo, produce, price

From food data

With check option;

 

Insert

Into Western-style food

Values(‘法国’,’牛扒’,’ 图片’,’牛肉一大块,调料若干……’,’25.00’);

 

Insert

Into Western-style food

Values(‘意大利’,’通心面’,’ 图片’,’面粉,调料若干……’,’18.00’);

 

Update Western-style food

Set price=’30.00’

Where name=’牛扒’;

 

Update Western-style food

Set country=’意大利

Where name=’比萨饼’;

 

Delete

From Western-style food

Where name=’水饺’;

 

Delete

From Western-style food

Where country=’韩国’;

 

Create view medical food (disease, name, photo, produce, price)

As

Select disease, name, photo, produce, price

From food data

With check option;

 

Insert

Into medical food

Values (‘贫血’,’红枣莲子羹’,’图片’,’红枣半斤,莲子若干……’,’15.00’)

 

Update medical food

Set price=’20.00’

Where disease=’气短’;

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

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

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