數(shù)據(jù)庫系統(tǒng)原理課程設(shè)計(jì)--報(bào)刊訂閱管理系統(tǒng)(編輯修改稿)
2025-02-12 16:58 本頁面
【文章內(nèi)容簡介】 /OOrderC/OCustomerLoginDidUnitpriceDnameIfoTotalUnitpriceQuantityQishuOnoCidCnameAddressPhoneUnameUpasswordOdate三、邏輯結(jié)構(gòu)設(shè)計(jì)，優(yōu)化分析Customer（Cid，Cname，Phone，Address）Order（Ono，Cid，Odate）Orderdetail(Ono，Did，Quantity，Qishu，Unitprice，Total)Diretory(Did，Dname，Unitprice，Ifo)Login(Uname，Upassword)Orderdetail表屬于第二范式，其余表都屬于BCNF范式：（Ono，Did）—Quantity，（Ono，Did）—Qishu，（Ono，Did）— Unitprice，（Quantity，Qishu，Unitprice）—Total，（Ono，Did）—Total（Total表獨(dú)立出來有利于統(tǒng)計(jì)查詢，減少反復(fù)運(yùn)算）：報(bào)刊訂閱管理系統(tǒng)登錄模塊管理功能查詢功能報(bào)表導(dǎo)出登錄驗(yàn)證修改管理員信息添加管理員信息訂戶管理目錄管理訂單管理訂單查詢統(tǒng)計(jì)查詢用戶查詢目錄查詢導(dǎo)出結(jié)果增加訂戶修改訂戶刪除訂戶增加目錄修改目錄刪除目錄增加訂單修改訂單刪除訂單四、物理結(jié)構(gòu)設(shè)計(jì)為各個(gè)表建立索引；數(shù)據(jù)和索引放在磁盤中；按需進(jìn)行系統(tǒng)配置；觸發(fā)器框架CREATE TRIGGER 觸發(fā)器名 ON 數(shù)據(jù)表名或視圖名 AFTER INSERT或DELETE或UPDATEAS BEGIN 這里是要運(yùn)行的SQL語句ENDGO實(shí)例：創(chuàng)建一個(gè)Delete觸發(fā)器CREATE TRIGGER truCustomer ON Customer AFTER DELETE AS BEGIN Delete BorrowRecord From BorrowRecord br , Deleted Where br. CustomerID=d. CustomerID ENDGO創(chuàng)建一個(gè)Update觸發(fā)器CREATE TRIGGER truCustomer ON Customer AFTER UPDATEAS if Update(Customer) BEGINUpdate BorrowRecord Set CustomerID=i. CustomerID From BorrowRecord br , Deleted ,Inserted iDeleted和Inserted臨時(shí)表Where br. CustomerID=d. CustomerIDENDGO(1)使用存儲過程輸出Customer表中所有信息Create procedure UpdateCustomer@Cid varchar(10),@Cname varchar(50),@Phone varchar(15),@Address varchar(50)AsUpdate CustomerSet Phone =@ Phone，Address =@ AddressWhere Cid=@Cid and Cname =@ CnameEndCreate procedure insertCustomer@Cid varchar(10),@Cname varchar(50),@Phone varchar(15),@Address varchar(50)AsbeginInsert into Customer(Cid, Cname, Phone, Address)Values(@Cid ,@ Cname,@ Phone, @ Address)管理員賬戶管理員密碼待修改密碼操作
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1