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

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

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

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

Delete

From medical food

Where disease=’养颜’;

 

Create view snack (name, photo, produce, price)

As

Select name, photo, produce, price

From food data

With check option;

 

Insert

Into snack

Values (‘麻辣烫’,’图片’,’蔬菜若干,调料若干……’,’8.00’)

 

Update snack

Set price=’5.00’

Where name=’春卷’;

 

Delete

From snack

Where name=’米线’;

 

Create table user                              //会员管理

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

Uname char (20),                           //会员姓名

 Usex char (4),                              //会员性别

 Ucode char (9),                             //会员密码

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

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

);

 

给管理员授权,对会员管理有查询和删除的权力

Grant select, delete

On table user

To controller;

 

建立视图

Create view user two (Unumber, Uname , Usex , Address, Telephone)

As

Select Unumber, Uname , Usex , Address, Telephone

From user

With check option; 

Select Telephone

From user two

Where Uname=’周雪’; 

Select Address

From user two

Where Unumber=’2200512’;

 

Select Uname

From user two

Where Unumber=’2200500’;

 

Delete

From user two

Where Telephone=’13566442897’;

 

Delete

From user two

Where Uname =’林沙沙’; 

Delete

From user two

Where Address=’柳水路铁西街27’;

 

 

 

 

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

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

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