DOI QR코드

DOI QR Code

정규화된 논리적 데이터 모델의 생성을 위한 사건 기반 개체-관계 모델링 방법론

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)
  • 투고 : 2011.06.27
  • 심사 : 2011.08.17
  • 발행 : 2011.09.01

초록

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.

키워드

참고문헌

  1. Chen, P. (1976), The Entity Relationship Model: Towards a Unified View of Data, ACM Transactions on Database Systems, 1(1), 9-36. https://doi.org/10.1145/320434.320440
  2. Lee, W. S. (2003), Data Architecture Solution 1, En-Core Consulting, Seoul, Korea.
  3. Ra, Y. (2009), Executional Form Prototyping System for Data Modeling Review, Journal of KIISE Database Society, 25(1), 19-37.
  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. https://doi.org/10.1016/S0169-023X(97)88935-5
  5. Yoo, J. (2007), A Study for Consolidating the Normalizing Function of Computer-Aided Database Design System, Engineering Research, 5(1), 131-143.
  6. Yoo, J. (2010) Step by Step : Access 2007 Database Basics and Applications, Hansung University Press, Seoul, Korea.