Database system development life cycle.

•System definition
•Database design
•Database implementation
•Loading or data conversion
•Application conversion
•Testing and validation
•Monitoring and maintenance
Database system development life cycle.

Database Design stages

•Design logical and physical structure of one or more databases
•Accommodate the information needs of the users in an organization for a defined set of applications
•Goals of database design
•Very hard to accomplish and measure
•Often begins with informal and incomplete requirements

Database Design stages

•Main phases of the overall database design
Requirements collection and analysis
Conceptual database design
Choice of a DBMS
Data model mapping (also called logical database design)
Physical database design

Database Design stages

•Heart of the database design process
Conceptual database design (Phase 2)
Data model mapping (Phase 4)
Physical database design (Phase 5)
Database system implementation and tuning (Phase 6)

Phase 1: Requirements Collection and Analysis

•Identify application areas and user groups
•Study and analyze documentation
•Study current operating environment
•Collect written responses from users

Phase 2: Conceptual Database Design

•Conceptual Schema Design
•Developed a high level description of the data to be stored in the database along the constrains that are known to hold over this data.
•Transaction Design
Specify transactions at a conceptual level
Identify input/output and functional behavior
•Example ER diagram

page 2

Copyright@ 2021. All rights reserved. -NVQ Project-

Don`t copy text!