Development of Computer Aided Database Design and Maintenance Tools.

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)

Open PDF

Document Details

Document Type
Technical Report
Publication Date
Dec 01, 1984
Accession Number
ADA151782

Entities

People

  • E. R. Jankus

Organizations

  • Air Force Institute of Technology

Tags

Communities of Interest

  • Materials and Manufacturing Processes

DTIC Thesaurus Topics

  • Abstracts
  • Air Force
  • Computer Programming
  • Computer Programs
  • Computer Science
  • Computer-Aided Design
  • Computers
  • Control Systems
  • Database Management Systems
  • Databases
  • Engineering
  • Graphics
  • Lists (Data Structures)
  • Literature Surveys
  • Pattern Recognition
  • Relational Databases
  • Software Development

Readers

  • Asian Economic Studies
  • Computer Vision.
  • Software Engineering.