If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back  dBforums > General > Database Concepts & Design > Is it Correct to use Ternary Relationship here ?

LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Registered User
Join Date: Dec 2012
Posts: 1
Arrow Is it Correct to use Ternary Relationship here ?


Im trying to design ER diagram for Business.

This company uses GIN(Good Issue Note) and GRN(good receive note) to issue and receive stocks to branches all over country.

Company receives stocks by shipment from supplier in other country. Company transfer this stocks from port to main storage in order to distribute all over branches. When they issue stock from port they use GIN and at the main storage they use GRN.

Relationships i want to build is
1 ) Shipment stock issued to Store with GIN
2) Store Receive shipment stock with GRN.

I already have entities for GIN, GRN, Store and Shipment.
Please help me to understand how to build relationship as above 1 and 2/

Thank you in advance
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On