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!
What is serializability? Explain its types?
The data base system must control concurrent implementation of transactions, to ensure that the data base state remains consistent. There are dissimilar forms of schedule equivalence they lead to the notions of
a) Conflict serializability
B) View serializability
Conflict serializability
We say that ii and I j conflict if they are operations by dissimilar transaction on the similar data item and at least one of these instruction is a write operations
What is assertion? Mention the forms available. An assertion is a predicate expressing a condition that we wish the database always to satisfy. Domain integrity constraints.
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
Compare the two log-based recovery schemes in terms of ease of implementation and overhead cost. Ans: There are two types of log based recovery techniques: deferred update
With the help of a suitable diagram gives module wise explanation of system architecture of DBMS.on..
Data independence seems that "the application is independent of the access strategy and storage structure of data". In other words, the ability to change the schema definition in o
what is object-identity
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
E-R model uses this symbol to represent weak entity set ? A Doubly outlined rectangle symbol is used to represent weak entity set.
What are the disadvantages of relational approach? Disadvantages of relational approach: • Substantial hardware and system software overhead • May not fit all business models •
what is definition hierarchical data model
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