Remember that atomic data is data that is indivisible and not composed of many v
ID: 3752146 • Letter: R
Question
Remember that atomic data is data that is indivisible and not composed of many values. Which columns contain non-atomic data and what would you suggest we should do to turn them into atomic data?
ProductId
ProductName
StoreId
Amount
StatusCode
1234
Ramen Noodles
1, 2, 4
0.08
Sale, InStock
1425
Mountain Dew
1, 2, 3
0.99
InStock
321
Pop Tarts
2, 3, 4
2.49
SoldOut
ProductId
ProductName
StoreId
Amount
StatusCode
1234
Ramen Noodles
1, 2, 4
0.08
Sale, InStock
1425
Mountain Dew
1, 2, 3
0.99
InStock
321
Pop Tarts
2, 3, 4
2.49
SoldOut
Explanation / Answer
Answer)
Among all the data columns such as :
ProductId
ProductName
StoreId
Amount
StatusCode
We have StoreId and StatusCode fields as the columns contain non-atomic data.
This is because many storeids are stored in the StoreId field for one record.
Also, StatusCode, many statuses are stored in a column.
Thus, to convert the table into atomic data format, we have to normalize the data and perform database normalization.