NEW DATABASE DESIGN FOR THE APS SURVEY AND ALIGNMENT DATA

The conceptual design of the new APS Survey and Alignment Database, based on relational database technology, is presented in this paper. Authors outline the process of developing the logical database structure from data modeling to final quality check of the database design. The data used by the APS Survey and Alignment Group is analyzed and modeled in the entityrelationship model (E-R model). The E-R model is then transformed into a DBMS-independent relational design, and the quality of the database design is examined against the normalization theory. Authors also evaluate the relational design in the context of possible queries that might be posed to the database implemented on this design.