Designing an Engineering Database for Telephone Networks

An engineering database modeling telephone outside plant networks is developed. Semantic and relational database design methodologies are used with the semantic data model developed based on an extended entity-relationship approach. This logical model is used to generate a normalized relational data structure. This database holds engineering data supporting engineering analyses, engineering work order generation procedures, and network planning activities. The database has been linked to separate network analysis programs and CAD-based network maps by a database application.