Please enable JavaScript.
Coggle requires JavaScript to display documents.
Database Development Life Cycle - Coggle Diagram
Database Development Life Cycle
Logical Design
Translating the conceptual model,discussed earlier to incorporate the selected software
Physical Design
Essentially selecting the brick and mortar of the database ie. the
* HARDWARE
Databases Consist of :
End User Data :
Raw facts processed towards the company's goals
Meta-Data
: Data about data
Database Initial Study Purpose
Analyse company situation discover and define potential problems describes objectives define scope and boundaries
The System Development Life Cycle
1) Planning
2) Analysis
3) Detailed System Design
4) Implementation
5) Maintenance
DBLC
Stages of DBLC are not strictly sequential but involve some amount of repetition of previous stages through feedback loop.
DBLC is inherently associated with life cycle of the IS LDSC.
Database initial study
Database design
Implementation & loading
Testing & evaluation
Operation
Maintenance & Evaluation
Special Note About dB Design Strategies
Company Structured
Centralized
Done by a single person for a simple and small database.
Non-complex entities,attributes, relationships and transactions.
Decentralized
Done on a database with complex entities, attributes, relationships and transactions
Requires very precise definition of system boundaries and interrelation between subset being model.
Aggregation Process :
synonym and homonyms
Entity and entity subtype
Conflicting object definitions
Database
A collection of information that is stored so it can be accessed easily,managed and be updated. Data is organised to make it easier to find relevant information