Types of attributes that you need to know in normalization process

Set of keywords about attributes used in Normalization process / Set of attributes that you need to know in Normalization process / Key and prime attributes in Normalization process / Non-key or Non-prime attributes in Normalization process

Set of attributes that you need to know in normalization process

Atomic Attribute – Click to read more… An attribute that stores single value (not multiple values separated by a comma or any other separators) for each record is called atomic attribute.

Determinant – Click to read more… A determinant in a database table is single or set of attributes that can be used to determine the values of other attributes (those that are dependent on the determinant attributes) uniquely. For example, consider a table Student with attributes Register_no, Name, and Date_of_Birth. Here, Register_No is a determinant that can uniquely identify the other set of attributes. In a functional dependency, the Left Hand Side (LHS) attribute is determinant.

Non-key Attribute – Click to read more… An attribute that is not a primary key attribute or part of a primary key (in case of composite primary keys) is called as non-key attribute.

Non-prime Attribute – Click to read more… Refer Non-key Attribute above.

Prime Attribute – Click to read more… In a composite primary key (or candidate key), the component attributes are called as prime attributes. For example, if you have (Register_No, Course_No) as the primary key (or candidate key) for your table, then Register_no is one prime attribute and the Course_no is the other.

Go back to NORMALIZATION keywords.