Database system development life cycle.
•System definition
•Database design
•Database implementation
•Loading or data conversion
•Application conversion
•Testing and validation
•Operation
•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