1st NF in DBMS

 In a database management system (DBMS), a 1NF (First Normal Form) table refers to a table that satisfies the criteria of the first normal form. The first normal form is the fundamental level of database normalization and ensures that each attribute or column in a table contains only atomic values, meaning it cannot be further divided into smaller data elements.

To illustrate a 1NF table, let's consider an example of a table for storing customer information:

Table: Customers

CustomerID	Name	Email	Phone
1	John Doe	john@example.com	123-456-7890
2	Jane Doe	jane@example.com	098-765-4321
3	Bob Smith	bob@example.com	555-123-4567

In this example, the table "Customers" is in the first normal form because each attribute (CustomerID, Name, Email, and Phone) contains only atomic values. Each column represents a single piece of information about the customer, and there is no multi-valued or repeating attribute.

The first normal form is the initial step in database normalization, ensuring that data is organized in a structured and efficient manner. By satisfying the first normal form, data redundancy and anomalies can be minimized, and efficient querying and manipulation of data become easier.