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

Assignment Help:

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

 


Related Discussions:- Creating views with check option-data control

Er schema can be represented by relation schemas , Q. Describe how an ER sc...

Q. Describe how an ER schema can be represented by relation schemas and constraints arising from ER design can be mapped to constraints on a relation schema.     The entity rela

Having clause-data manipulation language, Having clause This clause...

Having clause This clause is used for producing conditions on grouped information. Example: Find maximum salary and department number of those departments where maxim

Security-drawbacks of data distribution, Security: In a centralised system...

Security: In a centralised system, access to the data can be simply controlled. Though, in a distributed DBMS not only does access to replicated data have to be controlled in many

Explain the dependency relationship of object oriented, Explain the depende...

Explain the dependency relationship of object oriented A dependency is a relationship which states that a change in specification of one thing can affect another thing, but n

Designing the database schema , The domain that you will model in this assi...

The domain that you will model in this assignment is that of courses and students at a university. So as not to make the task too large and unspecified, you will here get a descrip

Database, 3. (10 points) Assume that you have been presented with the follo...

3. (10 points) Assume that you have been presented with the following relation for the Baxter Aviation database: Charters (Pilot#, Pilot name, Aircraft ID#, #seats, Village, Fligh

What is the main goal of raid technology, What is the main goal of RAID tec...

What is the main goal of RAID technology? Describe the levels 1 through 5. RAID stands for Redundant Array of Inexpensive (or sometimes "Independent")Disks. RAID is a met

Data control, Identify the need and use of data control through problem sol...

Identify the need and use of data control through problem solving, illustration

Eer diagram, Design an EER schema for the following application and transla...

Design an EER schema for the following application and translate the EER schema into relational schemas (and constraints). It is possible that some requirements cannot be captured

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