Browse > Article
http://dx.doi.org/10.7232/JKIIE.2011.37.3.264

An Event-Driven Entity-Relationship Modeling Method for Creating a Normalized Logical Data Model  

Yoo, Jae-Gun (Department of Industrial and Management Engineering, Hansung University)
Publication Information
Journal of Korean Institute of Industrial Engineers / v.37, no.3, 2011 , pp. 264-270 More about this Journal
Abstract
A new method for creating a logical data model is proposed. The logical data model developed by the method defines table, primary key, foreign key, and fields. The framework of the logical data model is constructed by modeling the relationships between events and their related entity types. The proposed method consists of a series of objective and quantitative decisions such as maximum cardinality of relationships and functional dependency between the primary key and attributes. Even beginners to database design can use the methology as long as they understand such basic concepts about relational databases as primary key, foreign key, relationship cardinality, parent-child relationship, and functional dependency. The simple and systematic approach minimizes decision errors made by a database designer. In practial database design the method creates a logical data model in Boyce-Codd normal form unless the user of the method makes a critical decision error, which is very unlikely.
Keywords
Relational Database; Data Modeling; Logical Data Model; Entity-Relationship;
Citations & Related Records
Times Cited By KSCI : 1  (Citation Analysis)
연도 인용수 순위
1 Yoo, J. (2007), A Study for Consolidating the Normalizing Function of Computer-Aided Database Design System, Engineering Research, 5(1), 131-143.
2 Yoo, J. (2010) Step by Step : Access 2007 Database Basics and Applications, Hansung University Press, Seoul, Korea.
3 Chen, P. (1976), The Entity Relationship Model: Towards a Unified View of Data, ACM Transactions on Database Systems, 1(1), 9-36.   DOI
4 Shoval, P. and Shiran, S. (1997), Entity-relationship and object-oriented data modeling-An experimental comparison of design quality, Data and Knowledge Engineering, 21, 297-315.   DOI   ScienceOn
5 Lee, W. S. (2003), Data Architecture Solution 1, En-Core Consulting, Seoul, Korea.
6 Ra, Y. (2009), Executional Form Prototyping System for Data Modeling Review, Journal of KIISE Database Society, 25(1), 19-37.