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!
When are two schedules said to be view equivalent?
Ans: Two schedules that is denoted as S and S' are said to be view equivalent if the subsequent three conditions are met
1) For every data item Q, if a transaction Ti reads the initial value of Q in schedule S, after that transaction Ti should in schedule S' also read the initial value of Q.
2) For every data item Q, if a transaction Ti executes read(Q) in schedule S and that value was generated by Tj (if any) , then transaction Ti must in schedule S' as well read the value of Q generated by Tj.
3) For every data item Q, if a transaction if any that carries out the final write(Q) in schedule S should perform the final write(Q) in schedule S'.
How do you find the final model after iterative analysis? Why is iterative analysis of any of the problem needed? The final model serves as the base for system architectur
What are uncommitted modifications? The immediate-modification technique permits database modifications to be output to the database whereas the transaction is still in the act
Explain the conventions (relationships) for displaying an ER schema as an ER diagram.
How can you map NULL values to other values while display? IF( ) , IFNULL( ) keywords are used to do so. They are 'LIMIT' is used for the following kinds of problems: 1) Ans
What is storage manager? A storage manager is a program module that gives the interface among the low level data keeps in a database and the application programs and queries su
Table_Name( attribute_1, attribute_2, attribute_3, ….. ,attribute_x) Primary Key ( attribute_1, attribute_2) Foreign Key attribute_4 References Table_Name_2 (repeat for each fore
how to write tables and drow E-R diagrams for hosiptal management system and how to normalize and cardinalities?
Write short notes on Schema diagram. A database schema along with primary key and foreign key dependencies can be depicted pictorially by schema diagram. Every relation appea
Types of data independence Data independence can be classified into the following two types: Physical Data Independence: This means that for any change made in the physi
Give an example of enforcement in Typing. You can understand the idea of enforcement as it makes sure objects of dissimilar classes may not be interchanged as below: Exampl
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