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
A database to track your progress in your college program will track your progress towards graduation! A database that has information containing the classes that you have taken, c

What are domain constraints? A domain is a set of values that might be assigned to an attribute .all values that appear in a column of a relation must be taken from the similar

give some example real life situation where DBMS are most suitable

Describe entity referential integrity and integrity. Give an example of each. Entity Integrity Rule - If there is a attribute A of relation R is a prime attribute of R then A

What is the purpose of storage manager? The storage manager is responsible for the following a) Interaction with the file manager b) Translation of DML commands in to low

What is a records management consultation? Our organization is an authority for disseminating your specific requirements and giving you with a solution to effectively manage yo

What is a dataset? A dataset is an in-memory database that is disconnected from any regular database, but has all the significant characteristics of a regular database. Dataset

What is DAG? The class-subclass relationship is shown by a directed acyclic graph.eg: employees can be temporary or permanent. We might be create subclasses temporary \and perm

10A.53 Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department. 10A.54 Code an Oracle Database trigger to allow the

Consider the following relational scheme: R (a,b,c,d,e,f) and its corresponding set of FDs {d→ a, be → c, ac → e, b → f, f → d, a → c}. a. Is the following decomposition i) non