无公害农产品数据库的设计——以种植业为例

通过数据库技术对无公害农产品认证的产地、产品及相关信息进行管理是提高认证效率的一个重要手段。本文从我国无公害农产品认证的现状出发，针对认证过程中信息的多源性、时效性、连续性、关联性和多类性的数据特征，采用实体-联系的建模方法，分析认证过程中的产品、产地、标准等实体的属性及其关系，确立农产品认证分类信息、产地信息、产品信息等六类信息，并建立字段和表，构建了基于关系模型的无公害农产品信息数据库，旨在为我国无公害农产品信息的管理提供高效支持。

Design and Realization of Database for Nuisanceless Agro-Food Information in China-A Case Study in Planting

It is very helpful to establish database managing producing area, production quality, environment standard and other relative information of nuisanceless agro-food, for the improvement of nuisanceless agro-food certificating. In this paper, the method of ER was utilized to analyze the properties and interrelations of entities such as agro-food, agro-food area and standard, etc. based on status and data characteristics as multi-sources, time effectiveness, continuity, relationship and multi-category of nuisanceless agro-food certification. The relational database of nuisanceless agro-food was accomplished by the classification of the information of nuisanceless agro-food and establishment of tables and the fields, and the objective was to provide an efficient support for the management of nuisanceless agro-food information.