Welcome to WebmasterServe!

FREE TO JOIN! Join us now to engage in informative and friendly discussions about Webmastering, SEO, SEM, Internet Marketing, Programming, Graphic Design, Online Jobs and more. What are you waiting for? Ready to join our friendly community? It takes just one minute to register.

Dismiss Notice

Join WebmasterServe Forums 
Join the discussion! Have a better idea or an opinion? It takes just one minute to register Click Here to Join

Help Me/Question What Is Difference Between Stored And Derived Attributes?

Discussion in 'Database Management' started by Doominic anderson, Feb 16, 2016.

  1. Doominic anderson

    Yellow Belt

    Joined:
    Jan 30, 2016
    Messages:
    399
    Ratings:
    +21 / -0
    Attributes- Each entity has an attribute that is the property that describes the entity,it is also known as schema or columns of a table.
    Attributes are classified into various category like single,composite,multivalued,single valued e.t.c
    What is difference between stored and derived attributes, and for which entity set it is used in DBMS?
     
  2. Swati Mishra

    Yellow Belt

    Joined:
    Dec 28, 2015
    Messages:
    644
    Ratings:
    +105 / -0
    Stored attributes are already stored in database from which the value of other attributes are derived is called stored attribute.

    Derived attributes are those attribute for which the value is calculated from the stored attributes.
     
  3. steve taylor

    Yellow Belt

    Joined:
    Feb 12, 2016
    Messages:
    769
    Ratings:
    +25 / -0
    Stored Attribute:-
    • The attribute which is already stored in the data base.

    Example :-
    • Roll number.
    • Name
    • Date of birth
    Derived Attribute:-

    • Derived attribute is the attribute which is generate by the using stored attributes. We can say that derived attribute may be age which is derived by the date of birth.Derived attribute depend on the stored attribute.
     

Share This Page