Different Types of Attributes

Different types of Attributes in RDBMS:

• Simple Attribute: An attribute that cannot be broken down into smaller components. For example, `Age` of a person.
• Composite Attribute: An attribute that can be subdivided into smaller sub-attributes. For example, an `Address` attribute can be broken down into `Street`, `City`, and `ZipCode`.
• Single-Valued Attribute: An attribute that can hold only one value for a given entity at a time. For example, a person can only have one `DateOfBirth`.
• Multi-Valued Attribute: An attribute that can hold multiple values for a given entity. For example, a person can have multiple `PhoneNumbers`.
• Derived Attribute: An attribute whose value is calculated from other attributes. It is not stored directly in the database. For example, a person's `Age` can be derived from their `DateOfBirth` and the current date.
• Key Attribute: An attribute that uniquely identifies an entity in a set. This is used as the primary key of the table.