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

摘    要

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

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