Solved

ERD Visio 2010 Drawing - Table Relationships

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

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 76

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

My experience with Windows 10 over a one year period and suggestions for smooth operation
In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
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.

743 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

8 Experts available now in Live!

Get 1:1 Help Now