《數(shù)據(jù)庫(kù)基礎(chǔ)》課程網(wǎng)站

摘    要

課程網(wǎng)站是21世紀(jì)實(shí)現(xiàn)信息技術(shù)在教學(xué)中應(yīng)用的重要手段和主要平臺(tái)，以其時(shí)效性、共享性、交互性和個(gè)別化等特點(diǎn)，在改革傳統(tǒng)教學(xué)模式、提高教學(xué)質(zhì)量工作中有著不可低估的作用?！稊?shù)據(jù)庫(kù)基礎(chǔ)》課程網(wǎng)站的建設(shè)目標(biāo)是輔助教師課堂教學(xué)，便于學(xué)生學(xué)習(xí)和教師教學(xué)，增強(qiáng)教與學(xué)的交流。
本網(wǎng)站運(yùn)用ASP.NET 3.5和C#技術(shù)，結(jié)合ADO.NET數(shù)據(jù)庫(kù)訪問(wèn)技術(shù)，并以SQL Server 2005作后臺(tái)數(shù)據(jù)庫(kù)服務(wù)器。本網(wǎng)站運(yùn)用了以學(xué)生需求為導(dǎo)向這一創(chuàng)新設(shè)計(jì)理念，功能完善、界面友好，具有一定的實(shí)用性和創(chuàng)新性。通過(guò)課程網(wǎng)站，教師可以上傳課件、習(xí)題指導(dǎo)、實(shí)驗(yàn)指導(dǎo)等資料，為學(xué)生答疑解惑；學(xué)生可以下載資料、發(fā)表留言等。
本文首先介紹了課程網(wǎng)站的發(fā)展和基本現(xiàn)狀，然后介紹了《數(shù)據(jù)庫(kù)基礎(chǔ)》課程網(wǎng)站的系統(tǒng)分析和概要設(shè)計(jì)、數(shù)據(jù)庫(kù)設(shè)計(jì)、功能模塊設(shè)計(jì)、系統(tǒng)測(cè)試等。

關(guān)鍵詞 課程網(wǎng)站；ASP.NET；C#；SQL SERVER
 

THE COURSE WEBSITE FOR “FOUNDAMENTALS OF DATABASE”

ABSTRACT

Course website is the important method and the main platform that can achieve the application of information technology in teaching in 21st century. With its characteristics, such as timeliness, sharing, interaction and individual, it has made the underestimated effect on the reforming the traditional teaching model and improving the quality of teaching. The course website for “Foundamentals of Database" is assisting the classroom teaching, and its objective of construction is to facilitate and enhance the exchanges between the students and the teachers.
This system is build on .NET Platform with ASP.NET 3.5 and C # as programming language and ADO.NET as technology to access SQL Server 2005 database server. We used the innovative design concept of student-oriented and this system has been deployed successfully with rich functionalities, friendly interface, and it should be advanced and more practicality. It can help teachers to update data which download by student like curriculum content, courseware, guidance of exercises and experiments, and answering the questions for students.
After introducing the development and basic status of course web site, this paper describes the system analysis, essentials design, and database design and function module design and system testing of the course website for “Foundamentals of Database”.

KEY WORDS  course website; ASP.NET; C #; SQL SERVER

目錄

摘    要 I
ABSTRACT II
1 系統(tǒng)開(kāi)發(fā)背景 1
1.1課程網(wǎng)站的發(fā)展及基本現(xiàn)狀 1
1.2 系統(tǒng)開(kāi)發(fā)目的及意義 2
2 系統(tǒng)開(kāi)發(fā)技術(shù)及環(huán)境 4
2.1 ASP.NET簡(jiǎn)介 4
2.2 ADO.NET簡(jiǎn)介 4
2.3 SQL SERVER 2005簡(jiǎn)介 5
2.4 系統(tǒng)開(kāi)發(fā)環(huán)境 6
3 系統(tǒng)分析 7
3.1 系統(tǒng)建設(shè)目標(biāo) 7
3.2 系統(tǒng)建設(shè)內(nèi)容 7
3.3 系統(tǒng)設(shè)計(jì)原則 7
3.4 技術(shù)可行性分析 8
3.5 系統(tǒng)角色分析 8
3.6 系統(tǒng)功能分析 8
4 數(shù)據(jù)庫(kù)分析與設(shè)計(jì) 11
4.1 數(shù)據(jù)庫(kù)需求分析 11
4.2 數(shù)據(jù)庫(kù)概念模型設(shè)計(jì) 12
4.3 數(shù)據(jù)庫(kù)邏輯結(jié)構(gòu)設(shè)計(jì) 13
5 系統(tǒng)功能模塊設(shè)計(jì)與實(shí)現(xiàn) 18
5.1 網(wǎng)站首頁(yè)的設(shè)計(jì)和網(wǎng)站內(nèi)容的建設(shè) 18
5.2 注冊(cè)/登錄功能的設(shè)計(jì)與實(shí)現(xiàn) 19
5.2.1 注冊(cè)功能的設(shè)計(jì)與實(shí)現(xiàn) 19
5.2.2 登錄功能的設(shè)計(jì)與實(shí)現(xiàn) 22
5.3 教師權(quán)限的功能設(shè)置和實(shí)現(xiàn) 23
5.3.1上傳課件功能的設(shè)計(jì)與實(shí)現(xiàn) 23
5.3.2回復(fù)留言功能的設(shè)計(jì)與實(shí)現(xiàn) 25
5.3.3編輯參考文獻(xiàn)功能的設(shè)計(jì)與實(shí)現(xiàn) 26
5.4 管理員權(quán)限的功能設(shè)置與實(shí)現(xiàn) 27
5.4.1添加教師信息的設(shè)計(jì)與實(shí)現(xiàn) 27
5.4.2刪除留言信息的設(shè)計(jì)與實(shí)現(xiàn) 28
5.5  學(xué)生及教師用戶添加留言信息功能的設(shè)計(jì)與實(shí)現(xiàn) 29
6 系統(tǒng)測(cè)試與安全維護(hù) 31
6.1 系統(tǒng)測(cè)試 31
6.2 系統(tǒng)的安全維護(hù) 31
7 結(jié)論及展望 33
參考文獻(xiàn) 35
致謝 36