- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Explain the stages and their examples of database development lifecycle (DBMS)?
Let’s see the stages of database system life cycle (DDLC) and their facts using tabular form −
Stage of Database system development Lifecycle | Example of Facts | Example of Documentation Produced |
---|---|---|
Database Planning | Aims and objectives of database projects. | Mission statements and objectives. |
System Identification | Description of major user views (Job roles, business application areas). | Definition of scope and boundary of database system, definition of user views to be supported. |
Requirements Collection and Analysis | Requirements of user views, system specifications, including performance and security requirements. | User requirement specification, system specification. |
Database design | User’s responses to checking the logical database design, functionality provided by target DBMS. | Logical database design, data dictionary, physical database design. |
Application Design | Users’ response to checking interface design. | Application design. |
DBMS Selection | Functionality provided by target DBMS. | DBMS evaluation |
Prototyping | User response to prototype. | Modified user requirement specification and system specification. |
Implementation | Functionality provided by target DBMS. | |
Data conversion and loading | Format of current data, data import capability of target DBMS. | |
Testing | Test Results. | Testing strategies used, |
Operational maintenance | Performance testing results, new or changing user and system requirements. | User manual, analysis of performance results, modified users requirements and system specification. |
- Related Articles
- Types of DBMS Entities and their examples
- Psychosexual Stages of Personality Development
- What are the different phases of database development Life cycle (DBMS)?
- Erik Erikson’s Stages of Psychosocial Development
- Explain the concept of DBMS schema with examples?
- Explain the role of the Database Administrator in DBMS?
- Explain the concept of foreign keys with examples(DBMS)?
- Explain 5NF with examples in DBMS
- Explain fractions and their types with examples.
- What is 1NF in DBMS? Explain with examples
- Please explain lifecycle of a JSP
- Explain the advantages and disadvantages of DBMS?
- What are different database models? Explain their differences
- Explain the characteristics of DBMS?
- Explain the architecture of DBMS?

Advertisements