Accession Number:

ADA151782

Title:

Development of Computer Aided Database Design and Maintenance Tools.

Descriptive Note:

Master's thesis,

Corporate Author:

AIR FORCE INST OF TECH WRIGHT-PATTERSON AFB OH SCHOOL OF ENGINEERING

Personal Author(s):

• Jankus,E. R.

Report Date:

1984-12-01

Pagination or Media Count:

142.0

Abstract:

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

Descriptors:

• *DATA BASES
• *SYSTEMS ENGINEERING
• *COMPUTER AIDED DESIGN
• COMPUTER PROGRAMS
• MAINTENANCE
• REQUIREMENTS
• INTERFACES
• THESES
• COMPUTER GRAPHICS
• MANUALS

Subject Categories:

• Administration and Management
• Computer Programming and Software

Distribution Statement:

APPROVED FOR PUBLIC RELEASE