高速公路工程进度管理系统数据库设计

利用数据库设计的基本理论，以省市两级管理体制为模板，从组织机构和数据流程2个方面分析高速公路工程进度管理的实际需求，指出进度管理系统中的主要实体，包括：高速公路、城市、标段、路基路面工程、桥梁工程、分部工程、分项工程。详细分析实体之间的关系，得到它们之间的实体－关系图，并据此设计进度管理系统数据库结构。设计成果已在江苏省的高速公路建设中得到实际应用。

Database Design of Expressway Progress Management Systems

Based on the database design theory, the practical demand of expressway construction progress management is analyzed using the province city two level management structure as the template. Main entities involved in progress management are clearly picked out, including expressway, city, bid section, sub base and pavement, bridge, subsection, subentry. The relations between them are discussed in detail, and the E R diagrams are achieved. Based on the analysis, the database design of progress management system is given. And the practice of database design result in Jiangsu province is given as an example.