mysql_5.x_manual

  随着在校大学生人数的不断增加，教务系统的数据量也不断的上涨。以往的 选课方法是随堂报名。 这种方法虽然直接， 但是造成选课的盲目性和教务处处理 数据的繁重性。 为了减轻教务处工作， 以及每个学生更好的选择自己所喜欢的科 目。 针对学生选课这一环节， 本系统从学生网上自主选课以及教师的课程发布两 个大方面进行了设计， 基本实现了学生的在线信息查询、

说明：  每组不超过4人，每人从TPC-H中选择至少三个查询进行执行，并进行性能调整。同组人员所选择的查询不能相同。各查询均必须包含：两个以上的表连接操作，其包含至少一个聚集函数。 每位同学的该作业均放在一个命名如“姓名-学号-专业-作业1”的目录中 用尽能想到的所有技术方法，使得选定的查询的某些性能指标尽可能的差 用尽能想到的所有技术方法，使得选定的查询的某些性能指标尽可能的好(Each group has no more than 4 people. Each person selects at least three queries from TPC-H to perform and performs performance adjustment. The queries selected by the same group can not be the same. Each query must contain more than two table join operations, which contain at least one aggregation function. Each student's homework is placed in a directory named "name student number professional operation 1". Using all the technical methods that can be thought of, make certain performance indicators of selected queries as poor as possible. Use all the technical methods that you can think of, and make certain performance indicators of selected queries as good as possible.)

这是我自己写的从数据库中读出数据，并显示，并构成不规则三角网的程序，可以在程序中添加约束线。(This is written in my own读出数据from the database and displays, and triangulated irregular network constitutes the procedure, you can add a constraint in the procedure line.)

出版商印刷数据库设计 初始条件： 一个印刷书的印刷公司希望建立数据库来处理用户的印刷需要。一本书的出版发行人员提交了一份描述印刷工作的单据，印刷工作需要的使用材料，由购买清单指定。 (Publishers print database design initial conditions: a printed book printing company hopes to establish a database to handle the user s printing needs. A book publishing and distribution staff submitted a description of the work of printing documents, printing requires the use of materials, from the purchase of the designated list.)

用MFC做的航空售票系统，是数据库课程设计，全部是自己做的，还不错哦。(MFC to do with air ticketing system is a database of curriculum design, to do all of their own, oh well.)

说明：  通过面向对象的对象-关系映射持久化技术，将一对多以及多对多的数据保存到数据库中并提供查询修改等功能。(Through Object-Oriented Object- Relational Mapping Persistence technology, one-to-many and many-to-many data is saved to the database and to provide features such as query modification.)

简单的通信录，利用DAO（Data Access Object）应用编程接口访问Access数据库(Simple communication was recorded, using DAO (Data Access Object) application programming interface access Access database)

模拟实现锁管理器(Simulation lock manager)

说明：  首先要在登陆系统时有身份验证功能，其次能对有关学生的各类信息的数据进行添加、修改和删除，能对学生成绩的数据进行添加，修改，删除，能对学生信息进行按学号，姓名进行查询，能对学生成绩按照课程号和姓名进行查询；系统管理员除可实现普通用户的操作外还可以添加，修改，删除用户信息，并能对密码进行修改。(We must first login authentication, and second on the data of all kinds of information about students to add, modify and delete student achievement data to add, modify, delete, according to school student information, name queries on student achievement in accordance with the course number and name of the query In addition to the ordinary user of the operation, the system administrator can also add, modify, delete user information, and can modify the password. )

完全用PHP来完成的办公自动化系统，主要是完成对数据库的操作，具有一个办公系统的基本功能。(Entirely in PHP to complete the office automation systems, mainly to complete the database operation, has a basic function of office systems.)