数据库设计 国家表 国家编号:char(3) 国名：vARCHAR(50) 省市表 省市编号：char(3) 省市名：varchar(50)

(1)要求查找”中国河北省“的所有县名。该如何查找，写出SQL语句

SELECT

县郡表.县郡名

FROM

国家表 JOIN 省市表 ON ( 国家表.国家编号 = 省市表.国家编号 )

JOIN 县郡表 ON ( 县郡表.省市编号 = 省市表.省市编号 )

WHERE

国家表.国名 = '中国' AND 省市表.省市名 = '河北'

（2）在功能不变的前提下，将上述三表合并成一个表，该如何设计？在你的设计中，实现上述查找的SQL语句该如何写

CREATE TABLE 国省县 (

国名：vARCHAR(50),

省市名：varchar(50),

县郡名：VarChar(50)

)

SELECT

县郡名

FROM

国省县

WHERE

国名 = '中国' AND 省市名 = '河北'

The management information system is by the artificial leadership, using the computer hardware, software, the network communication facility and all that office equipments, constructs an information platform, carries on the information the collection, the transmission, the processing, the storage, the renewal and the maintenance, unexpectedly is superior take the enterprise strategy, enhances the benefit and the efficiency as the goal, supports the enterprise high level decision-making, the intermediate deck control, the basic unit operation integration man-machine system. And, will have the joint operation ability information management system to be able to facilitate in the enterprise between the subordinate and various departments the prompt communication, was advantageous to the information and the work flow union, thus reduced the cost reduction repetition work, the promotion exchange and the cooperation, the better enhancement working efficiency, sped up the work progress. The E-WORK business management system based on the B/S structure, uses Java, Jsp, Structs, Servlet, tool and the technology and so on SQL Server. This article designed and has realized the public resource subsystem. This subsystem divides according to the function into the conference room management subsystem, the conference room appointment management subsystem, the conference room service condition subsystem and informs the management subsystem four parts. This article mainly elaborated the conference room manages the subsystem the design and the realization. Its function includes: The conference room information examined that, the conference room newly built, the conference room revises, the conference room deletion. The main content includes: The outline design, the detailed design, the test reported, as well as appendix. The detailed content includes: Each function design thought and flow chart, database table establishment and data, database connection essential technology description. In the test method, the test process, the test result as well as the present system exist flaw and insufficiency. This report mainly is composed by following five parts: The first part simply explains this development topic the significanceThe second part introduced this system development outline designThe third part introduced this system development detailed designThe fourth part is includes the system development later period to design in the process the test plan and the test reportThe fifth part is realizes the function summary to this system.

Key word：Enterprise public resource, conference room management, B/S structure, JSP, Struts overhead construction

The Manage of the information system is a to predominate with the factitiousness, making use of the calculator hardware, software, the network correspondence equipments and other transact the equipments, set up an information-based terrace, carry on the collections of information and deliver, process, store, renew and support, with the business enterprise strategy is unexpectedly excellent and raises the performance and efficiencies for purpose, support the business enterprise key figures decision, intermediate control, the basic level operate of gather person's machine system that turn.And, the information management system that owns to be in conjunction with the work ability will of the convenient business enterprise top and bottom class and each section communicate in time, be advantageous to information's combining with the workflow, thus declining low cost reduce the repetition labor, promote communicate with the cooperation, better exaltation work efficiency, speed the work degree of progress.

The E- WORK business enterprise management system according to structure of B/ S, the adoption Java, Jsp, Structs, Servlet, the SQL Server etc. tool and technique.This text design and carried out the public resources sub- system.The son's system presses the function demarcation to manage the sub- system, board room to reserve to manage the sub- system, the board room usage circumstance sub- system and circulars to manage the sub- system for the board room for four-part cent.

This text mainly elaborated that the board room manages the design and the realization of the sub- system.Its function include:The board room information look into, the board room sets up lately, the board room modification, board room delete.The main contents include:Essentials design, detailed design, test report, and appendix.The detailed contents have:The design thought and flow charts of each function, the establishment of the database form and among them of data, technical description of the key of the database conjunction.Test the method, the test process, test result and currently system in existent blemish and shortage.

This report mainly is constitute by following five partses:The first part explains this time meaning of development topic in briefThe second part introduced this system development essentials designThe third part introduced detailed design of this system developmentThe four-part cent is to include the system development to expect to design the test in the process project and test reports behindThe fifth part is to this system function carry out of summary.

The management information system is by the artificial leadership, using the computer hardware, software, the network communication facility and all that office equipments, constructs an information platform, carries on the information the collection, the transmission, the processing, the storage, the renewal and the maintenance, unexpectedly is superior take the enterprise strategy, enhances the benefit and the efficiency as the goal, supports the enterprise high level decision-making, the intermediate deck control, the basic unit operation integration man-machine system. And, will have the joint operation ability information management system to be able to facilitate in the enterprise between the subordinate and various departments the prompt communication, was advantageous to the information and the work flow union, thus reduced the cost reduction repetition work, the promotion exchange and the cooperation, the better enhancement working efficiency, sped up the work progress. The E-WORK business management system based on the B/S structure, uses Java, Jsp, Structs, Servlet, tool and the technology and so on SQL Server. This article designed and has realized the public resource subsystem. This subsystem divides according to the function into the conference room management subsystem, the conference room appointment management subsystem, the conference room service condition subsystem and informs the management subsystem four parts. This article mainly elaborated the conference room manages the subsystem the design and the realization. Its function includes: The conference room information examined that, the conference room newly built, the conference room revises, the conference room deletion. The main content includes: The outline design, the detailed design, the test reported, as well as appendix. The detailed content includes: Each function design thought and flow chart, database table establishment and data, database connection essential technology description. In the test method, the test process, the test result as well as the present system exist flaw and insufficiency. This report mainly is composed by following five parts: The first part simply explains this development topic the significanceThe second part introduced this system development outline designThe third part introduced this system development detailed designThe fourth part is includes the system development later period to design in the process the test plan and the test reportThe fifth part is realizes the function summary to this system.

The Manage of the information system is a to predominate with the factitiousness, making use of the calculator hardware, software, the network correspondence equipments and other transact the equipments, set up an information-based terrace, carry on the collections of information and deliver, process, store, renew and support, with the business enterprise strategy is unexpectedly excellent and raises the performance and efficiencies for purpose, support the business enterprise key figures decision, intermediate control, the basic level operate of gather person's machine system that turn.And, the information management system that owns to be in conjunction with the work ability will of the convenient business enterprise top and bottom class and each section communicate in time, be advantageous to information's combining with the workflow, thus declining low cost reduce the repetition labor, promote communicate with the cooperation, better exaltation work efficiency, speed the work degree of progress.

The E- WORK business enterprise management system according to structure of B/ S, the adoption Java, Jsp, Structs, Servlet, the SQL Server etc. tool and technique.This text design and carried out the public resources sub- system.The son's system presses the function demarcation to manage the sub- system, board room to reserve to manage the sub- system, the board room usage circumstance sub- system and circulars to manage the sub- system for the board room for four-part cent.

This text mainly elaborated that the board room manages the design and the realization of the sub- system.Its function include:The board room information look into, the board room sets up lately, the board room modification, board room delete.The main contents include:Essentials design, detailed design, test report, and appendix.The detailed contents have:The design thought and flow charts of each function, the establishment of the database form and among them of data, technical description of the key of the database conjunction.Test the method, the test process, test result and currently system in existent blemish and shortage.

This report mainly is constitute by following five partses:The first part explains this time meaning of development topic in briefThe second part introduced this system development essentials designThe third part introduced detailed design of this system developmentThe four-part cent is to include the system development to expect to design the test in the process project and test reports behindThe fifth part is to this system function carry out of summary.

Information management system is a factitiousness-predominated system and to construct a info-platform for collecting, transferring，processing, conserving, renewing, and maintaining of information using computer hardware, software, network communication equipments, and other office equipments as the main developmental tools. Its objective is the strategic competitive optimization and the improvement of the benefit and efficiency of the enterprises, it is also an integrated human-computer system supporting high-level decision-making, medium control, and ground level running of the enterprises. Additionally, the information management system with cooperated working ability will bring conveniences to the in-time communication among various levels and departments in the enterprises, it will be propitious to the combination of information and working flow, therefore decreases repeated laboring and promotes the communication and cooperation, improves the work efficiency, and accelerates the work rate of progress.

E-WORK enterprise management system uses the following technologies and tools as Java、Jsp、Structs、Servlet、SQL Server based on Browser/Client (BS) structure. This paper designed and fulfilled the sub-system of public resource. The subsystem could be divided into four parts as follows: the meeting room management sub-system, the meeting room booking management subsystem, the meeting room using subsystem, and the informing management subsystem.

This paper mainly expatiated the design and fulfillment of meeting room management sub-system. Its functions include: meeting room info-viewing, meeting room newly construction, meeting room modification, and meeting room deleting. Its main content includes: outline design, detail design, measuring report, and the addendum. Its detailed content covers: the designing ideology and the flow chart of each function, the establishment of the database and the key technology of the linkage between the database and the data contained in it. And the methods, course, and results of the measurement as well as the flaws presented in current system were also discussed.

The report is composed of five parts as follows: the first part is a brief explanation of the significance of this themethe second part introduces the developmental concept of this systemthe third part introduces the design of this system in detailsthe fourth part is the measuring scheme and report including the exploring anaphase of the systemand the fifth part summarized the practical functions of this system.

1.典型地质遗迹基本概况表

包括地理位置、园区范围、自然条件等组成(表6-2)。

表6-2 基本概况(JBGK.MDB)数据库结构表

数据项说明:

地质公园编号:前3位国别代码，按行政区划代码(GB/T2260－98)填写，后3位地质遗迹点的顺序号。当公园范围较大，跨国界时，其编号以主景区所在的区域为准进行编号，后6位为顺序号，保证地质遗迹编号的唯一性。

地质遗迹分类:为适应现阶段地质遗迹的调查，地质公园建设和发展规划、科学普及的开展，以系统地球科学理论为指导，赵汀(2009)提出了显性地质遗迹的概念并建立了学科分类系统，并在此基础上完成了中国国家地质公园地质遗迹分类。

2.景区、景点数据(表6-3，表6-4)

表6-3 景区表结构(JQ.MDB)表

表6-4 景点表结构(JD.MDB)表

景区和景点数据关系(表6-5)为一对多关系。即，一个景区至少有一处以上的景点，任意一个景点只能属于某一个景区。

---