State the two-way associations, Database Management System

Assignment Help:

Two-way Associations

Mostly, associations are travel in both directions, although not usually with same frequency. There are three approaches for the implementation.

  • In bi-directional associations, if one direction association is seldom used, then we should implement it as unidirectional association. Searching can perform reverse association. This way, we can reduce storage and update cost.
  • Implementing it as a bi-directional association using the several techniques discussed in previous sections will turn up as shown in Figure. This approach provides faster access but also requires updating of other attributes in case of any change otherwise the link will become inconsistent.

Implementing it as a separate association object, i.e., independent of any class as shown in Figure. The association object can be implemented using two objects: one in forward direction and the other one in the reverse direction. This cause increases efficiency when hashing is used, instead of attribute pointer.

 

584_two way association.png

  Figure:  Implementation of association as an object


Related Discussions:- State the two-way associations

Control as a state machine engine, Control as a State Machine Engine F...

Control as a State Machine Engine First let us define the state machine: "the state machine is a machine which is an object but not an application object. It is a part of lang

Define a view and a trigger, Define a view and a trigger. Construct a view ...

Define a view and a trigger. Construct a view for the above relations that have the information about suppliers and the elements they supply. The view holds the S#, SNAME, P# , PNA

List the steps for converting state diagram to the code, List the steps for...

List the steps for converting state diagram to the code. a) Finding major control path b) Finding the conditional statements  c) Finding the loops  d) Finding error ro

File Management Principles, What are the requirements to ensure the objecti...

What are the requirements to ensure the objectives of file management principle is realized?

Define data conversion, Define data conversion? Helpful to load data in...

Define data conversion? Helpful to load data into temporary staging tables. Then can write SQL code to do much of data processing. SQL code is simpler and faster to write than

What are partial and natural key, What are partial, alternate,, artificial,...

What are partial, alternate,, artificial, compound and natural key? Partial Key: It is a set of attributes that can uniquely recognize weak entities and that are related to s

What are the issues are formed while selecting a database, What are the Iss...

What are the Issues when Selecting a Database Issues when Selecting a Database Storage space requirement: A database requires about triple storage space of the actua

Explain differance between primary and secondary storage, Explain differanc...

Explain differance between Primary and secondary storage ? Primary and secondary storage Computer storage is classified within primary(main) memory and secondary(per

Prove that a relation which is 4nf must be bcnf, Prove that a relation whic...

Prove that a relation which is 4NF must be BCNF.   Ans Let R be in 4NF.  Suppose it is not in BCNF.  Hence, there exists an FD X→Y in R such that x is not a super key. Although

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

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!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd