First Normal Form (1NF) is the initial stage of database normalization, aiming to eliminate repeating groups and ensure that each column in a table contains atomic values. Here are the key characteristics and requirements of 1NF:
1. Atomic Values: Each column in a table must contain indivisible (atomic) values. This means that a column should not contain multiple values or arrays. If a column holds multiple values, it violates 1NF.
Example of Violating 1NF:
To conform to 1NF, the "Subject" column should contain only atomic values. You might split this into multiple rows, each representing a single subject for a student.
2.Unique Column Names: Each column in a table must have a unique name. This ensures that each attribute is distinctly identifiable.
Example of Violating 1NF:
To conform to 1NF, you need to ensure unique column names.
3.Unique Rows: Each row in a table must be unique. This means there should be no duplicate rows.
Example of Violating 1NF:
To conform to 1NF, you need to ensure that each row is unique.
Comments
Post a Comment