DBMS Concepts

DBMS Tutorial Components of DBMS. Applications of DBMS The difference between file system and DBMS. Types of DBMS DBMS Architecture DBMS Schema Three Schema Architecture. DBMS Languages.

DBMS ER Model

ER model: Entity Relationship Diagram (ERD) Components of ER Model. DBMS Generalization, Specialization and Aggregation.

DBMS Relational Model

Codd’s rule of DBMS Relational DBMS concepts Relational Integrity Constraints DBMS keys Convert ER model into Relational model Difference between DBMS and RDBMS Relational Algebra DBMS Joins

DBMS Normalization

Functional Dependency Inference Rules Multivalued Dependency Normalization in DBMS: 1NF, 2NF, 3NF, BCNF and 4NF

DBMS Transaction

What is Transaction? States of transaction ACID Properties in DBMS Concurrent execution and its problems DBMS schedule DBMS Serializability Conflict Serializability View Serializability Deadlock in DBMS Concurrency control Protocols

Difference

Difference between DFD and ERD

Misc

Advantages of DBMS Disadvantages of DBMS Data Models in DBMS Relational Algebra in DBMS Cardinality in DBMS Entity in DBMS Attributes in DBMS Data Independence in DBMS Primary Key in DBMS Foreign Key in DBMS Candidate Key in DBMS Super Key in DBMS Aggregation in DBMS Hashing in DBMS Generalization in DBMS Specialization in DBMS View in DBMS File Organization in DBMS What Is A Cloud Database What Is A Database Levels Of Locking In DBMS What is RDBMS Fragmentation in Distributed DBMS What is Advanced Database Management System Data Abstraction in DBMS Checkpoint In DBMS B Tree in DBMS BCNF in DBMS Advantages of Threaded Binary Tree in DBMS Advantages of Database Management System in DBMS Enforcing Integrity Constraints in DBMS B-Tree Insertion in DBMS B+ Tree in DBMS Advantages of B-Tree in DBMS Types of Data Abstraction in DBMS Levels of Abstraction in DBMS 3- Tier Architecture in DBMS Anomalies in Database Management System Atomicity in Database Management System Characteristics of DBMS DBMS Examples Difference between Relational and Non-Relational Databases Domain Constraints in DBMS Entity and Entity set in DBMS ER Diagram for Banking System in DBMS ER Diagram for Company Database in DBMS ER Diagram for School Management System in DBMS ER Diagram for Student Management System in DBMS ER Diagram for University Database in DBMS ER Diagram of Company Database in DBMS Er Diagram Symbols and Notations in DBMS How to draw ER-Diagram in DBMS Integrity Constraints in DBMS Red-Black Tree Deletion in DBMS Red-Black Tree Properties in DBMS Red-Black Tree Visualization in DBMS Redundancy in Database Management System Secondary Key in DBMS Structure of DBMS 2-Tier Architecture in DBMS Advantages and Disadvantages of Binary Search Tree Closure of Functional Dependency in DBMS Consistency in Database Management System Durability in Database Management System ER Diagram for Bank Management System in DBMS ER Diagram for College Management System in DBMS ER Diagram for Hotel Management System in DBMS ER Diagram for Online Shopping ER Diagram for Railway Reservation System ER Diagram for Student Management System in DBMS Isolation in DBMS Lossless Join and Dependency Preserving Decomposition in DBMS Non-Key Attributes in DBMS Data Security Requirements in DBMS DBMS functions and Components What is Homogeneous Database? DBMS Functions and Components Advantages and Disadvantages of Distributed Database

Attributes in DBMS

What is Attribute?

An attribute is an element in the database management system that describes the property or certain characteristics of the database entity. It is a crucial element of the database as it provides information about the entity of the databases.

In a relational database management system, the data is represented in tables. We can describe these tables as electronic spreadsheets consisting of various rows and columns.

The entity's attribute is represented in the corresponding column of the table. It describes the value corresponding to the category mentioned in the column. The row of the relational table is called a tuple. A tuple represents the entire data of a single entity. Attributes are the characteristics stored in the tuple that distinguish between the different entities by specifying the value of the characteristic that is unique to it.

An attribute is any non-null cell of a column and is allowed to contain only a single type of value in the column. For example, in the case of a bill, the attributes can be the list of objects, their respective prices, the date of purchase. It is impossible to store a date as an attribute in the price column. 

Types of Attributes

Various attributes can be used to describe the property of the entity in the relational database. These are:

  • Single-Valued Attribute
  • Composite Attribute
  • Multivalued Attribute
  • Primary Attribute
  • Derived Attribute

Single-valued Attribute: As the name itself suggests, these are the most basic type of attributes that can have only value to it for an entity. For example, the First name is an attribute that will only have value.

Attributes In DBMS

Composite Attribute: These attributes consist of multiple single-valued attributes. For example, a Name is a composite attribute formed by combining three attributes. These attributes are First Name, Middle Name, and Last Name.

Multivalued Attribute: These attributes allow the user to store multiple different values under the same category for a single entity. For example, Phone Number, a single entity can have multiple phone numbers.

Attributes In DBMS

Primary Attribute or Key Attribute: The value stored under this attribute helps the user uniquely identify each entity present in the table. For example, the list of students for the college can have the student's admission number as the key attribute for the table. The table with only one primary attribute is regarded as a strong entity. In contrast, it is possible to have more than one key attribute in the table. For example, if that table has both registration number and admission number as an attribute. Both these attributes are the key attribute of the table.

Attributes In DBMS
  • Derived Attribute: These attributes can be determined using the other attribute of the entity. The user can derive them by applying certain fixed steps or formulas to certain identity attributes. For example, the age of a person can be represented as the attribute of that person, but at the same time, we can easily determine the age if we know the Date of Birth of the entity. In the case of the bill, we can determine the VAT applied to the product if we know the marked price of the product and the final price of the product.
Attributes In DBMS