Solved

ERD Visio 2010 Drawing - Table Relationships

Posted on 2016-08-27
4
98 Views
Last Modified: 2016-08-29
Hi  Experts,

I have several Tables that I have drawn and am currently drawing the relationships between table(s).

I have noticed that some of the connectors have Parent/Child relationships like:
Parent: TblParent and Child: TblChild

And other(s) have:

Parent: TblParent and Child: "Nothing"

Or:

Parent: "Nothing" and Child: "Nothing"

Or:
Parent "Nothing" and Child: TblChild

What determines this?
I am missing something?
I am not doing something correct?

I want them all to be:
Parent: TblParent and Child: TblChild


Please help and Thanks....
0
Comment
Question by:Amour22015
  • 2
  • 2
4 Comments
 
LVL 77

Expert Comment

by:arnold
ID: 41773758
What is the relationship type? Direction, one to one, one to many, many to many?

Do you have the database design ?
You can have a reference relationship .........

Without the specifics, it is merely a guess on my part.
0
 

Author Comment

by:Amour22015
ID: 41775068
Hi,

Thanks for helping me.

All I am looking for is why the:
Parent: tblparent
Child: tblchild

is indicated on some of the relationships, yet not on others?

and how to fix this.


There must be a way to turn both on.

Please help and thanks
0
 
LVL 77

Accepted Solution

by:
arnold earned 500 total points
ID: 41775164
You have to look at what the columns are that the relationships represent.
i.e. a primary key in one table will be reflected as a parent to an entry in the second table(child).
If the reference in table A and table B are merely referential, there is no parent/child relationship.

user to sale invoices would be a parent to child i.e. a user can have multiple sales invoices
a sale invoice to a list of items, one sale invoice can have multiple items. this is a reference table and there is no parent/child relationship, or at least I think so.

There could be many users with different sales invoices where each sales invoice can reference an item.

Lets try it this, way. A parent takes their child and a group of the child's friends. There is one parent/child relationship and adult to children reference. When parents drop their children to a third party, there is no parent-child relationship. there is only adult/supervisory to young people .......

What is it you want fixed.

What do you want the ERD to reflect on these relationships, parent/child?
Note parent/child means the Parent has to be a unique record.
0
 

Author Closing Comment

by:Amour22015
ID: 41775626
Thank you this is what I am looking for...
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Skype is a P2P (Peer to Peer) instant messaging and VOIP (Voice over IP) service – as well as a whole lot more.
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now