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
Advantages of Observation  Methods: Bailey has pointed  out four  advantages of observation: 1. Superior in Data  Collection  on Non Verbal Behavior: When  a person  a opi

what is database management system? & why it is required?

Why DML is used for? DML is used to Manipulation and processing of database. DML is provided for manipulation & processing of database. (Data stored in the database is processed

Differentiate between natural join and outer join? Natural join is a binary operator which is written as (R * S) where as R and S are relations. The output of the natural join

This project requires you to create a database design.  Your design will be documented in a set of Entity-Relationship diagrams.  Draw a set of Entity-Relationship diagrams to mode

write on the various type of relationalkey

Define in which normalisation form if an attribute of a composite key is dependent on an attribute of other composite key. Ans: 3NF A relation is in 3 NF if an attribute of

Write short notes on tuple relational calculus. The tuple relational calculation is anon procedural query language. It defines the desired information without giving a particul

We want have a website; we need to test the security of our website. You need to: -Try to bypass our security by simulate a website hacking -Try some hack Techniques like

Inconsistent Analysis : The problem as given with transactions T1 and T2 where two transactions interleave to make incorrect result during an analysis by Audit is the instance of s