Skip to main content

Posts

Showing posts with the label The Crazy Programmer Different Types of Attributes in DBMS Different Types of Attributes in DBMS The Crazy Programmer

Different Types of Attributes in DBMS Neeraj Mishra The Crazy Programmer

Any real-world object with self-existence is considered an entity in the computer world. Like a car, any person, any book, painting, news, building anything which is available in this world can be considered as an entity. Characteristics or specifications of any entity are known as attributes of that entity. Attributes are physical or virtual properties of an entity. There are mainly 8 types of attributes, let’s discuss them one by one in detail. Types of Attributes in DBMS 1. Composite Attributes Those attributes which may have more than one section like name can be sub-divided in First, Middle, last name. Composite attributes can be filled in sub-sections but always show as a single attribute. Like you can enter your name in three sections but the display will be combined. These brackets “()” are used to represent composite attributes. 2. Simple Attributes Those attributes which cannot be divided further like the age of any person. 3. Single-Valued Attributes Those attribut