問95
頻出度★★★
データベース設計におけるデータ分析で行うこととして, 適切なものはどれか。
令和7年度 ITパスポート試験 問95
テクノロジ系データベース › データベース設計
This question's explanation and your answers so far.
解説
問 95
Incorrectア
Extracting the information needed for each business operation from a data warehouse (DWH) is a task in the scenario of utilizing an already-built and operating database (DWH); it is not the “data analysis” of the database design stage, but corresponds to operation/utilization-phase work such as creating data marts.
Incorrectイ
Extracting only the rows whose data item contents satisfy a specified condition is a query/data-manipulation operation called “selection” in a relational database; it is data manipulation at runtime, not data analysis during design.
- ウ
正解 In database design, “data analysis” is the task of investigating what data is needed for the target business operations. Specifically, it identifies the data items that the business needs to handle and organizes what kind of relationships exist among those items. Based on this result, an E-R diagram is drawn and the work proceeds to normalization. Option “ウ”, “Identify the required data items and organize the relationships among the items”, is exactly this task, and is therefore the correct answer.
Incorrectエ
Using statistical methods and other techniques to explore vast amounts of information for information useful to business is the description of “data mining”. This is utilization-phase work that discovers insights from already-accumulated data, not the data analysis in database design.
ここがポイント
- Master the flow of database design: “data analysis (identifying required data items and organizing relationships among items) → conceptual design with an E-R diagram → normalization”.
- Distinguish similar terms: data analysis (design) ≠ selection (query) ≠ extraction from a data warehouse (utilization) ≠ data mining (statistical exploration).
用語