Explain view in rdbms, Database Management System

Assignment Help:

Explain view in RDBMS?

View - A view is a relation (virtual rather than base) and could be used in query expressions, which is, queries can be written by using the view as a relation. Instead, a view is a named table in which is represented, not through its own physically separate stored data, but through its definition in terms of other named tables (base tables or views). The base relations on that a view is based are sometimes known as the existing relations. The definition of a view in a create view statement is stored within the system catalog. The syntax to create a view is:

CREATE [OR REPLACE] VIEW [()] AS

WITH {READ ONLY|CHECK OPTION [CONSTRAINT

]};


Related Discussions:- Explain view in rdbms

Define signal, Define Signal. It allows methods to respond to events tr...

Define Signal. It allows methods to respond to events triggered by themselves or by other processes. Each signal corresponds to an exacting event. A signal is represented in Sy

Define the concept of design documentation, Design Documentation  The ...

Design Documentation  The Design Document shall be an extension of Requirements Analysis Design. "The Design Document will comprise a revised and much more detailed descrip

Give the limitations of sql authorization, Give the limitations of SQL auth...

Give the limitations of SQL authorization. The code for checking authorization becomes intermixed with the rest of the application code. Implementing authorization by applic

Unix System Administration, What Command You Use What Day of the week were ...

What Command You Use What Day of the week were you born

Mobile database, write short note on mobile database

write short note on mobile database

Sorting field groups we cannot use more than one key field, While sorting f...

While sorting field groups we cannot use more than one key field False.

Failures and recovery, Failures and Recovery In practice various things...

Failures and Recovery In practice various things might occur to prevent a transaction from completing. Recovery methods are used to bring database, which does not satisfy consi

Issues relating to the design of the physical database files, The issues re...

The issues relating to the Design of the Physical Database Files Physical File is a file as stored on the disk. The major issues relating to physical files are:  •      Cons

What is relational algebra, What is Relational Algebra? Relational algebr...

What is Relational Algebra? Relational algebra is a Procedural query Language?

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd