From the objective of OSS-DB Exam Silver - General Knowledge - general knowledge about relational
databases (database design and normalization)
Sample Question
2.02
Choose the most appropriate reason to perform database normalization.
- IImprove access performance by keeping the data size constant.
- To improve access performance by standardizing the data search path.
- Easily maintain data by eliminating duplication of data.
- To simplify data retrieval by simplifying data dependency.
- Standardizing the structure of the table makes it easy to back up the data.
※This sample exam is different from those that appear in the actual OSS-DB Exam.
2018/04/02
Answer and Explanation
The purpose and meaning vary depending on the target area, but database normalization is a procedure to be performed in database design for centralized management of data.
Depending on the stage of normalization, there is the first normal form, the second normal form, the third normal form, Boyce Codd normal form, the fourth normal form, the fifth normal form. It aims to eliminate redundancy and make it easier to maintain consistency at the time of updating data.
Although normalization improves access performance in many cases, both data size and data search path are not related to normalization.
In the process of normalization, the dependency of the data is revealed, but this does not simplify the dependency nor make the search easier.
Therefore, the correct answer is C.