
- DBMS Tutorial
- DBMS - Home
- DBMS - Overview
- DBMS - Architecture
- DBMS - Data Models
- DBMS - Data Schemas
- DBMS - Data Independence
- Entity Relationship Model
- DBMS - ER Model Basic Concepts
- DBMS - ER Diagram Representation
- DBMS - Generalization, Aggregation
- Relational Model
- DBMS - Codd's Rules
- DBMS - Relational Data Model
- DBMS - Relational Algebra
- DBMS - ER to Relational Model
- DBMS- SQL Overview
- Relational Database Design
- DBMS - Database Normalization
- DBMS - Database Joins
- Storage and File Structure
- DBMS - Storage System
- DBMS - File Structure
- Indexing and Hashing
- DBMS - Indexing
- DBMS - Hashing
- Transaction And Concurrency
- DBMS - Transaction
- DBMS - Concurrency Control
- DBMS - Deadlock
- Backup and Recovery
- DBMS - Data Backup
- DBMS - Data Recovery
- DBMS Useful Resources
- DBMS - Quick Guide
- DBMS - Useful Resources
- DBMS - Discussion
Explain attributes and the different types of attributes in DBMS?
Attributes are the properties which describe an entity.
Example
The attributes of student entity are as follows −
Roll number
Name
Branch
Age
Types of attributes
The different types of attributes are as follows −
Composite attribute
It can be divided into smaller sub parts, each sub part can form an independent attribute.
For example −
Name FirstName MiddelName LastName
Simple or Atomic attribute
Attributes that cannot be further subdivided are called atomic attributes.
For example −
Phone number PIN code
Single valued Attribute
Attributes having a single value for a particular item is called a single valued attribute.
For example: Room Number
Multi-valued Attribute
Attribute having a set of values for a single entity is called a multi-valued attribute.
For example −
e-mail Tel.No Hobbies
Derived Attributes or stored Attributes
When one attribute value is derived from the other is called a derived attribute.
For example: Age can be derived from date of birth, where,
Age is the derived attribute.
DOB is the stored attribute.
Complex Attribute
Nesting of composite and multi-valued attributes forms a complex attribute.
For example
If a person has more than one house and each house has more than one phone. Then, that attribute phone is represented as a complex attribute.
- Related Articles
- Explain closure of attributes in DBMS
- Explain the concept of key attributes with an example in DBMS?
- Attributes and its types in Data Analytics
- Explain the different types of users who play different roles in DBMS?
- what are the different attributes of MySQL ENUM data type?
- How to compare attributes of different objects in MongoDB object array?
- attributes in C++
- Attributes and usage of element in HTML5
- Attributes and usage of element in HTML5
- What are the different types of DBMS?
- HTML Attributes
- Attributes of HTML element
- Assessment of Pscyhological Attributes
- Attributes of Data Warehouse
- Accessing Attributes and Methods in C#
