数据库系统原理课程设计报告.doc

1、carried out practice line pioneer standard, and post spurs members concentrated service months, activities, education guide members always everywhere bearing in mind identity, based job post, active play role. To develop differentiated learning education guide party members in accordance with their

2、own situation, target the problems to, based on the work done. Pay attention to the room and room for grass-roots party organizations, grass-roots party organizations have more autonomy in education, making education more ground, full of vitality, good effect. Finally, highlight the normal long-term

3、. To highlight the characteristics of recurrent education, with long flowing, continuous line of perseverance the perseverance to promote educational efforts to realize the partys ideological and political construction of routine institutionalization. With the party branch as the base unit. Play the

4、 role of party branches should be, is the key to educational success. Each branch must take strict education and management responsibility of party members, education based on learning to make specific arrangements, fully mobilize the enthusiasm of party members involved in the education, ensure the

5、 Organization in place, measures in place, put in place. To the party organization as the basic form. In the standardized development of learning, make learning more effective efforts, and will adhere to the good party group, organized party, party members and the General Assembly, tell a good party

6、 lectures, can drive a good topic about, prevent showy without substance, Sham mules. To implement the education management system for basic support. Democratic mutual evaluation on party members in accordance with the regulations, the real performance criteria and order established, sound carefully

7、 dispose of unqualified party members, to further improve the dredge export team, pure self cleaning mechanism. Party leading cadres should adhere to and implement the central group learning system, to which branch of learning exchanges, participation in a dual organization with comrades. Focus on r

8、ecurrent education, you also need to continue to strengthen the building of grass-roots party organizations. Now, the city also has 88 village party organizations are weak and lax, first Secretary of the village, but conversion requires a process. Recently, the citys party organization focused inves

9、tigation, check out a total of lost members 4,507, Pocket members 1037, find there are 640 lost party members are not contacted 148 Pocket party members and implementation of organizational relationships. Educational management of party members into the Organization, there is a lot of work to do. We

10、ak and lax party continued reorganization as an important task, finish perfect organization, with a good team, Good system. Special highlights of grass-roots party organizations, to be dealt with first in place, further education, reorganization, transformation and educational interaction. In short,

11、 through solid and effective work initiatives数据库系统原理课程设计报告-平面设计公司业务管理系统姓 名： 学 号： 指导老师： 起始时间：2010年3月3日结束时间：2010年5月28日目录第一章概述31.1项目背景31.2编写目的31.3软件定义31.4开发环境3第二章需求分析32.1信息要求42.处理要求42.3安全性与完整性要求5第三章概念设计53.1整体E-R图53.2用户E-R图63.3客户E-R图63.4员工E-R图63.5稿件E-R图73.6单据E-R图7第四章逻辑结构设计74.1用户关系表74.2客户关系表74.3稿件关系表84.4

12、员工关系表84.5单据关系表9第五章主要模块设计与代码95.1登录模块设计95.2主界面模块设计105.3信息修改模块设计125.4业务信息模块设计145.5综合查询模块设计185.6连接数据库模块设计19第六章总结19第七章参考文献20第一章 概述1.1项目背景该公司经营平面设计业务。业务员负责联系业务，并将客户的设计要求进行登记，然后交由设计人员设计。设计完成后由专人负责送货并收款。客户每次的设计要求可能多个不同规格的稿件，这次要求的所有稿件构成一份单据，称为为“预订单”。设计人员从预订单中选取其中的一个进行设计，正在设计中的预订单称为“在建单”，已经完成设计的在建单称为“送货单”，已经送

13、货的送货单称为“历史单”。设计人员一旦开始设计某一预订单，就必须负责完成预订单、在建单、送货单三个流程。业务员的月薪按照每月联系的业务提成3%；、设计员的月薪按照每月完成的设计单提成3%；送货人的月薪按照每月送货的业务提成1%。1.2 编写目的从案例来讲，随着公司业务的增多，需要一个完善的业务系统来管理，在此平台上公司能更好的运作；从个人来讲，为了更好地了解数据库，同时提高自己的动手能力。1.3软件定义用VB和SQL共同构建适合公司日常业务操作的应用程序。1.4开发环境 普通PC机一台，安装Microsoft Visual Basic / Microsoft SQL sever。第二章 需求分

14、析2.1信息要求用户基本信息：用户姓名、用户密码、权限。客户基本信息：客户名称、联系人、联系人电话、传真、邮箱、公司地址。稿件基本信息：稿件名称、长度宽度、规格、色数、输出机型、P数。员工基本信息：编号、员工名、性别、职位、月薪、出生日期、入职日期、联系电话、联系地址。单据基本信息：单号、性质、客户名称、营业员、设计者、送货人、创建及送货日期。（单据性质包括预订单、在建单、送货单、历史单）2.2处理要求 系统的功能模块大体可以设计成如图1-1所示。登陆界面主界面员工信息管理界面业务信息查询管理界面客户信息管理界面信息修改管理界面综合信息查询界面 预订单在建单送货单历史单所有单单据信息修改稿件信

15、息修改图1-1 系统功能模块图从登录用户上看，登录用户需要使用该系统对全体用户的资料进行维护和管理，可以进入各个界面查看和修改，以便对各个员工的工作进行监督和干涉。2.3安全性与完整性要求系统数据完整性与安全性要求如下：从用户基本信息上看，系统要求必须有用户姓名、用户权限、密码等。密码或用户名字错误无法登陆。从稿件基本信息上看，系统要求每张稿件必须有稿件名称、长度宽度、规格、色数、机型等。允许登陆用户修改信息。从客户基本信息上看，系统要求每位客户都必须有客户名称、联系人、联系电话、公司地址等。允许登陆用户修改信息。从单据基本信息上看，系统要求单据必须必须有单号、性质、客户名称、营业员、设计者、送货人、创建及送货日期。允许登陆用户修改信息。第三章 概念设计3.1整体E-R图根据上面的定义