【正文】 eckout, including ordinary users and members’ checkout. Corresponding function to achieve the following figure. 圖 31 餐飲管理子系統(tǒng) 功能 圖 （ 1） 預定管理（ Booking Management） 預定管理包括三小塊，預定時間、預定餐桌號（包括大廳餐桌、包間房號）、交付押金。以下是按照上述共六個子功能模塊劃分得數(shù)據(jù)字典。 客房開房明細總表：統(tǒng)計酒店當天客房開房的數(shù)量。 （ 6） 能夠保障人事管理數(shù) 據(jù)的安全、準確。 相應的功能實現(xiàn)如圖 Statement statistics major statistical rooms, advance payment details, details in detail and the current room check in living rooms statements information. Guest room detail overall table: Statistics of guest rooms all information. Advance tables: Statistical advance all records is calculated, and the advance payment balance. Guest check in detail overall table: Statistical hotel guest check in on the quantity. Currently in the living room statements: Statistical hotel rooms in the living quantity. The corresponding function realization as shown in the diagram 信息查詢 Information Search 住房信息查詢 Housing Information Query 顧客信息查詢 Customer Information Query 聯(lián)系 Q709604208 獲取 圖 38 報表統(tǒng)計 功能圖 數(shù)據(jù)字典 (The data dictionary) 表 34 客房基本信息 表 名字：客房基本信息 Name: Room Basic Information 別名：房間信息表 Alias: Room Information Table 描述：存儲客房的基本信息 Description: The basic information of the storage room 定義：客房基本信息 =房間號碼 +房間狀態(tài) +房間類型 +房間價格 Definition: Room Basic Information=Room Number+ Status of Room +Type of Room+ Price of Room 數(shù)據(jù)約束：房間號碼，房間狀態(tài)，房間類型均為字符型數(shù)據(jù)，房間價格為數(shù)值型數(shù)據(jù)。 Data Constraints: name, sex, identification number, room number, membership conditions, discounts for the character data, the amount of consumption for the numerical data. 長度要求：姓名（ 10），性別（ 2），證件號（ 32），房號（ 5） Data Constraint: name(10), sex(2), Document number (32), room number (5) 表 32 預定信息表 名字：預定信息 Name: Booking Information 描述：存儲客戶預定相關信息 Description: Book store customer information 定義：預定信息 =顧客姓名 +顧客證件號 +房號 +房價 +預付款金額 +菜單 +賬單 Definition: Booking Information = Customer identification number + name + room number + price + amount + menu + bill advances 聯(lián)系 Q709604208 獲取 位置： Position: 數(shù)據(jù)約束：顧客姓名，顧客證件號，房號都為字符型數(shù)據(jù)，預付款金額為數(shù)值型 數(shù)據(jù)。 Booking Time: as long as customers are in the business during the scheduled time can be. 預定餐桌號：只要顧客所定的餐桌號是屬于未預定過的即可，其中包括廳內的桌號及包間的號數(shù)或廳名。 Physical Description: indicates the database of realworld objects or concept. Entity is the objective world exists in each other and can distinguish things entity can be the person also can be physical objects, also can be abstract concepts. ER: To establish the data model, in the introduction to database systems within the concept design phase, forming a machine independent, independent of DBMS ER graph model. Usually it referred to as ER diagrams, accordingly can put ER diagram depicts the data model called ER modeling. ER graph provides said entities, attribute and contact method used to describe the conceptual model of the real world. 參考資料 (References) [1] Pfleeger， .amp。 Demand analysis report after project team analysis, discussion and to the needs of the user survey, in conjunction with the relevant material reached after for hotel management system requirements and functional analysis. Main purpose is for your proposed development system design and development of prepared the preparation work. 定義 (Definitions) 實體 ： 表示數(shù)據(jù)庫中描述的現(xiàn)實世界中的對象或概念。點菜管理包括菜名、菜的價格以及送往廚房。點菜管理包括菜名、菜的價格以及送往廚房。 相應功能實現(xiàn)如圖 ： Information query including housing information query and customer information query two parts. Housing information query: To inquire each room state, price, type, move room’s details. 客房管理 Rooms Management 預訂房間 Booking Rooms 開 /退房間 Check In Check Out 調房 Adjustable Rooms 消費記賬 Consumption Charge 續(xù)收 /退還預付款 Renewal Charge /Return the Deposit 聯(lián)系 Q709604208 獲取 Customer information query: Inquires the member condition, each and every customer enjoy discount, housing history records and cumulative. Corresponding function realization as shown in the diagram 圖 37 信息查詢功能圖 （ 3）報表統(tǒng)計 報表統(tǒng)計主要統(tǒng)計客房明細，預付款明細，客房開房明細和當前在住客房報表信息。 （ 3） 具有完整的系統(tǒng)接口，滿足靈活的數(shù)據(jù)導入與導出； Has a plete system interface to meet the flexible data import and export。 長度要求：顧客姓名（ 10） ,顧客證件號（ 18），房號（ 5） 格式要求：入住時間： //(月 /日 /年 ) Data Constraint: Customer’s name, Id Card Number, Room Number, Check In Time are character data, and the Advance Payment Amount is numeric data. Length required: Name(10), Id card Number(18), Room Number(5) Format required: Check in time: //(month/sun/year) 表 37 預付款差額表 名字：預付款差額表 Name: The Advance Payment Balance Table 別名：押金差額表 Alias: Deposit Balance Table 描 述：計算顧客預付款與實消費的差額，多退少補。 預訂房間：服務員填入顧客信息，選擇房間，顯示房間相關信息，改房間狀態(tài)改為已預訂。 Order management, including name of the dish, food prices (sent to the kitchen). 菜名：從菜單上選擇即可。 System should be scalable, as new personnel management subsystem conditions to be added, the system can easily be extended. 系統(tǒng)的安全性 (System security) 由于系統(tǒng)是基于網(wǎng)絡的操作，安全性顯的很重要。管理信息系統(tǒng)能反映企業(yè)的各種運行情況，利用歷史數(shù)據(jù)預測未來，從全局出發(fā)輔助進行決策，利用信息控制行為，幫助實現(xiàn)規(guī)劃目標，進行高效的管理。 聯(lián)系 Q709604208 獲取 （ 2） 客戶端操作系統(tǒng)為 Windows 2020/Windows XP 及以上 。 Vegetables: This is the munication between the kitchen and vendors. 數(shù)量：此項是廚房與商販之間的溝通。 相應功能實現(xiàn)如圖 Check in/out: Waiter fill in customers’ information, choose room, show information of rooms, change the room status information to already opened or leisure. Adjustable room: Waiter input customers’ original room number, new guest room number, show relevant information of rooms, calculating the corresponding consumption. Consumption charge: When the customer checkout, calculation of consumer spending automatic. Renewal charge/return advance payment: Calculating the advance payment balance, and preserve. Corresponding function realization as shown in the diagram 圖 36 客房管理功能圖 （ 2）信息查詢 信息查詢包括住房信息查詢和顧客信息查詢兩部分。 Cos