數(shù)據(jù)庫課程設(shè)計(jì)旅行社管理信息系統(tǒng)(廣工)(編輯修改稿)
2025-05-04 23:10 本頁面
【文章內(nèi)容簡(jiǎn)介】 1 用戶信息表 安全性設(shè)計(jì)該系統(tǒng)的只提供兩種用戶，一種是管理員，另一種是普通用戶，管理員具有對(duì)數(shù)據(jù)庫操作的所有權(quán)限，普通用戶的權(quán)限受限，只能對(duì)用戶個(gè)人信息進(jìn)行修改或者報(bào)名旅游。 一致性設(shè)計(jì)主要是對(duì)數(shù)據(jù)庫表的三種完整性進(jìn)行設(shè)計(jì)：實(shí)體完整性：通過對(duì)每個(gè)關(guān)系表設(shè)置主鍵實(shí)現(xiàn)。參照完整性：通過對(duì)不同表設(shè)置外鍵聯(lián)系實(shí)現(xiàn)圖32 數(shù)據(jù)表的參照完整性圖用戶自定義完整性：在該系統(tǒng)中，并無用戶定義的自定義完整性約束。通過6個(gè)表的外鍵聯(lián)系構(gòu)成實(shí)現(xiàn)截圖：圖33 視圖設(shè)計(jì)圖實(shí)現(xiàn)代碼：CREATE VIEW INOFRMATIONASSELECT ,h_name,h_lea,h_value, e,FROM TLINE,TNUM,TGROUP,TGUIDE,TINSURANCE,TCOM,TFOOD,THOTELWHERE = AND = AND = AND = AND = AND = AND =4 詳細(xì)設(shè)計(jì)與實(shí)現(xiàn) 創(chuàng)建數(shù)據(jù)庫（TLINE）用來記錄旅游的線路信息CREATE TABLE TLINE( l_num int PRIMARY KEY, l_start varchar(20) not null, l_end varchar(20) not null, l_day int, l_view varchar(60) )。圖41 旅游線路實(shí)現(xiàn)圖（TNUM）用來記錄該旅游班次出發(fā)與回程的時(shí)間工具等CREATE TABLE TNUM( n_num int PRIMARY KEY, l_num int, n_stand varchar(20), n_value int, n_gt varchar(15), n_gd varchar(10), n_gm int, n_got varchar(8), n_bt varchar(15), n_bd varchar(10), n_bm int, n_bat varchar(8), FOREIGN KEY (l_num) REFERENCES TLINE(l_num) )。圖42 旅游班次表實(shí)現(xiàn)圖（TGROUP）用來記錄該旅游號(hào)的旅游班次及團(tuán)名人數(shù)等相關(guān)信息CREATE TABLE TGROUP( g_num int PRIMARY KEY, n_num int, g_name varchar(20), g_sum int, g_pep varchar(20), g_add varchar(30), g_tel varchar(15), FOREIGN KEY (n_num) REFERENCES TNUM(n_num) )。圖43 旅游團(tuán)表實(shí)現(xiàn)圖（TVISITOR）記錄了該游客編號(hào)所報(bào)名的旅游團(tuán)CREATE TABLE TVISITOR( v_num int, g_num int, PRIMARY KEY(v_num,g_num), FOREIGN KEY (v_num) REFERENCES TUSE(v_num), FOREIGN KEY (g_num) REFERENCES TGROUP(g_num) )。圖44 游客表實(shí)現(xiàn)圖（TGUIDE）記錄導(dǎo)游的相關(guān)信息CREATE TABLE TGUIDE( u_num int PRIMARY KEY, u_name varchar(20), u_sex varchar(5), u_age int, u_id varchar(20), u_add varchar(35), u_tel varchar(15), u_lan varchar(20), u_lea varchar(5), u_ach varchar(30) )。圖45 導(dǎo)游表實(shí)現(xiàn)圖（THOTEL）用于記錄賓館的相關(guān)信息CREATE TABLE THOTEL( h_num int PRIMARY KEY, h_name varchar(20), h_city varchar(20), h_lea varchar(5), h_value int, h_pep varchar(20), h_post varchar(20), h_add varchar(35), h_tel varchar(15), h_fax varchar(20) )。圖46 賓館表實(shí)現(xiàn)圖（TINSURANCE）用于記錄不同旅游團(tuán)交保險(xiǎn)金額及時(shí)間等CREATE TABLE TINSURANCE( i_num int PRIMARY KEY, g_num int, i_value int, i_date varchar(10), FOREIGN KEY (g_num) REFERENCES TGROUP(g_num) )。圖47 保險(xiǎn)表實(shí)現(xiàn)圖（TCOM）指明旅游班次的導(dǎo)游人CREATE TABLE TCOM( n_num int PRIMARY KEY, u_num int, FOREIGN KEY (n_num) REFERENCES TNUM(n_num), FOREIGN KEY (u_num) REFERENCES TGUIDE(u_num))。圖48 陪同表實(shí)現(xiàn)圖（TFOOD）用于指明旅游班次的居住酒店CREATE TABLE TFOOD( n_num int PRIMARY KEY, h_num int, FOREIGN KEY (n_num) REFERENCES TNUM(n_num), FOREIGN KEY (h_num) REFERENCES THOTEL(h_num))。圖49 食物表實(shí)現(xiàn)圖（TUSE）用于存儲(chǔ)注冊(cè)用戶的用戶名及密碼等信息CREATE TABLE TUSE( k_name varchar(15)PRIMARY KEY, k_key varchar(15)NOT NULL, k_status int NOT NULL,
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1