Define view? how it is related to data independence, Database Management System

 

A View may be defined of as a virtual table, that is, a table that does not really exist in its own right but is instead inferred from one or more underlying base data table. There is no stored file that direct shows the view instead a definition of view is loaded in data dictionary. Restructuring and growth of base tables is not shown in views. Thus the view may insulate end users from the effects of developing and growth in the database.

 

 

944_View.png

Posted Date: 7/30/2012 1:38:35 AM | Location : United States







Related Discussions:- Define view? how it is related to data independence, Assignment Help, Ask Question on Define view? how it is related to data independence, Get Answer, Expert's Help, Define view? how it is related to data independence Discussions

Write discussion on Define view? how it is related to data independence
Your posts are moderated
Related Questions
Saving Derived Attributes to Avoid Re-computation   As discussed, "redundancy means duplication of exact data". But, if multiple copies of same data are present in the system,

A full discription of the new, a discription of its components, and the bebefit it will provide a company. A disscussion of the information usedin the system. A disscussion of any

What do you mean by persistence? How you will make your data persistent? Persistent data is the data, which has a longer lifetime than program which has created it. Enabling th

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

An important first step to the statistical analysis of data is to "get to know your data".  The following tasks should contribute to this. (a)   To the right of the dataset cons

draw er diagram using entities crop,employee,department,plot,cultivation plan,machinery,seed,fertilizer

Explain the concept of generalization and aggregation in E_R diagrams. Give one example for each one of them? Generalization: Consider extending the entity set account throug

Assignment #1 Data Management The questions on this exam are based on the Baxter Aviation case scenario. 1. (5 points) The systems analyst proposes the following two relationshi

What is use of generating such tables? How can you create temporary tables? When you require a table only for a short time after that you want it to disappear automatically you

It can be easily defined as: The database must not have any unmatched foreign key values. The term "unmatched foreign key value" means a foreign key value for which there doe