Your company decides to start the business of selling toys online and shipping globally. The E-Commerce system that supports the new business will be developed in-house. The development team is designing the data model for the SQL database based on the entity-relationship diagram. It splits the comma-separated values (CSV) data stored in a field into multiple fields. Which of the following best describes the process?
A. Split horizon
B. Normalization in 1NF
C. Normalization in 2NF
D. Key clustering
Kindly be reminded that the suggested answer is for your reference only. It doesn’t matter whether you have the right or wrong answer. What really matters is your reasoning process and justifications.
My suggested answer is B. Normalization in 1NF.
- 1NF: Split repeated values into atomic attributes (e.g. CSV) and select the key
- 2NF: All attributes depend on the key: move attributes that don’t depend on the key to new tables
- 3NF: All attributes depend on nothing but the key: move attributes that don’t fully depend on the key to new tables