中信酒店管理系统需求

1、酒店管理系统项目组长：项目组员：可编辑撰写日期：2012-04-22系统ER图nF页订剽魅吋何住町何住宿T预订伏鬲y.预订琼朗可:1系统关联图宾客前台操作人员副食品台管理屮X昵收银管理J二 一亠消聲管理占单客论Jh useruser_id user_code user_name user_password user commentnumber NUMBER varchar(20)VARCHAR(10) varchar(200)vpk>h_food_billfood bill idnumber <pk>food idnumber <fk1>fcustomer_idn

2、umber <fk2>food bill cost numbernumberfood_billl_costnumberfood_bill_datenumberh_menumenu idnumber<pk>menu bill idnumber<fk>menu_namevarchar(20)menu_pricenumberh roomroomd room_code room_grade room_price room_statenumber number number number(8,2) numberroom commentvarchar(200)h mem

3、bernumber物理模型图FK_FOOD_BIL l_FOOD_IDh food<pk>.FK_MENU_MENU_BILLFK_FOOD_BIL CUSTOMER - - _foodd food_name food_price food kindsnumber<pk>varchar2(20) number(8,2) varchar2(20)h_general_costgeneral cost idnumber<pk>general_namevarchar2(20)general_cost_telvarchar2(20)general_cost_cashn

4、umbergeneral cost datedategeneral_cost_arr_datedategeneral_cost_statenumberh menu billmenu bill idnumber <pk>mcustomer_idnumber <fk>menu_bill_cost_number number menu_bill_costnumbermenu bill datedateFK_MENU_BILL_CUSTOMERh customermember id member_greade_id number member_number member_nam

5、e member_gender member_code member_birthday member_grade member telnumbervarchBO2(20)M_ROOM char(2) varchar2(18)date number varchar2(20)<pk> <fk>FK_BOOK_ROOM_CUSTOMERcustomer id customer_name customer_gender customer_code customer telFK_MEMBER_MEMBER_GRADEFK_CHECK_IN_REFEREN<pk>var

6、char2(20) char(2) varchar2(18) varchar2(20)numberh_member_grademember_greade_id number membeK_Cgiad_CUSTOMEumber member_count number(4,2)<pk>h book roombook_id bcustomer_id broo md book_cash book_date book_arr_date book_last book statenumber number number number(8,2) date date NUMBER number<

7、;pk> <fk1> <fk2>h check incheck in idnumber <pk>croo mdnumber <fk1>customer_idnumber <fk2>check in datedatecheck out datedatecheck in lastNUMBER数据库表用户表(user )数据项名称参数数据类型用户idUser_idNumber用户编号User_codeNumber用户姓名User_ nameVarchar(20)用户密码User_passwordVarchar(10)用户备注User_

8、comme ntVarchar ( 200)酒水零食(food)数据项名称参数数据类型副食品idFood_idNumber编号Food_codeNumber副食品名称Food_ nameVarchar(20)副食品价格Food_priceNumber副食品种类Food_k indsVarchar(20)酒水零食账单表(food_bill )数据项名称参数数据类型副食品账单idFood_bill_idNumber副食品idFood_bill_idNumber宾客idFood_ check_ in_idNumber副食品消费数量Food_bill_cost_ nu mberNumber副食品消费金

9、额Food_bill_costNumber畐喰品消费时间Food_bill_dateDate预定餐饮(general_cost)数据项名称参数数据类型普通消费idgen eral_cost_idNumber宾客姓名gen eral_cost_ nameVarchar(20)宾客电话gen eral_cost_telVarchar(20)押金gen eral_cost _cashNumber预定时间gen eral_cost _dateDate预定到达时间gen eral_cost _arr_dateDate预定餐饮状态Book_stateNumber菜单(menu)数据项名称参数数据类型食品i

10、dMe nu_idNumber食品编号Menu_codeNumber食品名称Menu_n ameVarchar(20)食品价格Menu _priceNumber食品账单表(menu _bill )数据项名称参数数据类型食品账单idMenu _bill_idNumber食品idMenu _bill_idNumber宾客idMe nu _ bill_cus_idNumber食品消费数量Menu _bill_cost_ nu mberNumber食品消费金额Me nu _bill_costNumber食品消费时间Men u_bill_dateDate客房(room)数据项名称参数数据类型客房idRo

11、o mdNumber客房编号Room codeNumber客房等级Room _gradeNumber客房价格Room _priceNumber客房状态Room stateNumber客房备注Room _comme ntVarchar ( 200)宾客表(customer)数据项名称参数数据类型宾客idCustomer_idNumber姓名Customer_ nameVarchar(20)性别Customer_ge nderChar(2)身份证号Customer_codeVarchar(18)电话Customer_telVarchar(20)会员表(member)数据项名称参数数据类型会员idM

12、ember_idNumber会员等级idMember_gradedNumber姓名Member_ nameVarchar(20)性别Member_ge nderChar(2)身份证号Member_codeVarchar(18)生日Member_birthdayDate联系电话Member_telVarchar(20)会员等级( menber_grade)数据项名称参数数据类型会员等级idGrade_idNumber会员等级Member_gradeNumber会员折扣Men ber_co untNumber(4,2)预定房间(Book_room)数据项名称参数数据类型预房idBook_idNumber客房idBroo mdNumber宾客idBcustomer _idNumber押金B_cashNumber预定时间B_dateDate预定天数B_lastNumber预定到达时间Book_arr_dateDate预房状态Book_stateNu