Which of the following activity is not involved in the Design of Database…
2024
Which of the following activity is not involved in the Design of Database during System Designing phase of System Development Life Cycle?
- A.
Physical Layout Design
- B.
Data Modeling
- C.
Conceptual Modeling
- D.
Input/output Volume
- E.
Question not attempted
Attempted by 1264 students.
Show answer & explanation
Correct answer: D
Concept
During the System Design phase of the SDLC, database design is the work of structuring the data itself: defining what data is stored and how it is logically and physically organized. It proceeds through three layers: conceptual modeling (entities, attributes, relationships), logical/data modeling (logical and physical data models), and physical layout design (storage structures and access methods). Estimating how much data flows through the system is a sizing/requirements task, not a database-structuring task.
Applying it here
Conceptual Modeling defines entities, attributes and relationships, which shapes the database structure, so it is a database-design activity.
Data Modeling produces the logical and physical data models, a core database-design activity.
Physical Layout Design fixes storage structures and access methods, again part of database design.
Input/Output Volume estimates data flow and transaction rates, a performance/capacity-sizing concern handled in requirements/system analysis, so it does NOT structure the database.
Cross-check
Three of the listed activities (conceptual modeling, data modeling, physical layout design) directly determine the database structure, while volume estimation only describes how heavily the system is used. The single activity that is not part of database design is Input/output Volume.