Types of attributes:
1. Simple attributes: An attributes which cannot be divided into subparts are known as Simple attributes. E.g. RollNo.
2. Composite attributes: It can be further divided into subparts (that is, other attributes).
e.g Name can be divided as First_name,Middle_name,Last_name
3. Single-valued attribute: The attributes that hold a single value for a single entity are single-valued attributes. E.g. Branch
4. Multivalued attributes: There may be instances where an attribute has a set of values for a specific entity. E.g. TelephoneNo
5. Derived attributes: The value for such attribute can be derived from the values of other related attributes or entities. E.g. Age attribute can be derived from attribute DOB
6. Key attributes: An attribute which denotes the primary key of an entity set. examplestudent_enrollment_no in student table.
0 Comments