Solved

ERD Visio 2010 Drawing - Table Relationships

Posted on 2016-08-27
4
115 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

813 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

15 Experts available now in Live!

Get 1:1 Help Now