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
To eliminate duplicate rows (distinct operator)  Example: SELECT DISTINCT DEPTNO FROM EMP;

When every condition appears with equality condition (=) only. c)   Natural join (denoted by R*S) When two join attributes have the similar name in both relations. (Tha

What is advantage of two-way association? Two-way association advantages are following: a) Independent of the classes. b) Useful for existing predefined classes that are

Assume that you are responsible for selecting a new DBMS product for Sohar Hospital

These are the binary operations; i.e., each is applied to two relations or sets. These two relations can be union compatible excluding in case of Cartesian product. Two relations R

Define Catalog and meta data ? A catalog is a compilation of records elaborating the contents of a particular collection or group of collections. Metadata (Meta data, or someti

The State of NewYork certifies firefighters throughout state and keep track all of them, as well as of the state’s fire departments. Each fire department has unique department numb

What is the archtetype/instance pattern? The archetype/instance pattern happens when one entity tracks occurrences of another entity. A common example is the relationship among

What are the various forms of data transparency? a) fragmentation transparency b) replication transparency c) location transparency

Which are the two ways in which entities can participate in a relationship? Total and partial are the two ways in which entities can participate in a relationship