Desain Basis Data
Database Lifecycle ✅
Database planning
⭐
System definition ⭐
Requirement collection and analysis ⭐
Database design ⭐
DBMS selection ⭐
Application ⭐ design
Prototyping ⭐
Implementation ⭐
Data ⭐ conversion
Testing ⭐
Operational : maintenance ⭐
Mission statement
Mission objectives
Definition of scope and boundary of
database system
Definition of user views
Users’ and system requirements
specifications
Conceptual database design
Logical database deisgn
Physical database design
Data dictionary entities
Data dictionary relation
Data dictionary attribute
Data dictionary key attribute
Specialization/Generalization
Aggregation
ERD/EERD
Mapping
Entity and relationship documentation
Normalization
Functional dependency
Selecting a suitable DBMS for the database system
Designing the user interface and the application programs that use and process the
database.
Building a working model of the database system, which allows the designers or users
to visualize and evaluate how the final system will look and function
Creating the physical database definitions and the application programs
Loading data from the old system to the new system and, where possible, converting
any existing applications to run on the new database.
Database system is tested for errors and validated against the requirements specified
by the users
Database system is fully implemented. The system is continuously monitored and maintained. When necessary, new requirements are incorporated into the database system through the preceding stages of the lifecycle.