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

What are the states of transaction, What are the states of transaction? ...

What are the states of transaction? The states of transaction are:- a) Active b) Partially committed c) Failed d) Aborted e )Committed   f) Terminated

Sql, sql is relationally complete-justify

sql is relationally complete-justify

Alter table command, ALTER TABLE Command : This command is used for variati...

ALTER TABLE Command : This command is used for variation of existing structure of the table in the given situation: When a new column is to be added to the table structure.

What is relationship, What is relationship? Give examples A relationshi...

What is relationship? Give examples A relationship is an association between several entities. Example: A depositor relationship associates a customer with every account tha

What is property - properties of a database, What is property - properties ...

What is property - properties of a database ? It is an integrated collection of logically related records. It consolidates separate files into a common pool of data records and

Describe object relational model, Describe Object Relational model ? O...

Describe Object Relational model ? Object Relational Model - This model combines the characteristics of both relational model and object oriented model. It extends the tradit

ER diagram, #question. acompani datdbase needs to store information about e...

#question. acompani datdbase needs to store information about employees (identified by a social security number,with salary and phone as attributes) and departments (identified by

Describe a technique for direct search, Describe a technique for direct sea...

Describe a technique for direct search? Explain how data is stored within a file so which direct searching can be performed. For a file of unordered fixed length records by u

Which two files are used during operation of the dbms, Which two files are ...

Which two files are used during operation of the DBMS? Data dictionary and transaction log are two files used during operation of the DBMS.

Note gate, i want notes on this topic

i want notes on this topic

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