A Simpler and More Practical-Oriented Methodology for Database Design

MANAGING INFORMATION IN THE DIGITAL ECONOMY: ISSUES & SOLUTIONS - PROCEEDING OF THE 6TH IBIMA CONFERENCE, Khalid S. Soliman, ed., pp. 237-243, Bonn, Germany, June 2006

7 Pages Posted: 26 Sep 2006

Abstract

In spite of its power in terms of data manipulation and integrity support, the relational model has been considered as not having too much to offer for modelling semantics of the real world applications. Consequently, a number of semantic data models have been proposed to design relational databases. Even more radical approaches recommend giving up entirely the normalization achievements and urge using only OO models and tools. This paper proposes a graphical-oriented methodology for database design based on Bernsteins's theory of normalization by synthesis, on functional and inclusion dependencies, on Smith's and also Ausiello, D'Atri, and Sacca' formalisms. Articulated entirely within the relational model, the methodology, lacking a sound theoretical foundation - this lack is deemed to attract practitioners -, has been tested for the last five years in some small- and medium-sized applications, proving to be useful and understandable.

Keywords: Database Design, Normalization, Functional Dependencies, Inclusion Dependencies

JEL Classification: M19, Z00

Suggested Citation

Fotache, Marin, A Simpler and More Practical-Oriented Methodology for Database Design. MANAGING INFORMATION IN THE DIGITAL ECONOMY: ISSUES & SOLUTIONS - PROCEEDING OF THE 6TH IBIMA CONFERENCE, Khalid S. Soliman, ed., pp. 237-243, Bonn, Germany, June 2006, Available at SSRN: https://ssrn.com/abstract=932487

Marin Fotache (Contact Author)

Al.I.Cuza University of Iasi ( email )

Carol I Blvd, Nr.11
Lasi, 700506
Romania
+40744497654 (Phone)
+40 232217000 (Fax)

HOME PAGE: http://www.feaa.uaic.ro

Do you have a job opening that you would like to promote on SSRN?

Paper statistics

Downloads
242
Abstract Views
1,373
Rank
236,770
PlumX Metrics