What is Stored and derived attributes?

Database Management System > DBMS Data Models > ER Diagrams

Short Question

2036

Answer:

In some cases, two or more attribute values are related in such a way that the value of one attribute can be determined from the value of other attributes or related entities. Consider an entity type PERSON and its attributes Date_of_birth and Age. The value of the attribute Age can be determined from the current date and the value of Date_of_birth. Thus, the attribute Age is known as a derived attribute and the attribute Date_of_birth is known as a stored attribute.

Go to Question List

This Particular section is dedicated to Question & Answer only. If you want learn more about Database Management System. Then you can visit below links to get more depth on this subject.

Database Management System Syllabus

Database Management System Syllabus Tutorial

DBMS Interview Questions

DBMS MCQs

# C Tutorials # JAVA Tutorials # HTML Tutorials # Computer Fundamental # Data Structure # DBMS Tutorials SQL # C# Language # R Language # PHP # Python # Vue JS

Join Our telegram group to ask Questions

Click below button to join our groups.

Ask Question - CSE

Programming Language - PDF

Related Program List

875. What is Single-valued and multi-valued attributes?

Answer:

The attributes that can have only one value for a given entity are called the

# Tutorial: ER Diagrams

Question: DBMS Data Models Short

876. What is Complex attributes?

Answer:

The attributes that are formed by arbitrarily nesting the composite and multivalued attributes are called complex attributes. This is represented by grouping the components of a composite attribute between parentheses ‘()’ and by displaying the multi-valued attributes between braces ‘{}’, and attributes separated by commas. For example, a publisher can have offices at different places, each with different addresses and each office having multiple phones (Figure below).

# Tutorial: ER Diagrams

Question: DBMS Data Models Short

Chapterwise Java Program
Chapterwise C Program
Chapterwise Data Structure Program

What is Stored and derived attributes?

Answer:

Join Our telegram group to ask Questions

875. What is Single-valued and multi-valued attributes?

876. What is Complex attributes?

877. What are the various situations in which an attribute can use a null value?

878. Differentiate between a superkey, a candidate key and a primary key.

879. Explain the difference between strong and weak entity type.

880. Explain the various types of constraints on relationship types of the E-R model.