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

Define partial, Partial Key : It is a group of attributes that can uniquel...

Partial Key : It is a group of attributes that can uniquely identify small entities and that are related to same base entity. It is sometime named as Discriminator.  Altern

Compare wait-die deadlock prevention with wait-wound scheme, Compare wait-d...

Compare wait-die deadlock prevention scheme with wait-wound scheme   Ans:  Wait-Die Scheme  a) Based upon a nonpreemptive technique.  b) If Pi requests a resource present

What is derived and stored attribute, What is Derived and stored Attribute?...

What is Derived and stored Attribute? Derived and Stored Attribute - In a few cases, two or more attribute values are associated, for example, Age and BirthDate attributes of a

Name the various privileges in sql, Name the various privileges in SQL? ...

Name the various privileges in SQL? A) Delete B) Select C) Insert D) Update

The conceptual level or global level in dbms, The Conceptual Level or Globa...

The Conceptual Level or Global level The conceptual level presents a logical view of the complete database as a unified whole. It permits the user to bring all the data in th

Write short notes on relational model, Write short notes on relational mode...

Write short notes on relational model The relational model uses a collection of tables to show both data and the relationships between those data. The relational model is an ex

Develop a database design , A practice called Perfect Pets provides private...

A practice called Perfect Pets provides private health care for domestic pets throughout America. This service is provided through various clinics located in the main cities of Ame

Explain about primary key, Explain about primary key Primary Key: It ...

Explain about primary key Primary Key: It is one of the candidate keys that are taken to be the recognizing key for the entire table. E.g. although there are two candidate ke

Determine the subsystem design issue, Determine the Other System Design Iss...

Determine the Other System Design Issue How to realise subsystems; through hardware or software? How is object model mapped on chosen hardware software? Mapping

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