Drawing Entity Relation Diagram

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

agbe981

Thread Starter
Joined
Feb 13, 2009
Messages
209
there is this application that i am working on as my project work. i want to draw entity relation diagram for the database as part of the documentation.

my question is can you have one relationship relating to another relationship? for example, client withdraws from his account and can also transfer funds from his account to another account, this should as well record the staff that did the transfer.

i hope to hear from u soon
 
Joined
Oct 30, 2008
Messages
276
I think you might be over complicating things.

It seems to me, however the money is being moved, you are preforming a transaction. All of the relationships would fall under that regardless of the transaction type. The transaction table would hold the key values to pull the actual data from their related tables. I think those are the relationships you are looking for.

Hope this helps.
 
Joined
Jul 28, 2008
Messages
1,899
Different relationships cannot be linked to each other, they have to have an entity on both sides. In the case of your scenario you will need three entities at least, Client, Account and Staff which can then be linked using the correct relationship types.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top