摘要
建立基于关系型数据库的农产品安全背景数据库可为安全农产品生产提供重要的辅助依据。文章从数据库设计的角度出发,根据浙江省农业地质环境与农产品安全背景数据库管理系统的需求,利用实体关系分析法得出实体。分析实体之间的关系,进行包括数据库概念设计、逻辑设计和物理设计。采用MSAccess构建数据库,用VB开发数据库管理系统,实现数据维护、数据查询、数据统计及报表打印等功能。
<Abstrcat>Establishing background database of main agricultural product safety which based on relational database can provide the essential information and support of crop safety production. Based on the database designing theory and the system requirement, the entities of the system were analyzed by the entity-relation method in present study. The database was designed according to the relation analysis of entities. The design included concept design, logic design, and physical design. Database was established by using Microsoft Access software. Finally, a database management system, which owning some functions of data maintenance and consult, data statistics, and print of report forms, was developed under the Visual Basic environment.
出处
《浙江农业学报》
CSCD
2005年第3期138-142,共5页
Acta Agriculturae Zhejiangensis
基金
浙江省科技计划项目(2004C32066)
关键词
背景数据库
数据库设计
空间数据
属性数据
浙江省
background database
database design
spatial data
attribute data
zhejiang provice
