A #database is in first normal form if it satisfies the following conditions:
Contains only atomic values
There are no repeating groups
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.
Database #Normalization is a technique of organizing the #data in the database. Normalization is a systematic approach of decomposing tables to eliminate data redundancy(repetition) and undesirable characteristics like Insertion, #Update and Deletion Anomalies. It is a multi-step process that puts data into tabular form, removing duplicated data from the relation tables.
00:00 What is 1NF?
02:35 Normalize data into 1NF
06:28 What is Normalization?
Website: https://www.dbagenesis.com/
Facebook: https://www.facebook.com/dbagenesis/
Instagram: https://www.instagram.com/dbagenesis/
Twitter: https://twitter.com/DbaGenesis
