Jump to content
Larry Ullman's Book Forums
Sign in to follow this  
Jonathon

Mysql Workbench Relationship Arrows

Recommended Posts

I apologise for the crudeness of this example. I'm using the workbench on a personal project and I've plugged in all my data and allowed the workbench to generate the relationships, which is fine. but what is the difference between relationships that start

 

-| |---------

 

 

and ones that start like

 

-|-|----------

 

is one identifying and the other non-identifying?

 

On a secondary note, I feel like most examples i've seen of your models Larry flow nicely in an almost clockwise manner. I'm finding that mine has 5 tables that all feed into a central table, this central table is the hub of the displayed information, but there is a fairly large proportion of the central table that is built up from P.Keys in the other tables. Does this mean that my design is poor at a guess? I realise that there isn't a great deal of information for you here, but I didn't want to bombard you with huge swathes of information.

Share this post


Link to post
Share on other sites

I don't have any idea what the difference is between those two lines, if any. Sorry.

 

As for your second question, there are certainly times where the design ends up almost circular and sometimes where it's a star pattern like you're describing. I don't think that means it's bad. I assume you went through the due diligence and that's just how it looks at the end.

Share this post


Link to post
Share on other sites

Hi Larry,

 

Yes I did, after I wrote this post I looked up other exampLes and found that they weren't too disimilar to mine. We'll see, I'm redoing my personal Yii project, so it's no big deal if it's not quite right.

 

Thank you

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...