酒店订餐系统数据库设计和实现

onname二酒店订餐，力\酒店订餐.01€1卜，size=10,maxsize=50,log onname二酒店订餐」og,\酒店订餐.1€1f,size=5,maxsize=25,create tablecookbook Cooknumberchar9primary key,/*菜单编号*/name char20unique,/*菜单名*//*会员价格*/Member_price float6,create procedureupdatebusiness@Cnumber char9,/*管理员编号*/@Lnumber char9/*订单编号*/asupdate businesssetDelivery order=‘发送where Delivery_order=等待发送‘and lnumber=@Lnumber andcnumber=@Cnumberexec updatebusiness@Lnumber=，090809@Cnumber=080909create triggerchangedisplay4on businessforupdateas select*from businessconstraintprice_chk checkMember_price=0Create tableorder_list/*i］单编号*/Lnumber char9primary key,/*中餐*/Chinastyle food char20,/*西餐*/Westernstyle_food char20,medical_food char20,/*药膳菜品*/snack char20/*小吃*/Create tablelistorderLnumber char9primary key,/*订单编号*/Delivery_order char20,/*顶单状态*/Unumber char20,/*订餐者编号*/时间datetime,alllist decimal6,2,/*合计*/Cnumber char20/*管理员编号*/Create table顾客/*会员帐号*/Unumber char9primary key,Uname char20,/*姓名*/Usex char4default男，Telephone char12,/*常用*/Address char40/*收货详细地点*/Create tablecontrollerCnumber char9primary key,/*管理员编号*/Cname char20,/*管理员姓名*/Csex char4,/*管理员性别*/Cage smallint,/*管理员年龄*/Cdepartment char20/*管理员部门*/Create tablefooddata/*菜品资料*/systems char10,/*菜系*/Country char20,/*国家*/Disease char20,/*不一样疾病*/Name char20primary key,/*菜名*/Produce char200,/*制作作Price float6/*价格*/Create tablebusiness/*配送交易*/Lnumber char9,/*订单编号*/Delivery orderchar20,/*执行命令*/日期datetime/*送货日期*//*建立索引*/create uniqueindex foodon food_datanamecreate uniqueindex liston order_listLnumbercreate uniqueindex userson顾客UnumberCreate viewChinastyle_foodAsSelect name,produce,priceFrom food_dataWhere systems=鲁菜’Create viewWesternstyle_foodAsSelect name,produce,priceFrom food_dataWhere country=美国Create viewmedical_food/*药膳菜品*/AsSelect name,produce,priceFrom fooddataWhere disease二心脏’Create viewsnack/*小吃*/AsSelect produce,priceFrom fooddataWhere name=炒粉©Country char20,/*国家*/©Disease char20二无‘,/*不一样疾病*/@Name char20,/*菜名*/©Produce char200=无/*制作*/©Price float6as insertinto fooddata values©Systems,©Country,©Disease,©Name,©Produce,©Price execinsertfood©Systems=鲁菜©Country=‘中国，@Disease=养育，@Name=烤鸭,©Produce=香辣，@Price=55delete fromfood_datawhere name=水煮牛肉create triggerchangedisplay1on food_datafor insertasselect*from fooddatacreate procedureinsertuser@Unumber char9,/*会员帐号*/@Uname char20,/*姓名*/@Usex char4,/*性别*/@Ucode char9,/*密码*/©Telephone char12,/*常用*/©Address char40as insertinto顾客values@Unumber,@Uname,@Usex,@Ucode,©Telephone,©Address execinsertuser@Unumber=，09001，,@Uname=，常在k,@Usex=，女,@Ucode=123457,©Telephone=,@Address=胜利路3号deletefrom顾客where unumber=’09001create triggerchanged!splay2on顾客for insertascreate procedureinsertorder©Lnumber char9,/*订单编号*/@Chinastyle_food char20,/*中餐*//*西餐*/@Westernstyle_foodchar20,©medical foodchar20,/*药膳菜品*/@snack char20/*小吃*/asinsert intoorder_list values@Lnumber,@Chinastyle_food,@Westernstyle_food,@medical_food,@snackexec insertorder@Lnumber=，090806,@Chinastyle_food=，童子鸡，@Westernstyle_food=，意大利面’，@medical_food=，瓦罐汤’,@snack=，泡粉deletefrom orderlistselect*from inserted、£**1**1*1*KL*^1**1**1**1**1**1*vt*vt*vtz*X**X*vt**1*vt*vt*vt*vtz*Az*Az^1**1**A*zj*zjs zjs zj%zj%7s*js*y**y**y*y**T***1s*7%*7**7**y**j^*jszj%Js*T*create triggerchangedisplay3on orderlistforinsertasselect*from order_listcreate procedureinsertbusiness@Cnumber char9,/*管理员编号*/@Lnumber char9,/*订单编号*/©Delivery orderchar20,/*执行命令*/@日期datetime/*送货日期*/asinsert intobusiness values@Cnumber,@Lnumber,@Delivery_order,@日期exec insertbusiness@Cnumber=，080909,@Lnumber=，090809,,@Delivery_order=，等待发送,@日期二2023-08-25deletefrom business。