Explanation of what the atomic values represent.

287    Asked by Aalapprabhakaran in SQL Server , Asked on Oct 16, 2023

 I have gone through the definition of 1NF: "If every attribute of relation is atomic." Pray to tell me what Atomic is. 

Answered by Ranjana Admin

Atomic values represent Codd's original notion from 1969 that every attribute in each tuple within a relation must comprise a single value and not allow multivalued structures of the kind that are supported in databases equivalent to the CODASYL model.

In modern SQL DBMSs, atomicity is not a problem. SQL tables do not allow multivalued columns, and values are always "atomic."




Your Answer

Interviews

Parent Categories