【正文】 exec 查詢預訂 39。, Oderno output開臺信息drop proc 開臺create proc 開臺 Menuno varchar(10),Foodtableno varchar(10),customerno varchar(10), Oderno varchar(10),workerno varchar(10),Customertime datetimeas insert into Menus values(Menuno,Foodtableno,customerno,Oderno,workerno,Customertime) update Foodtable set Foodtablestate=39。,39。,39。,39。,39。,2exec 點菜 39。,39。,39。,1exec 點菜 39。,39。,39。,2exec 點菜 39。,39。出入顧客的編號，計算本次消費信息 exec 消費總額 customerno , Saleroom outputselect Customername, Saleroom 總費用from Customerwhere Customerno = customern查詢客戶點菜信息drop proc 查詢客戶點菜create proc 查詢客戶點菜 customerno varchar(10)as select ,Amount from Dish,menus_dish,menus where =customerno and = and = 測驗exec 查詢客戶點菜 39。菜品的刪除drop proc 修改菜單create proc 修改菜單 Menuno varchar(10), Dishname varchar(20)as delete from menus_dish where Menuno=Menuno and Dishname= Dishname測驗 exec 修改菜單 39。 發(fā)票信息drop proc 發(fā)票信息create proc 發(fā)票信息 customerno varchar(10), Actuallypay1 float, Menuno varchar(10) output, Actuallypay2 float output, customername varchar(10) output, Saleroom float output, after_discount float output, Billtime datetime outputas select Saleroom=SUM(Dishprice*Amount)本次消費總額 from menus_dish,Dish,Menus where Customerno=customerno and = and = select customername=customername 查詢用戶姓名 from customer where customerno = customerno select Menuno=Menuno 獲取賬單號 from Menus where Customerno=customerno set Billtime=getdate() 獲取消費賬單時間 set Actuallypay2=Actuallypay1獲取實付現(xiàn)金 select after_discount=Saleroom**Discount 計算折扣后費用 from customer , Discount_rules where = print 39。+ customername打印發(fā)票 print 39。 + str(Saleroom, 10, 2) print 39。 + str(Actuallypay2after_discount, 10, 2) print 39。+ cast( Billtime as varchar(20)) update customer 修改顧客歷史消費總額 set totalexpend = (totalexpend+after_discount) where customerno = customerno delete 刪除本次所點的所有的菜 from menus_dish where Menuno = (select Menuno from Menus where customerno = customerno) update Foodtable 修改桌臺狀態(tài) set Foodtablestate=39。, 200,customername output, Actuallypay2 output,Saleroom output,Menuno output,after_discount output,Billtime output (1)、輸出發(fā)票信息（2） 、修改桌臺信息 （3） 、插入消費賬單查詢某一時間段的營業(yè)額drop proc 查詢營業(yè)額create proc 查詢營業(yè)額 begintime datetime, endtime datetime, sum_of_turnover float(5) outputAs select sum_of_turnover=sum(Saleroom) from Sales_bill where Billtime=begintime and Billtimeendtime print 39。+ cast( endtime as varchar(20))+ 39。 ,39。 在Oracle中數(shù)據(jù)庫實施見附錄1 Oracle數(shù)據(jù)庫測試見附錄25．總結(jié)本次數(shù)據(jù)庫課程設計已經(jīng)基本上完成，在這次實習中，感覺很有收獲，雖然上課很認真的聽講，實驗課感覺挺簡單的，但真正到實踐的時候，還是困難重重。6．附錄附錄1 創(chuàng)建關(guān)系drop table Dishcreate table Dish 菜譜(Dishno varchar2(10)primary key, Dishname varchar2(10) not null, Dishclass varchar2(10), Dishprice number not null , Dishstate varchar(6) check(Dishstate = 39。))drop table Customercreate table Customer 顧客(Customerno varchar2(10) primary key, Customername varchar2(10) not null, Customersex varchar2(4) check(Customersex = 39。)not null, Custoemrphoneno varchar2(20) unique, VIP_level number, totalexpend number)drop table Foodtablecreate table Foodtable桌臺信息(Foodtableno varchar2(10)primary key, seatingno number not null,