***Welcome to ashrafedu.blogspot.com * * * This website is maintained by ASHRAF***

Posts

    Thursday, 5 December 2019

    Attributes

    Attributes

    An attribute is a single-valued property of either an entity-type or a relationship-type. An attribute is a characteristic. Attributes are the descriptive properties which are owned by each entity.

    An attribute is represented by an Ellipse in E-R diagram.











    Types of Attributes
    Description
    Simple attribute
    Simple attributes can't be divided any further. For example, a student's contact number. It is also called an atomic value.
    Composite attribute
    It is possible to break down composite attribute. For example, a student's full name may be further divided into first name, second name, and last name.
    Derived attribute
    This type of attribute does not include in the physical database. However, their values are derived from other attributes present in the database. For example, age should not be stored directly. Instead, it should be derived from the DOB of that employee.
    Multivalued attribute
    Multivalued attributes can have more than one values. For example, a student can have more than one mobile number, email address, etc.

    No comments:

    Post a Comment