文档介绍：邵阳学院
毕业设计(论文)
课题名称图书管理系统
学生姓名
学号
院(系)、专业信息与电气工程系计算机应用与维护
指导教师
职称系统分析师
2006年5 月 18 日
摘要
图书管理系统是典型的信息管理系统,其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面。对于前者要求建立起数据一致性和完整性强、数据安全性好的库。而对于后者则要求应用程序功能完备,易使用等特点。
第一章对图书管理系统问题的提出进行了简明的介绍。第二章对图书管理系统可行性进行研究,是否能开发。第三章分析了图书管理信息系统的应用需求,按照数据库设计理论的要求给出了系统需求说明、全局ER图、系统关系模式,利用 SQL Server 2000建立了数据库。第四章总体设计流程图和数据库的设计。第五章详细设计,实现了数据库表的浏览,记录的添加、删除和修改,报表的生成,实现了多数据库表的连接操作,实现了多条件查询和模糊查询,并灵活实现了对不可更新查询结果集的更新操作,实现了主从表操作,实现了密码维护功能。
关键字:图书,管理,VB,Access 2002,表单,菜单,数据库
Abstract
The books administrative system is typical information management systems , it develops two respects of foundation , maintenance and development of front application program that mainly include backstage supporter's database . Demand to set up consistency of the data and integrality the storehouse of strong , data with good security as to the former. Require to the latter the function of the application program plete , apt characteristic of using etc.
Putting forward introducing the concise one to administrative system question of the books of chapter one. Chapter two carries on research to the administrative system feasibility of the books, can develop . Have analyzed the application demand for the management information system of the books in chapter three, provide systematic demand prove , overall mode , picture of ER and relation of system at the request of design theory of the database, utilize MS SQL Server 2000 to set up the database . The designs of overall design flow diagram of chapter four and database . Chapter five was designed in detail , has realized the having a look around of the database form, adding , deletion and revising recording, formulation of report form, realize many database connection of form operate , realize many condition inquire and not fuzzy to inquire, and has realized it to inquiring about newer operation that the result is collected flexibly non-renewably, have realize watch operates principal and subordinate, has realized the m