VB酒店管理系统,北邮《数据库》课程实践_sql_数据库_其他

<html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta charset="utf-8"> <meta name="generator" content="pdf2htmlEX"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <link rel="stylesheet" href="https://static.pudn.com/base/css/base.min.css"> <link rel="stylesheet" href="https://static.pudn.com/base/css/fancy.min.css"> <link rel="stylesheet" href="https://static.pudn.com/prod/directory_preview_static/62927b0dbf399b7f3533df0b/raw.css"> <script src="https://static.pudn.com/base/js/compatibility.min.js"></script> <script src="https://static.pudn.com/base/js/pdf2htmlEX.min.js"></script> <script> try{ pdf2htmlEX.defaultViewer = new pdf2htmlEX.Viewer({}); }catch(e){} </script> <title></title> </head> <body> <div id="sidebar" style="display: none"> <div id="outline"> </div> </div> <div id="pf1" class="pf w0 h0" data-page-no="1"><div class="pc pc1 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/62927b0dbf399b7f3533df0b/bg1.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0">数据库《酒店管理系统》实验报告</div><div class="t m0 x2 h4 y3 ff1 fs1 fc0 sc0 ls0 ws0">北京邮电大学 <span class="ff2">05807<span class="_ _0"> </span></span>班 顾远 学号：<span class="ff2">052421 </span>班内序号：<span class="ff2">03</span></div><div class="t m0 x3 h5 y4 ff1 fs2 fc0 sc0 ls0 ws0">一、数据字典</div><div class="t m0 x3 h5 y5 ff3 fs2 fc0 sc0 ls0 ws0">1.<span class="ff1">表英文名：</span>guests <span class="ff1">表中文名：客人信息表</span></div><div class="t m0 x4 h5 y6 ff1 fs2 fc0 sc1 ls0 ws0">序号<span class="_ _1"> </span>属性名<span class="_ _2"> </span>含义<span class="_ _3"> </span>关键字<span class="_ _4"> </span>类型<span class="_ _5"> </span>长度<span class="_ _6"> </span>域值<span class="_ _7"> </span>取值说明</div><div class="t m0 x4 h5 y7 ff3 fs2 fc0 sc0 ls0 ws0">1<span class="_ _8"> </span>roomcode<span class="_ _9"> </span><span class="ff1">房间号码<span class="_ _a"> </span></span>PK<span class="_ _b"> </span>varchar<span class="_ _4"> </span>4<span class="_ _c"> </span><span class="_ _d"> </span><span class="ff1">参照<span class="_ _e"> </span></span>room<span class="_ _e"> </span><span class="ff1">表</span></div><div class="t m0 x4 h6 y8 ff3 fs2 fc0 sc0 ls0 ws0">2<span class="_ _8"> </span>name</div><div class="t m0 x5 h5 y9 ff1 fs2 fc0 sc0 ls0 ws0">客人姓名</div><div class="t m0 x6 h6 y8 ff3 fs2 fc0 sc0 ls0 ws0"><span class="_ _f"> </span>varchar<span class="_ _4"> </span>20<span class="_ _10"> </span><span class="_ _d"> </span></div><div class="t m0 x4 h5 ya ff3 fs2 fc0 sc0 ls0 ws0">3<span class="_ _8"> </span>sex<span class="_ _11"> </span><span class="ff1">性别<span class="_ _3"> </span></span><span class="_ _f"> </span>varchar<span class="_ _4"> </span>1<span class="_ _c"> </span><span class="_ _d"> </span>M:<span class="ff1">男；</span>F:<span class="ff1">女</span></div><div class="t m0 x4 h6 yb ff3 fs2 fc0 sc0 ls0 ws0">4<span class="_ _8"> </span>age</div><div class="t m0 x5 h5 yc ff1 fs2 fc0 sc0 ls0 ws0">年龄</div><div class="t m0 x6 h6 yb ff3 fs2 fc0 sc0 ls0 ws0"><span class="_ _f"> </span>int<span class="_ _12"> </span><span class="_ _13"> </span><span class="_ _d"> </span></div><div class="t m0 x4 h5 yd ff3 fs2 fc0 sc0 ls0 ws0">5<span class="_ _8"> </span>certclassno<span class="_ _14"> </span><span class="ff1">证件种类编号<span class="_ _15"> </span></span><span class="_ _f"> </span>varchar<span class="_ _4"> </span>2<span class="_ _c"> </span><span class="_ _d"> </span><span class="ff1">参照编码表</span></div><div class="t m0 x4 h6 ye ff3 fs2 fc0 sc0 ls0 ws0">6<span class="_ _8"> </span>certificate</div><div class="t m0 x5 h5 yf ff1 fs2 fc0 sc0 ls0 ws0">证件号</div><div class="t m0 x6 h6 ye ff3 fs2 fc0 sc0 ls0 ws0"><span class="_ _f"> </span>varchar<span class="_ _4"> </span>20<span class="_ _10"> </span><span class="_ _d"> </span></div><div class="t m0 x4 h5 y10 ff3 fs2 fc0 sc0 ls0 ws0">7<span class="_ _8"> </span>countryno<span class="_ _16"> </span><span class="ff1">国籍编码<span class="_ _a"> </span></span><span class="_ _f"> </span>varchar<span class="_ _4"> </span>2<span class="_ _c"> </span><span class="_ _d"> </span><span class="ff1">参照国籍表</span></div><div class="t m0 x4 h6 y11 ff3 fs2 fc0 sc0 ls0 ws0">8<span class="_ _8"> </span>arridate</div><div class="t m0 x5 h5 y12 ff1 fs2 fc0 sc0 ls0 ws0">抵达日期</div><div class="t m0 x6 h6 y11 ff3 fs2 fc0 sc0 ls0 ws0"><span class="_ _f"> </span>date<span class="_ _17"> </span><span class="_ _13"> </span><span class="_ _d"> </span></div><div class="t m0 x4 h5 y13 ff3 fs2 fc0 sc0 ls0 ws0">9<span class="_ _8"> </span>leftdate<span class="_ _2"> </span><span class="ff1">拟走日期<span class="_ _a"> </span></span><span class="_ _f"> </span>date<span class="_ _17"> </span><span class="_ _13"> </span><span class="_ _d"> </span>leftdate> arridate</div><div class="t m0 x4 h5 y14 ff3 fs2 fc0 sc0 ls0 ws0">10<span class="_ _18"> </span>remarks<span class="_ _5"> </span><span class="ff1">备注<span class="_ _3"> </span></span><span class="_ _f"> </span>v<span class="_ _19"></span>archar<span class="_ _4"> </span>20<span class="_ _10"> </span><span class="_ _d"> </span></div><div class="t m0 x3 h5 y15 ff3 fs2 fc0 sc0 ls0 ws0">2.<span class="ff1">表英文名：</span>roomstate <span class="ff1">表中文名：房间状态表</span></div><div class="t m0 x4 h5 y16 ff1 fs2 fc0 sc1 ls0 ws0">序号<span class="_ _1a"> </span>属性名<span class="_ _1b"> </span>含义<span class="_ _1c"> </span>关键字<span class="_ _4"> </span>类型<span class="_ _5"> </span>长度<span class="_ _1d"> </span>域值<span class="_ _1e"> </span>取值说明</div><div class="t m0 x4 h6 y17 ff3 fs2 fc0 sc0 ls0 ws0">1<span class="_ _1f"> </span>roomcode</div><div class="t m0 x7 h5 y18 ff1 fs2 fc0 sc0 ls0 ws0">房间号码</div><div class="t m0 x6 h6 y17 ff3 fs2 fc0 sc0 ls0 ws0">PK<span class="_ _b"> </span>varchar<span class="_ _4"> </span>4</div><div class="t m0 x8 h5 y18 ff1 fs2 fc0 sc0 ls0 ws0">参照<span class="_ _e"> </span><span class="ff3">room<span class="_ _e"> </span></span>表</div><div class="t m0 x9 h6 y17 ff3 fs2 fc0 sc0 ls0 ws0"></div><div class="t m0 x4 h5 y19 ff3 fs2 fc0 sc0 ls0 ws0">2<span class="_ _1f"> </span>roomstate<span class="_ _1d"> </span><span class="ff1">房间状态<span class="_ _5"> </span></span><span class="_ _f"> </span>v<span class="_ _19"></span>archar<span class="_ _4"> </span>2<span class="_ _20"> </span>r:<span class="ff1">可租</span> z:<span class="ff1">整理</span></div><div class="t m0 x8 h5 y1a ff3 fs2 fc0 sc0 ls0 ws0"> o:<span class="ff1">故障</span> l:<span class="ff1">住人</span></div><div class="t m0 x9 h6 y19 ff3 fs2 fc0 sc0 ls0 ws0"></div><div class="t m0 x3 h5 y1b ff3 fs2 fc0 sc0 ls0 ws0">3.<span class="ff1">表英文名：</span>roomtype <span class="ff1">表中文名：房间类型表</span></div><div class="t m0 x4 h5 y1c ff1 fs2 fc0 sc1 ls0 ws0">序号<span class="_ _21"> </span>属性名<span class="_ _22"> </span>含义<span class="_ _3"> </span>关键字<span class="_ _4"> </span>类型<span class="_ _5"> </span>长度<span class="_ _6"> </span>域值<span class="_ _23"> </span>取值说明</div><div class="t m0 x4 h6 y1d ff3 fs2 fc0 sc0 ls0 ws0">1<span class="_ _24"> </span><span class="ff4">typeno</span></div><div class="t m0 x5 h5 y1e ff1 fs2 fc0 sc0 ls0 ws0">分类号</div><div class="t m0 x6 h6 y1d ff3 fs2 fc0 sc0 ls0 ws0">PK<span class="_ _b"> </span>varchar<span class="_ _4"> </span>2<span class="_ _c"> </span><span class="_ _25"> </span></div><div class="t m0 x4 h5 y1f ff3 fs2 fc0 sc0 ls0 ws0">2<span class="_ _24"> </span>typename<span class="_ _26"> </span><span class="ff1">分类名<span class="_ _27"> </span></span><span class="_ _f"> </span>varchar<span class="_ _4"> </span>10<span class="_ _10"> </span>1:<span class="ff1">豪华套</span>,</div><div class="t m0 xa h5 y20 ff3 fs2 fc0 sc0 ls0 ws0">2:<span class="ff1">总统套</span>,</div><div class="t m0 xa h5 y21 ff3 fs2 fc0 sc0 ls0 ws0">3:<span class="ff1">标准间</span>,</div><div class="t m0 xa h5 y22 ff3 fs2 fc0 sc0 ls0 ws0">4:<span class="ff1">三人间</span>,</div><div class="t m0 xa h5 y23 ff3 fs2 fc0 sc0 ls0 ws0">5:<span class="ff1">单人间</span></div><div class="t m0 x9 h6 y1f ff3 fs2 fc0 sc0 ls0 ws0"></div><div class="t m0 x4 h6 y24 ff3 fs2 fc0 sc0 ls0 ws0">3<span class="_ _24"> </span>beds</div><div class="t m0 x5 h5 y25 ff1 fs2 fc0 sc0 ls0 ws0">床位数</div><div class="t m0 x6 h6 y24 ff3 fs2 fc0 sc0 ls0 ws0"><span class="_ _f"> </span>int<span class="_ _12"> </span>1<span class="_ _c"> </span><span class="_ _25"> </span></div><div class="t m0 x4 h5 y26 ff3 fs2 fc0 sc0 ls0 ws0">4<span class="_ _24"> </span>price<span class="_ _12"> </span><span class="ff1">定价<span class="_ _3"> </span></span><span class="_ _f"> </span>float<span class="_ _28"> </span><span class="_ _13"> </span><span class="_ _25"> </span></div><div class="t m0 x4 h6 y27 ff3 fs2 fc0 sc0 ls0 ws0">5<span class="_ _24"> </span>remarks</div><div class="t m0 x5 h5 y28 ff1 fs2 fc0 sc0 ls0 ws0">备注</div><div class="t m0 x6 h6 y27 ff3 fs2 fc0 sc0 ls0 ws0"><span class="_ _f"> </span>varchar<span class="_ _4"> </span>20<span class="_ _10"> </span><span class="_ _25"> </span></div><div class="t m0 x3 h5 y29 ff3 fs2 fc0 sc0 ls0 ws0">4.<span class="ff1">表英文名：</span>room <span class="ff1">表中文名：房间配置表</span></div><div class="t m0 x4 h5 y2a ff1 fs2 fc0 sc1 ls0 ws0">序号<span class="_ _29"> </span>属性名<span class="_ _10"> </span>含义<span class="_ _2a"> </span>关键字<span class="_ _4"> </span>类型<span class="_ _1f"> </span>长度<span class="_ _6"> </span>域值<span class="_ _13"> </span>取值说明</div><div class="t m0 x4 h5 y2b ff3 fs2 fc0 sc0 ls0 ws0">1<span class="_ _2b"> </span>roomcode<span class="_ _16"> </span><span class="ff1">房间号码<span class="_ _a"> </span></span>PK<span class="_ _2c"> </span>varchar<span class="_ _2d"> </span>4<span class="_ _c"> </span><span class="_ _2a"> </span></div><div class="t m0 x4 h6 y2c ff3 fs2 fc0 sc0 ls0 ws0">2<span class="_ _2b"> </span>typeno</div><div class="t m0 x5 h5 y2d ff1 fs2 fc0 sc0 ls0 ws0">房间分类号</div><div class="t m0 x6 h6 y2c ff3 fs2 fc0 sc0 ls0 ws0"><span class="_ _f"> </span>varchar<span class="_ _2d"> </span>2<span class="_ _c"> </span></div><div class="t m0 xb h5 y2d ff1 fs2 fc0 sc0 ls0 ws0">参照<span class="_ _e"> </span><span class="ff3">roomtype<span class="_ _e"> </span></span>表</div><div class="t m0 x3 h5 y2e ff3 fs2 fc0 sc0 ls0 ws0">5.<span class="ff1">表英文名：</span>countrycodes <span class="ff1">表中文名：国籍编码表</span></div><div class="t m0 x4 h5 y2f ff1 fs2 fc0 sc1 ls0 ws0">序号<span class="_ _2e"> </span>属性名<span class="_ _2f"> </span>含义<span class="_ _3"> </span>关键字<span class="_ _4"> </span>类型<span class="_ _5"> </span>长度<span class="_ _6"> </span>域值<span class="_ _30"> </span>取值说明</div><div class="t m0 x4 h5 y30 ff3 fs2 fc0 sc0 ls0 ws0">1<span class="_ _2f"> </span><span class="ff4">countryno<span class="_ _31"> </span><span class="ff1">国籍编码<span class="_ _a"> </span></span></span>PK<span class="_ _b"> </span>varchar<span class="_ _4"> </span>2<span class="_ _c"> </span>2<span class="_ _e"> </span><span class="ff1">位大写字母<span class="_ _32"> </span></span></div><div class="t m0 x4 h6 y31 ff3 fs2 fc0 sc0 ls0 ws0">2<span class="_ _2f"> </span>country</div><div class="t m0 x5 h5 y32 ff1 fs2 fc0 sc0 ls0 ws0">国籍</div><div class="t m0 x6 h6 y31 ff3 fs2 fc0 sc0 ls0 ws0"><span class="_ _f"> </span>varchar<span class="_ _4"> </span>20<span class="_ _10"> </span><span class="_ _33"> </span></div></div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div> </body> </html>