NDLI: A logical design methodology for relational databases using the extended entity-relationship model

Content Provider	ACM Digital Library
Author	Teorey, Toby J. Yang, Dongqing Fry, James P.
Copyright Year	1986
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.
Starting Page	197
Ending Page	222
Page Count	26
File Format	PDF
ISSN	03600300
e-ISSN	15577341
DOI	10.1145/7474.7475
Journal	ACM Computing Surveys (CSUR)
Volume Number	18
Issue Number	2
Language	English
Publisher	Association for Computing Machinery (ACM)
Publisher Date	1986-06-01
Publisher Place	New York
Access Restriction	One Nation One Subscription (ONOS)
Content Type	Text
Resource Type	Article
Subject	Theoretical Computer Science Computer Science

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in

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

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

Representing extended entity-relationship structures in relational databases: a modular approach

The Problem of Equivalence for Entity-Relationship Diagrams

Models for the combined logical and physical design of databases

Further Analysis of the Entity-Relationship Approach to Database Design

Utilizing extended entity relationship modeling as a basis for logical relational database design

SEAM: A state-entity-activity-model for a well-defined workflow development methodology

Using the entity-relationship model to teach the relational model

A logical design methodology for relational databases using the extended entity-relationship model

Similar Documents

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

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

Representing extended entity-relationship structures in relational databases: a modular approach

The Problem of Equivalence for Entity-Relationship Diagrams

Models for the combined logical and physical design of databases

Further Analysis of the Entity-Relationship Approach to Database Design

Utilizing extended entity relationship modeling as a basis for logical relational database design

SEAM: A state-entity-activity-model for a well-defined workflow development methodology

Using the entity-relationship model to teach the relational model

A logical design methodology for relational databases using the extended entity-relationship model