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

다국어 초록 (Multilingual 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.

참고문헌 (Reference)

1 나영국, "데이터 모델링 평가(Review)를 위한 실행 폼 프로토타이핑(prototyping) 시스템" 한국정보과학회 25 (25): 19-37, 2009

2 Chen, P, "The Entity Relationship Model: Towards a Unified View of Data" 1 (1): 9-36, 1976

3 Yoo, J, "Step by Step : Access 2007 Database Basics and Applications" Hansung University Press 2010

4 Shoval, P, "Entity-relationship and object-oriented data modeling-An experimental comparison of design quality" 21 : 297-315, 1997

5 Lee, W. S, "Data Architecture Solution 1" En-Core Consulting 2003

6 Yoo, J, "A Study for Consolidating the Normalizing Function of Computer-Aided Database Design System" 5 (5): 131-143, 2007