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

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

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