通信资源数据库设计

摘要

Communication equipment has many kinds of models,and the lines is very complicated among different equipments.Each equipment maintainer hopes to fast and simply check the signal assemble module and test every possible point while any signal has problem.So it is necessary to build a database.This paper is taking an example of design a small type communication resource database based on standard method,and gradually analyzes relations among data and briefly introduces main process and method of data structure simplification in relational database.%通信设备型号繁多,而且各个设备之间线路复杂。设备维护人员都希望在任何一路信号有问题时,能快速简单地查到这一路信号所经过的配线模块,进而对每一个点进行测试,为此建立一个数据库很有必要。文中以一个小型通信资源数据库的设计为例,运用规范法范式理论,通过逐步对数据之间的联系进行分解,简要介绍了关系数据库数据结构简化的主要过程和方法。