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
What are temporary tables? Temporary tables exist solely for a particular session or whose data persists for the duration of the transaction.

how to write a in a text and load it on mysql


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


Define the basic operations of the relational algebra?     Ans: Basic operators of relational algebra are: 1. Union (∪) - Selects tuples which are in either P or Q or in bot

What is aggregate function? Briefly describe it? Aggregate functions are functions that take a collection of values as input and return a one value. SQL offers 5 built-in aggre

Express the following queries in SQL: (a) Write the SQL code that will create ALL the four tables given in the appendix. Your answer should not contain the primary key and

What is transaction? Collections of operations that form a single logical unit of work are known as transactions.

Ask Write the SQL code that will create the table structure for a table named EMP _1. This table is a subset of the EMPLOYEE table. The basic EMP_1 table structure is summarized in