CoDE Publications CoDE Publications
IRIDIA Publications IRIDIA Publications
SMG Publications
WIT Publications
WIT Publications
SMG Publications
Home People Research Activities Publications Teaching Resources
By Class By Topic By Year
By Class By Topic By Year
login
M. Kolp and E. Zimányi. Relational Database Design using an ER approach and Prolog. In Proceedings of the 6th International Conference on Information Systems and Management of Data, CISMOD'95, number 1006 in Lecture Notes in Computer Science, pages 214-231. Springer-Verlag, Bombay, India, November 1995.
© Springer-Verlag 1995 – http://dx.doi.org/10.1007/3-540-60584-3_34

Abstract

In the context of CASE tool development for relational database design, this paper develops a methodology that maps an enhanced Entity-Relationship (ER) schema into a relational schema and normalizes the latter into inclusion normal form (IN-NF). Unlike classical normalization that characterizes individual relations only, IN-NF also concerns inter-relational redundancies. The paper precisely characterizes sources of redundancy in ER schemas. Our methodology enhances several existing proposals from the literature. The paper briefly presents a Prolog implementation of the methodology.


Updated: 2017-03-27