1、一數據字典1客戶信息表client列名數據類型約束備注cnochar(10)primary keyidchar(18)客戶身份證號cnamevarchar2(10)not null客戶姓名sexchar(2)check(sex='男' or sex='女')客戶性別birthdate生日ctelchar(15)聯系電話vipchar(2)check(vip in('是','否')是否是vip會員addrvarchar2(50)客戶家庭住址2房間類型表roomtype列名數據類型約束備注rtnochar(4)primary key房

2、間類型編號rtypevarchar2(20)房間類型pricenumber(7,2)價格3房間信息表room列名數據類型約束備注rnochar(5)primary key房間號rtnochar(4)check(rstate='可用' or rstate='不可用')foreign key(rtno) references roomtype(rtno)房間類型號rstatechar(6)房間狀態4入住表enrol列名數據類型約束備注rnochar(5)primary key(rno)房間號idchar(18)客戶身份證號foregiftnumber(7,2)押金e

3、timedate入住時間edaynumber(3)所住天數5職稱表 prof列名數據類型約束備注pnochar(5)primary key,職稱號pnamevarchar2(10)not null職稱名psalnumber(7,2)工資6創建員工信息表employee列名數據類型約束備注enochar(5)primary key工號enamevarchar2(10)not null員工姓名esexchar(2)check(esex='男' or esex='女')pnochar(5)職稱號ebirthdate生日etelchar(15)聯系電話7創建黑名單表bl

4、ack列名數據類型約束備注bidchar(18)not null黑名單身份證號bnamevarchar2(10)not null姓名bsexchar(2)check(bsex='男' or bsex='女')創建預訂表book列名數據類型約束備注bnochar()primary key預訂號bnamevarchar2(20)姓名rtypechar(4)房間類型bdatedate預訂日期indatedate入住時間)二相關圖形1 邏輯聯系圖cnoidcnamesexbirthctelvipaddrclient表bnobnamertypebdateindatebook表idrnoforegiftetimeedayenrol表rtnortypepriceroomtype表rnortnorstateroom表bidbnamebsexblack表pnopnamepsalprof表enoenameesexpnoebirthetelemployee表2 業務流程圖開始是否預訂？查詢現有空房查詢預訂記錄確定住宿？不住宿否是否登記相關資料核查資料不予住宿入住結賬?未通過通過退