WIT Press

Towards A Knowledge-based System For Database Design

Price

Free (open access)

Volume

6

Pages

8

Published

1994

Size

950 kb

Paper DOI

10.2495/AI940241

Copyright

WIT Press

Author(s)

A. Khennoufa & H.H. Hoang

Abstract

This paper focuses on the development of a software tool for designing rela- tional databases. The development being reported is based on a design method- ology using the entity-relationship and relational data models. The main result obtained is a knowledge base incorporating theoretical and empirical knowledge of the entity-relationship and relational models, the view integration process, the translation from the entity-relationship model to the relational model, the nor- malization of relations and the optimization of logical database schemas. The current prototype of the software tool is an expert system which is presently equipped with a set of so-called methodological design rules. I. Introduction Database design can be viewed as a process of capturing relevant information and processing requir

Keywords