Browse > Article

A Design Methodology of Relational Database Schema Without the Conceptual Design Step  

Um Yoon-Sup (경성대학교 컴퓨터공학과)
Publication Information
Journal of the Korea Institute of Information and Communication Engineering / v.9, no.2, 2005 , pp. 445-453 More about this Journal
Abstract
The design process of a relational database system consists of requirement analysis, conceptual design using ER diagram, logical design, and physical design. In logical design process, the conceptual schema is transformed to relational schema, and relational schema is normalized. This traditional design process is hard to applied in real database design process, since there is an ambiguity in conceptual design process. In this paper, we suggest a new design process, which provides more structural design steps by removing the conceptual design process. In new approach, we produce the data flow diagram by the structural methodology. From the attributes in the data store of data flow diagram, we construct relational table schema, and we normalize relational schema. Finally we produced table relationship diagram in order to figure out relationships between tables.
Keywords
Citations & Related Records
연도 인용수 순위
  • Reference
1 Hernandez, M. Database Design for Mere Mortals, Addison-Wesley, 1997
2 나민영, 데이터베이스 설계, 기한재, 1996
3 박재년, 구조적 시스템 분석과 설계, 정익사, 1992
4 Chen, P. [1976] 'The Entity Relationship Model-Toward a Unified View of Data,' TODS, 1/1, pp. 9-36, March 1976
5 이춘식, 데이터베이스의 설계와 구축, 한빛미디어, 2002
6 Batini, Conceptual Database Design, Benjamin/Cummings, 1992
7 Date, C. 'Entity/Relationship Modeling and the Relational Model.' in C. Date and Hugh Darwen, Relational Database Writings 1989-1991, Mass.; Addison-Wesley, 1992
8 Codd, E.[1970] 'A Relational Model for Large Shared Data Banks,' CACM, 13/6, pp. 377-387, June 1970
9 Kendall, P. Introduction to Systems Analysis & Design: A Structured Approach IRWIN, 1994
10 문송천, Dataware 설계론, 아이포스트, 1999
11 우치수, Software 공학, 상조사, 1994
12 조규익, 데이터베이스 설계, 홍릉과학출판사, 1994
13 Elmasri, R. & Navathe, S. Fundamentals of Database Systems, Addison-Wesley, 2000