Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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
Can a filed occur in several field groups. Yes. But it leads to redundant data redundancy.
For every multivalued attribute 'A', we make a new relation R that contains an attribute corresponding to plus the primary key attribute k of the relation that shows the entity typ
The natural join is equal to which product? The natural join is equal to Combination of projection and Cartesian product
Determine the Persistent object Persistent object can be stored in one of the following: Files Cheap, permanent, simple storage Low level (Write, Read) Ap
Define multivalued dependency. What do understand by trivial multivalued dependency? Ans: A multivalued dependency is a full constraint among two sets of attributes in a rela
distributed quey processing
Question 1 Explain the functions of the following Storage Manager Buffer Manager Transaction Manager 2 Discuss about system catalog in a relational DBMS 3
What is a shadow copy scheme? It is simple, but efficient, scheme known as the shadow copy schemes. It is based on making copies of the database called shadow copies that singl
Implementation and SQL Applications
Entity types that do not have any key attribute, and therefore cannot be identified independently, are known as weak entity types. A weak entity can be recognized uniquely only by
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!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd