A Logical Design Methodology for Relational Databases Using the Extended Entity-Relationship Model

DMCA

A Logical Design Methodology for Relational Databases Using the Extended Entity-Relationship Model (1986)

Cached

Download Links

Other Repositories/Bibliography

DBLP

by Toby J. Teorey , Dongqing Yang , James P. Fry

Venue:	ACM Computing Surveys
Citations:	177 - 2 self

BibTeX

@ARTICLE{Teorey86alogical,
    author = {Toby J. Teorey and Dongqing Yang and James P. Fry},
    title = {A Logical Design Methodology for Relational Databases Using the Extended Entity-Relationship Model},
    journal = {ACM Computing Surveys},
    year = {1986},
    volume = {18},
    pages = {197--222}
}

OpenURL

Abstract

A database design methodology is defined for the design of large relational databases. First, the data requirements are conceptualized using an extended entity-relationship model, with the extensions being additional semantics such as ternary relationships, optional relationships, and the generalization abstraction. The extended entity-relationship model is then decomposed according to a set of basic entity-relationship constructs, and these are transformed into candidate relations. A set of basic transformations has been developed for the three types of relations: entity relations, extended entity relations, and relationship relations. Candidate relations are further analyzed and modified to attain the highest degree of normalization desired. The methodology produces database designs that are not only accurate representations of reality, but flexible enough to accommodate future processing requirements. It also reduces the number of data dependencies that must be analyzed, using the extended ER model conceptualization, and maintains data integrity through normalization. This approach can be implemented manually or in a simple software package as long as a “good ” solution is acceptable and absolute optimality is not required.

Keyphrases

extended entity-relationship model logical design methodology relational database candidate relation entity relation data integrity data requirement basic entity-relationship construct future processing requirement large relational database simple software package database design optional relationship extended er model conceptualization relationship relation data dependency basic transformation additional semantics good solution database design methodology generalization abstraction ternary relationship accurate representation absolute optimality

DMCA