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!
Analyzing Association Traversal
Till now, we have supposed that associations are bi-directional. But in the case of traversal, it is in only one direction in any application, implementation becomes easier.
Though, for finding unidirectional associations we require to be extra cautious, as any new operation added later can be required to traverse association in the opposite direction also. The bi-directional association makes expansion or modification easier.
To change our decision of implementation strategy with least effort, we should hide implementation, using access operations to traverse and update association.
Define the Wait for graph Ans: The wait-for-graph is a directed graph and consist of nodes and directed arcs; the nodes of the graph are active transactions. An arc of the grap
What is the difference among a primary index and a secondary index? Primary Index: A primary index is an ordered file whose records are of fixed length along with two fields.
What are the uses of functional dependencies? To test relations to see whether they are legal under a given set of functional dependencies. To state constraints on the set
What is called as an N-way merge? The merge operation is a generalization of the two-way merge used by the standard in-memory sort-merge algorithm. It merges N runs, so it is k
What are the two statements regarding transaction? The two statements regarding transaction of the form are:- A) Begin transaction B) End transaction
What is 2NF? A relation schema R is in 2NF if it is in 1NF and every non-prime attribute A in R is fully functionally dependent on primary key.
There are two major types of fragmentation: Horizontal& Vertical. Horizontal fragments, as the name suggests are subsets of tuples and vertical fragments are subsets of attributes
Explain the function of Object model Object model describes the classes of objects in system, including their attributes and operations which they support. The analysis object
atient(PNumber, Name, NHS_no, Amount_due, DNO, Doctor, Medical_Treatment), relation of schema Staff(StaffNum, Name, DNO, Task) and relation of schema Dept(DNO, Name, Location, Dire
In case of entity integrity, the primary key may be declared? In a case of entity integrity primary key may be not Null.
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