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
Submission Requirements All answers must be computer generated (including text and diagrams). The hand-in version must include a header page (or with sufficient space)

If R1 and R2 are two relations or functions, then the result of R3 = R1 × R2 is the combination of tuples that are in R1 and R2. The product is associative and commutative. Degr

How to define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a


Let us first describe the term relationships. What Are Relationships? A relationship can be defined as: A set of associations or connection, or A rule for communic

What is association? Give an example of association Association is used for establishing relationships among classes. Association describe links among/between classes. For exa

PHYSICAL DBMS ARCHITECTURE  The physical architecture defines the software components used to process and enter data, and how these software components are related and interc

What are the physical characteristics of magnetic disks?   Ans: A magnetic disk is a circular plate or platter of plastic or metal that is coated with magnetizable material lik

These permit the user to unload a database or parts of a database and reload the data on the similar machine, or on another machine in a dissimilar location. This can be useful in

Question: In a multi-user database environment, locking mechanisms can be used to solve the three basic problems of concurrency. On the other hand, however, locking may also le