ERD Visio 2010 Drawing - Table Relationships

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....
Amour22015Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arnoldCommented:
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
Amour22015Author Commented:
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
arnoldCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Amour22015Author Commented:
Thank you this is what I am looking for...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Visio

From novice to tech pro — start learning today.