Advanced Database Management System - Tutorials and Notes: Types of attributes that you need to know in normalization process

Search Engine

Please visit, subscribe and share 10 Minutes Lectures in Computer Science

Tuesday, 9 February 2016

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.

No comments:

Post a comment

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents