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
A database administrator''s responsibilities and data contents

Explain Alternate key? Alternate Key - All the candidate keys except primary key are known as alternate keys.

What are the two types of errors? The two types of errors are: a) Logical error b) System error

What is object identity? An object retains its identity even if some or all the values of variables or explanations of methods change overtime.

Describe the capabilities offered via MySQL client APIs? . • Checking for errors. . • Connecting to the MySQL server, selecting a database, disconnecting from the server

Explain the disadvantages of creating a temporary table? If you have already created a temporary table with a shown name and attempting to create a second one with that nam

The Assessment page has a link to download a conceptual model, and a list of data. You are to map this conceptual model, and create the database in Oracle using your own DDL.  T

What is meant by log-based recovery? The most widely used structures for recording database changes is the log. The log is a sequence of log records, recording all the update a

1.Suppose you are given a dataset that consists of a random sample of tasters, on which the following variables were obtained: (y) Zpref = taste preference for green beans store

Why containment is important in oosystems? Containment is an significant concept in oosystems because it allows dissimilar users to view data at different granularities.