Attributes
Attributes is a property or distribution of an entity.
If a student is an entity then the stu_RollNo, stu_Name, stu_age, stu_gender etc. will be its attributes.
An attribute can be of many types here are same different attributes define: -
i) Simple Attribute
ii) Composite Attribute
iii) Derived Attribute
iv) Single Valued Attribute
v) Multi valued Attribute
vi) Key Attributes
i) Simple Attributes: -
Foreign – Student Age.
ii) Composite Attribute: -
A Composite Attribute is made up of more than one simple Attributes.
For example – Student Address will contain house no, street name, pin code etc.
iii) Derived Attributes: -
E.g. – Average age of a student in class.
iv) Single – value Attributes: -
As the name suggest a single value.
v) Multi – valued Attributes: -
As the name suggest they have multiple value.
E.g. – color of a car.
vi) Key Attributes: -
To represent the key Attribute the attribute name inside the ellipse is underline.
Key attributes are those attributes through which use define the record uniquely.
Key are used to establish the relationship between the table.
Attributes in DBMS
multivalued attributes in dbms, types of attributes in dbms, key attributes in dbms, complex attribute in dbms, attribute in database example, single valued attribute, entity in dbms, descriptive attributes in dbms
Next Topic ➧ Keys in DBMS
No comments:
Post a Comment