Location of Repository

ER modelling from first relational principles

By Ernst-Erich Doberkat and Eugenio G. Omodeo

Abstract

Entity-Relationship modelling is a popular technique for data modelling. Despite its popularity and wide spread use, it lacks a firm semantic foundation. We propose a translation of an ER-model into relation algebra, suggesting that this kind of algebra does provide suitable mechanisms for establishing a formal semantics of Entity-Relationship modelling. The work reported on here deals first with the techniques necessary for the translation, thus constructing a static view of an ER-model in an abstract setting of what might be called logic without variables. We then undertake a detailed analysis of the insertion and deletion operations for an ER-model represented in terms of the relation calculus

Topics: ddc:004, Entity-Relationship models (static and dynamic view), relational foundations of data modelling., relation algebra
Publisher: Universität Dortmund
Year: 2003
OAI identifier: oai:eldorado.tu-dortmund.de:2003/2679

Suggested articles

Preview


To submit an update or takedown request for this paper, please submit an Update/Correction/Removal Request.