데이타베이스 개발 방법 (약식), 1997/4/10
revised : 1997/11/25
1. goals of Main applications
define goal statements of the main applications of the database
2. Functional modeling
- develop a synario(s) representing the goals stated.
- draw a Data Flow Diagram or an IDEF0 for context diagram and detailed process description
3. Data modeling
- consider elements in data storage in the DFD and input/output data flow, controls in IDEF0 as candidate data entities
- draw an entity relationship diagram(s) or an IDEF1X for defining the data including data dictonary and its relationship
4. Database schema design
specify a logical schema design, rough applicatin design with database query statements
5. Schema validation
evaluate functionality with database instantiation and evaluation query and check integrity for the entity, referential and user-defined
6. Application design and shcema modification
- develop a specification(s) for the applications through the state transition diagram
- modify database schema considering application HW/SW environment
- consider real implementation of the specfied integrity through user interface, menu structure, triggers,.etc.
Availalbe tools
System analysis and design tool : System Architect, DBMS: any relational database