Creating views with check option-data control, Database Management System

Creating views with check option: This option limits those updates of data values that cause records to go off the view. The following instance tells this in more detail:

Example: To produce a view for employees of Department = 30, such that user cannot alter the department number from the view:

CREATE OR REPLACE VIEW EMPD30 AS

SELECT EMPNO EMPL_NUM, ENAME NAME, SAL SALARY FROM EMP

WHERE DEPTNO=30

WITH CHECK OPTION;

 

Now the user cannot alter the department number of any record of view EMPD30. If this change is permitted then the record in which the change has been made will go off the view as the view is only for department-30. This restricted due to use of WITH CHECK OPTION clause

 

Posted Date: 3/11/2013 1:25:09 AM | Location : United States







Related Discussions:- Creating views with check option-data control, Assignment Help, Ask Question on Creating views with check option-data control, Get Answer, Expert's Help, Creating views with check option-data control Discussions

Write discussion on Creating views with check option-data control
Your posts are moderated
Related Questions
Define single valued and multivalued attributes. Single valued attributes: attributes with a single value for a particular entity are known as single valued attributes. Mult

Use inheritance as an implementation technique when you are going to use inheritance as an implementation technique, you can achieve same goal in a safer way by making one cla

What is the difference among a database schema and a database state? The collection of information stored in database at particular moment in time is known as database state a

What is entity in DBMS? Entity: A DBMS entity is either a thing in the modelled world or a drawing element in an ERD.

An object-oriented design process  1. Define the context and modes 2. Designs the system architecture 3. Identifies the principal system objects 4. Identifies concurrency in

Which language has presently become the defacto standard for interfacing application programs along with relational database system? The language which has recently become the

A file of employee have 10,000 blocks on a cylinder of a disk with characteristics r=8ms and btt=0.6ms I want to know the cost of read inthe file under following conditions for a q

Differentiate sub-class and super-class? The specialization of a class is known as subclasses.eg: employee is a subclass of person and teller is a subclass of employee. Convers

Define database management system? Database management system (DBMS) is a set of interrelated data and a combination of programs to access those data.

What is RDBMS terminology for a row? A tuple is a RDBMS terminology for a row