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!
(a) Explain the three types of potential mistake which could occur if concurrency control is not properly enforced in the database system. Support your answer with appropriate example for each.
(b) Explain the data access protocol based on the compatibility matrix.
(c) Describe "deadlock" and give an example.
(d) Describe how a deadlock state can be detected and how the system can break such a state.
Flights(FlightNo, DeptDateTime, Origin, ArrivalDateTime, Destination, Capacity, SoldSeats) Tickets(FlightNo, Seat, CustID) Where - flightNo is the PK of the flights table - DeptDa
what are the states of transaction?
What type of view of total database content? Data base content Conceptual view of total database contain.
Whst is logical schema ? Logical schema is the entire database.
What is association? Give an example of association Association is used for establishing relationships among classes. Association describe links among/between classes. For exa
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
How many types of Views are there? There are Four types of views:- Database View Help View Projection View Maintenance View
What are the two types of indices? The two types of indices are:- A) Dense index B) Sparse index
explain cascading rollback
What is difference between primary index and secondary index? Primary Index a) It is an ordered file whose records are of fixed length along with two fields. b) Only base
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