What is the difference between base and derived relation?

Answer

Relational database means the relationship between different databases. In relational database user can store and access all the data through the tables which are related to each other. Relationship between the store data is called base relations and implementation of it is called as tables. Whereas, relations which don’t store the data, but can be found out by applying relational operations on other relations are called as derived relations. When these are implemented they are termed as views or queries.
Derived relations are more useful then base relation, as they can have more information from many relations, but they act as a single relation.

All rdbms Questions

Ask your interview questions on rdbms

Write Your comment or Questions if you want the answers on rdbms from rdbms Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---