What is first normal form in DBMS with example?

The first normal form or 1NF is the first and the simplest type of normalization that can be implemented in a database.

The main aims of 1NF are to:

• Eliminate duplicative columns from the same table.
• Create separate tables for each group of related data and identify each row with a unique column (the primary key).