First Normal Form Satisfied This condition
1. Atomic Values:
Each column in a table must contain atomic (indivisible) values.means every cell of the table must contain only a single value, not a set of values.
2. No Repeating Groups:
Each column should have a single value type. There should be no repeating groups of columns such as storing multiple values in a single column.
Employee Table:
| ID | Name | Department |
| 1 | Mahendra | Marketing, Sales |
| 2 | Shivam | HR |
| 3 | Lokendra | Sales |
- Atomic Values: The Department column is not atomic. It contains multiple values separated by commas.
- No Repeating Groups: The Department column represents a repeating group of data.
| ID | Name | Department |
| 1 | Mahendra | Marketing |
| 1 | Mahendra | Sales |
| 2 | Shivam | HR |
| 3 | Lokendra | Sales |
Now, each row represents a unique combination of ID and Department, and the values in each column are atomic.
This table satisfies the First Normal Form.