【正文】 數(shù)據(jù)庫課程設(shè)計(jì)校友信息管理系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn)計(jì)算機(jī)科學(xué)與工程學(xué)院2022 年 6 月數(shù)據(jù)庫課程設(shè)計(jì)校友信息管理系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn)小組成員：王 蕾、趙曉君 張躍勇、王清霖指導(dǎo)教師：張沛露專 業(yè)： 計(jì)算機(jī)科學(xué)與技術(shù)所在單位：計(jì)算機(jī)科學(xué)與工程學(xué)院數(shù)據(jù)庫課程設(shè)計(jì)（報(bào)告）摘要數(shù)據(jù)庫技術(shù)是計(jì)算機(jī)軟件的一個(gè)重要分支，它產(chǎn)生于 20 世紀(jì) 60 年代，最早是由 IBM 公司推出的 IMS 數(shù)據(jù)庫系統(tǒng)。SQL Server 是微軟公司開發(fā)的數(shù)據(jù)庫產(chǎn)品，SQL Server 2022 被廣泛使用，很多電子商務(wù)網(wǎng)站、企業(yè)內(nèi)部信息化平臺(tái)等都是基于 SQL Server 產(chǎn)品上。 SQL Server 2022 能夠?yàn)閿?shù)據(jù)管理與分析帶來靈活性，其具有強(qiáng)大的功能。在現(xiàn)在的網(wǎng)絡(luò)應(yīng)用中，用戶是網(wǎng)絡(luò)應(yīng)用的中心，如現(xiàn)今最風(fēng)靡的校內(nèi)網(wǎng)都是把用戶放到了網(wǎng)絡(luò)應(yīng)用的第一位。而校內(nèi)網(wǎng)的成功和風(fēng)靡在很大程度上是因?yàn)樗且粋€(gè)真實(shí)的社交網(wǎng)絡(luò)，校友信息管理系統(tǒng)也是利用了真實(shí)的社交網(wǎng)絡(luò)進(jìn)行設(shè)計(jì)和開發(fā)的。隨著互聯(lián)網(wǎng)的發(fā)展，越來越多的交流社區(qū)應(yīng)用被廣泛的接受，這些社區(qū)的存在都是為了能夠加強(qiáng)人與人之間的交流。在針對(duì)現(xiàn)有的系統(tǒng)進(jìn)行調(diào)查，擬開發(fā)一套校友信息管理系統(tǒng)進(jìn)行校友聯(lián)絡(luò)，這樣不僅方便校友之間的聯(lián)絡(luò)，也能夠加強(qiáng)老校友和新校友的感情。它是面向?qū)W生的一個(gè)暢通的校友溝通平臺(tái)，它可以方便地實(shí)現(xiàn)校友與母校、校友與校友之間的溝通?，F(xiàn)在眾多高校都已經(jīng)擁有了自己的校友信息管理系統(tǒng)網(wǎng)站，從而為學(xué)校與校友之間進(jìn)行交流和聯(lián)系搭建了一個(gè)方便、快捷、通暢的溝通平臺(tái)。論文通過分析校友信息管理系統(tǒng)的特點(diǎn)，選用 Java 和SQL Server 2022 數(shù)據(jù)庫設(shè)計(jì)了一套具有注冊(cè)登錄、信息管理、查詢信息、修改信息、增加信息、瀏覽信息等功能的校友信息管理系統(tǒng)，用于實(shí)現(xiàn)校友與母校、校友與校友之間的溝通。關(guān)鍵詞：校友 ；信息管理 ； 增加信息 ； 修改信息 ； 數(shù)據(jù)庫 數(shù)據(jù)庫課程設(shè)計(jì)（報(bào)告）IABSTRACTDatabase technology is an important branch of puter software, which was produced in the 60 39。s in twentieth Century, and the IMS database system, which was first introduced by IBM pany in. Server SQL is the database products of Microsoft Corp, Server SQL 2022 is widely used, many emerce sites, enterprise internal information platform, etc. are based on Server SQL products. Server SQL 2022 can bring the flexibility of data management and analysis, it has a powerful function. In today39。s work applications, the user is the center of work applications, such as the most popular in the campus work is the first place to put the user into the work application. The success and popularity of the campus work is largely because it is a real social work, the alumni information management system is also used to design and development of real social works.With the development of the Inter, more and more munication munity is widely accepted. The existence of these munities is in order to strengthen the munication between people. In according to the existing system investigation, intends to develop a set of alumni an information management system for alumni, which is not only convenient liaison between the alumni, but also to strengthen the feelings of the old alumni and alumni. It is a smooth munication platform for students, which can easily realize the munication between alumni and alma mater, alumni and alumni. Now many colleges and universities have already had their own alumni website, so as to carry out exchanges and contacts between the school and alumni to build a convenient, fast and smooth munication platform. Through the analysis of the alumni record the characteristics of using Java and SQL Server 2022 database design a set with register and login, information management, information query, modify the information, add information, browse information and other functions of the alumni of the system, to realize the munication between alumni and their alma mater, alumni, and alumni.Key words : Delphi alumni 。 information management 。 information management 。 information 。 modification 。 database數(shù)據(jù)庫課程設(shè)計(jì)（報(bào)告）II目錄摘要 .....................................................................................................................................................IABSTRACT............................................................................................................................................II目錄 ...................................................................................................................................................III第 1 章 概述 ................................................................................................................................... 1 項(xiàng)目開發(fā)來源 ............................................................................................................................... 1 項(xiàng)目開發(fā)目標(biāo)及意義 ................................................................................................................... 1 系統(tǒng)的調(diào)研及可行性分析 ........................................................................................................... 2 系統(tǒng)調(diào)研 ............................................................................................................................... 2 系統(tǒng)的總體目標(biāo) ................................................................................................................... 2 可行性研究 ........................................................................................................................... 2 第 2 章 需求分析 ............................................................................................................................ 4 需求分析 ...................................................................................................................................... 4 功能需求分析 ....................................................................................................................... 4 數(shù)據(jù)需求分析 ....................................................................................................................... 5 系統(tǒng)數(shù)據(jù)字典 ....................................................................................................................... 6 數(shù)據(jù)