IPA IP 2025 Question 95

A question IPA Japan published in 令和7年度 ITパスポート試験公開問題問95, translated into English. ITPEC is based on the same exams.

Which of the following is an appropriate task that is performed in data analysis in database design?

a)Necessary information for each business operation is extracted from a data warehouse.b)Only the rows where the contents of a data item satisfy the specified conditions are extracted.c)Necessary data items are identified, and the relationships among the items are organized.d)Information that can be utilized in business is searched for in an enormous amount of information by using statistical methods and other such methods.

Explanation

Identify the necessary data items and organize the relationships among them — data analysis is the first step of database design.

Before any table is created, the designer studies the business: which data items it uses (customer number, product name, order date) and how they relate (one customer places many orders, each order line names one product). The result, often drawn as an E-R diagram, is then normalized and turned into tables.

Answer (c)

Why not others:

•(a) — extracting the information each business needs from a data warehouse builds data marts for analysis, after the data already exists
•(b) — extracting only the rows that satisfy a condition is the relational operation of selection, done when the database is used
•(d) — searching huge amounts of data with statistical methods for useful information is data mining

Key rule: Database design starts with data analysis (items and their relationships), then modelling and normalization, then tables; selection and data mining happen in use.

Databases · AI-written, may contain errors

Previous Next

Practice this exam

This question comes from the past questions IPA Japan publishes, translated into English by ITPEC Practice. ITPEC Practice is an independent study tool and is not affiliated with IPA or ITPEC. See the original paper (PDF) or Report an issue.