Co-Authored By:
An atomic value is a value that cannot be divided. For example, in the table shown below, the values in the [Color] column in the first row can be divided into "red" and "green", hence [TABLE_PRODUCT] is not in 1NF. A repeating group means that a table contains two or more columns that are closely related.
Consequently, what does Atomic mean in database?
Atomicity (database systems) An atomic transaction is an indivisible and irreducible series of database operations such that either all occur, or nothing occurs. A guarantee of atomicity prevents updates to the database occurring only partially, which can cause greater problems than rejecting the whole series outright.
In this regard, what does 1nf mean?
First normal form
Non-atomic Types. Values of atomic data types cannot be sub divided further. It can be either primitive or derived like strings, integers, decimals, dates etc. Values of atomic data types cannot be sub divided further. It can be either primitive or derived like strings, integers, decimals, dates etc.