Difficulty: Easy
Correct Answer: Enterprise data modeling
Explanation:
Introduction:
Starting correctly is critical for database success. This question checks whether you know the proper sequence of activities, beginning with a high-level view of the enterprise before drilling down to schemas and storage choices.
Given Data / Assumptions:
Concept / Approach:
Enterprise data modeling clarifies scope, identifies major subject areas, and aligns stakeholders on terminology and boundaries. Only after this foundation is set should teams proceed to logical design (detailed attributes, relationships, normalization) and subsequently to physical design and implementation on a chosen DBMS.
Step-by-Step Solution:
1) Establish the organizational context with enterprise data modeling.2) Translate that context into a conceptual/logical schema.3) Map logical elements to DBMS-specific structures in physical design.4) Implement and test the system, then operate and tune.
Verification / Alternative check:
Methodologies and textbooks consistently list enterprise modeling or requirements analysis as the first step, preceding detailed schema design.
Why Other Options Are Wrong:
Common Pitfalls:
Jumping into table creation before clarifying enterprise scope leads to rework and inconsistent semantics.
Final Answer:
Enterprise data modeling
Discussion & Comments