Forgot your password? Click here.
1NF is the first step of data normalization in which no two Rows of data must contain repeating group of information and each set of column must have a unique value such that multiple columns cannot be used to fetch the same row. Each table should be organized into rows, and each row should have a primary key that distinguishes it as unique. 1NF is fully based on the The Primary key that is usually a single column but sometimes more than one column can be combined to create a single primary key. In 1NF any row must not have a column in which more than one value is saved, like separated with commas. Rather than that, we must separate such data into multiple rows. Using the 1NF data redundancy increases, as there will be many columns with same data in multiple rows but each row as a whole will be unique.