DID YOU KNOW? DTIC has over 3.5 million final reports on DoD funded research, development, test, and evaluation activities available to our registered users. Click HERE
to register or log in.
Development of Computer Aided Database Design and Maintenance Tools.
AIR FORCE INST OF TECH WRIGHT-PATTERSON AFB OH SCHOOL OF ENGINEERING
Pagination or Media Count:
This thesis investigated that the tasks of the database administrator are and detailed a list of computer aided tools to assist the DBA in performing those tasks. A selection criteria was established and two of the tools were implemented. The first tool implemented was an interactive user-friendly Automated System for Normalizing Relations into Third Normal Form. The basis for this tool is the concept of a minimal cover as presented by Jeffrey Ullman. If a minimal cover is deduced from the set of functional dependencies of an unnormalized relation, the resultant relations are in Third Normal Form. The second tool explores the user friendly graphics area. It is a new front-end to the normalization tool that uses a mouse to allow the DBA to specify the functional dependencies that go into the normalization process. Together, these tools provide a very useful and complete system for the DBA to normalize relations in a Relational Database. Additional keywords Computer programs, Requirements, Interfaces, User manuals. Author
APPROVED FOR PUBLIC RELEASE