Sunday, September 15, 2019

Attributes in DBMS

Attributes

ATTRIBUTES IN DBMS


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: -


The Attributes with the values that the atomic or not divisible or can’t be broken down further are 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: -


Derived Attributes are the Attributes that aren't present in the Database. But derived using other 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