Difficulty: Easy
Correct Answer: Incorrect
Explanation:
Introduction / Context:
The systems development life cycle (SDLC) is a structured approach covering planning, analysis, design, implementation, testing, deployment, and maintenance. Databases are core system components, and their development aligns naturally with SDLC phases. This question checks whether you understand that SDLC absolutely applies to database work.
Given Data / Assumptions:
Concept / Approach:
During analysis, requirements for data entities, integrity, and access are gathered. Logical design refines entities and relationships. Physical design maps to storage structures, indexes, and partitions. Implementation deploys schema and data movement. Testing validates constraints, performance, and recovery. Deployment and maintenance address backups, patching, and optimization. SDLC thus provides a rigorous framework for database projects.
Step-by-Step Solution:
Verification / Alternative check:
Review successful database programs that use SDLC artifacts (data dictionaries, migration plans, rollback strategies).
Why Other Options Are Wrong:
Common Pitfalls:
Treating database work as an afterthought; skipping modeling; deploying without performance and recovery testing.
Final Answer:
Incorrect
Discussion & Comments