Stages of the Database System Development Lifecycle?
- Database planning
- System definition
- Requirements collection and analysis
- Database design
- DBMS selection
- Application design
- Prototyping (optional)
- Implementation
- Data conversion and loading
- Testing
- Operational maintenance
Criteria to produce an Optimal Data Model?
- Structural validity
- Simplicity
- Expressibility
- Nonredundancy
- Shareability
- Extensibility
- Integrity
- Diagrammatic representation
Three phases of database design
- conceptual database design, process of constructing a model of the data used in an enterprise, independent of all physical considerations.
- logical database design, process of constructing a model of the data used in an enterprise based on a specific data model, but independent of a particular DBMS and other physical considerations.
- physical database design, process of producing a description of the database implementation on secondary storage
Database planning?
management activities that allow stages of database system development lifecycle to be realized as efficiently and effectively as possible
System definition?
describes scope and boundaries of database system and the major user views.
Requirements collection and analysis?
Process of collecting and analyzing information about the part of organization to be supported by the database system, and using this information to identify users’ requirements of new system.
3 main approaches:
- centralized approach
- view integration approach
- combination of both approaches
Database design?
Process of creating a design for a database that will support the enterprise’s mission statement and mission objectives for the required database system.
Main approaches include:
- Top-down
- Bottom-up
- Inside-out
- Mixed
DBMS selection?
Selection of an appropriate DBMS to support the database system.
Application design?
Design of user interface and application programs that use and process the database.
two important activities:
- transaction design
- user interface design
Prototyping?
Building working model of a database system.
Implementation?
The physical realization of the database and application designs.
Data conversion and loading?
Transferring any existing data into new database and converting any existing applications to run on new database.
Testing
The process of running the database system with intent of finding errors.
Operational maintenance?
The process of monitoring and maintaining database system following installation.
CASE tools benefits?
- Standards;
- Integration;
- Support for standard methods;
- Consistency;
- Automation .
The Difference between Data Administrator and Database Admisnistrator?
The Data Administrator (DA) and Database Administrator (DBA) are responsible for managing and controlling the corporate data and corporate database, respectively.
DA is more concerned with early stages of database system development lifecycle and DBA is more concerned with later stages.
Tugas Data Administrator?
Management of data resource including:
- database planning,
- development and maintenance of standards, policies and procedures, and conceptual and logical database design.
Tugas Database Administrator?
Management of physical realization of a database system including:
- physical database design and implementation,
- setting security and integrity controls,
- monitoring system performance, and reorganizing the database.
several fact-finding techniques?
- examining documentation
- interviewing
- observing the organization in operation
- research
- questionnaires
Why using fact-finding techniques?
It is critical to capture the necessary facts to build the required database application.
Enables developer to learn about the terminology, problems, opportunities, constraints, requirements, and priorities of the organization and the users of the system.
