Stored and derived attributes, Database Management System

Attributes that are directly kept in the data base.

For example, 'Birth date' attribute of a person.

 Derived

 Attributes that are not stored directly but can be derived from stored attributes are known as derived attributes. For instance, The years of services of a 'person' entity can be determined from the present date and the date of joining of the person. Likewise, total salary of a 'person' can be calculated from 'basic salary' attribute of a 'person'.

Posted Date: 3/6/2013 6:03:58 AM | Location : United States







Related Discussions:- Stored and derived attributes, Assignment Help, Ask Question on Stored and derived attributes, Get Answer, Expert's Help, Stored and derived attributes Discussions

Write discussion on Stored and derived attributes
Your posts are moderated
Related Questions
Regional Gardens has many nurseries, including Wagga Wagga, Bathurst, Albury, Orange, and Dubbo. Each nursery is known by its campus code, eg WW, B, A, O and D respectively. Additi

What are the advantages of embedded query language? Give an example of an embedded SQL query. Embedded query language - SQL could be implemented within two ways. It can be us

What are the different strategies of implementation of the Statecharts?  There are two strategies for implementation of state charts: i)   Basic Implementation Strategy


Why a report generator is used ? Report generator is used for print files on paper.

What are the advantages of having an index structure?      Ans: The index structures commonly provide secondary access paths, which offer alternative ways of accessing the reco

What is Hierarchical DBMS In HDBMS, data is structured in a tree like manner. There is a parent-child relationship between data items and the data model is very suitable for re

define normalisation and functional dependency

Creating views with check option : This option limits those updates of data values that cause records to go off the view. The following instance tells this in more detail: Examp

Write short notes on data ware housing? Data ware housing applications needs the transformation of data from many sources into a cohesive reliable step set of data configured a