【正文】 。 通過此次數(shù)據(jù)庫的課程設計，真正達到了學與用的結合，增強了對數(shù)據(jù)庫方面應用的理解，對自己今數(shù)據(jù)庫原理 課程設計說明書 26 后參與開發(fā)數(shù)據(jù)庫系統(tǒng)積累了不少經(jīng)驗，在實驗過程中，從建立數(shù)據(jù)開始，對數(shù)據(jù)庫設計理念及思想上有更高的認識，從需求分析，到概念設計和邏輯設計， ER圖的表示，數(shù)據(jù)字典的創(chuàng)建，懂得了不少有關數(shù)據(jù)庫開發(fā)過程中的知識，增強了自己在數(shù)據(jù)庫中應用 SQL 語言的靈活性，其中包括，插入、刪除、修改、查詢 ,牽涉表和表之間 的聯(lián)系，主建與外主鍵的定義，約束項的設置，使邏輯更嚴密，在學習過程中，我也能過上網(wǎng)查了不少資料，也看了一些別人設計的旅館管理信息系統(tǒng)的設計報告，學以致用，自我創(chuàng)新，獨立完成了這份自己的報告，從中在學到用，從用又到學，不斷修改，系統(tǒng)更新。 where room_id=room_id END CREATE PROCEDURE [dbo].[leaveRoom] book_id int, totalConsume decimal(18,1), room_id int, fee decimal(18,1), balance decimal(18,1), client_id int, state varchar(10), bookState varchar(20), liveState varchar(20), leaveTime datetime AS BEGIN UPDATE book SET leaveTime = leaveTime, liveState = liveState, bookState = bookState, fee = fee, balance = balance where book_id =book_id UPDATE room SET state = state where room_id=room_id UPDATE client SET totalConsume = totalConsume where client_id=client_id END 經(jīng)歷了兩周的數(shù)據(jù)庫課程設計，我從開始只知道寫幾句 SQL語句到對數(shù)據(jù)庫設計有了一個全新的認識，從理論上升到了實踐的高度，收獲頗豐。) 空房視圖 CREATE VIEW [dbo].[roomInfo] AS SELECT , , , , , FROM INNER JOIN ON = 數(shù)據(jù)庫原理 課程設計說明書 24 房間信息視圖 CREATE PROCEDURE [dbo].[type_insert] type_name varchar(20), introduction text, facility varchar(100), breakfast varchar(10), benDesc varchar(20), price decimal(18, 1), subsFee decimal(18, 1) AS BEGIN insert into roomType (type_name,introduction,facility,breakfast,benDesc,price,subsFee)values (type_name,introduction,facility,breakfast,benDesc,price,subsFee) END CREATE PROCEDURE [dbo].[book_insert] client_id int, room_id int, isSubscription int, days int, liveTime datetime, prePay decimal(18,1), liveState varchar(20), bookState varchar(20), fee decimal(18,1), 數(shù)據(jù)庫原理 課程設計說明書 25 balance decimal(18,1) AS BEGIN INSERT INTO book (client_id, room_id, isSubscription, days, liveTime, prePay, liveState, bookState, fee, balance) VALUES (client_id,room_id,isSubscription,days,liveTime,prePay,liveState,bookState,fee,balance) UPDATE room SET state =39。 create view [dbo].[accountInfo] as select [user_id],loginAccount,password from [user] 數(shù)據(jù)庫原理 課程設計說明書 22 賬號信息視圖 單視圖 CREATE view [dbo].[bill] as select distinct 訂單號 , 客戶姓名 , 房間號 ,type_name 類型名 , 單價 ,days 天數(shù) ,prePay 預支 , 消費金額 ,balance 余額 ,liveTime 入住時間 from book,client,room,roomType,[level] where = and = and = 賬單視圖 create view [dbo].[clientInfo] as SELECT client_name, client_sex, identityld, , totalConsume, [level].level_name, [level].rate FROM client INNER JOIN [level] ON = [level].level_id 數(shù)據(jù)庫原理 課程設計說明書 23 客戶信息視圖 create view [dbo].[emptyRoom] as SELECT AS 房間號 , AS 房間類型 , AS 床位描述 , AS 價格 , AS 訂金 , AS 狀態(tài) FROM room INNER JOIN roomType ON = WHERE ( = 39。 where type_name=39。 數(shù)據(jù)庫原理 課程設計說明書 15 ： /* Table: book */ /*==============================================================*/ create table book ( book_id int not null, client_id int not null, room_id int not null, issubscription bit null, days int null, livetime datetime null, leavetime datetime null, prepay int null, livestate varchar(20) null, bookstate varchar(20) null, fee int