In which normal form is a composite attribute converted to individual attributes?

Explanation

First Normal Form (1NF) is the foundational level of database normalization. A table is considered to be in 1NF if it meets the following criteria:Eliminates repeating groups: Each cell in a table should contain a single atomic value, not a list of values. This prevents data redundancy and simplifies data manipulation.Defines all key attributes: The table must have a primary key, which can be a single attribute or a composite key consisting of multiple attributes, that uniquely identifies each record.Ensures all attributes are dependent on the primary key: Every non-key attribute (column) in the table should be fully reliant on the primary key. The value of a non-key attribute can be determined solely by the value of the primary key.By decomposing composite attributes into individual atomic values, 1NF lays the groundwork for a well-organized database structure In conclusion, converting composite attributes into individual attributes is a core principle of achieving First Normal Form (1NF) in database normalization. This initial step lays the foundation for further normalization to minimize redundancy and improve data integrity.