Materialdesign: Relational icons needed (one-to-many, many-to-one)

[mdingena]

I need icons that represent a relation between rows. I need it to represent one-to-many and many-to-one relations.

Witness my awesome MS Paint skills:

• [ ] database-one-to-one
• [ ] database-one-to-many
• [ ] database-many-to-one
• [ ] database-many-to-many

[CoDEmanX]

Possibly one-to-one and many-to-many as well from a data modelling perspective.

[Templarian]

Updated the issue description above with tasks to include @CoDEmanX's suggestion.

These would be very useful icons to have.

[mdingena]

Possible designs for one-to-one and many-to-many:

[MrGrigri]

Here are probably the four most common.

---

Files

data-relation.zip

[CoDEmanX]

Is your work inspired by some visualization standard like UML? Haven't seen it before and it does not seem very intuitive.

[MrGrigri]

I got these from a UML of sorts from Lucidchart.

[goyney]

Lucidchart makes some funny videos, but they do not make good icons obviously.

[JapanYoshi]

While I recognized the UML symbols, I don't think they're suited to graphically represent relations, at least for people who aren't CS majors.
I made some icons based on format-list-bulleted-square:

[mariovials]

I need these icons too.
I think these symbols are the standard.

If they could make icons it would be great!
Thank you!

[MrGrigri]

@mariovials, that is what I based mine off of. I didn't do the zero ones though. Are those needed as well?

[mariovials]

I don't need them now.
Although perhaps you could take advantage of adding that too before they ask for it.
Thanks for your work, it's great!

[MrGrigri]

I believe we should add the UML standard endings as icons as I've done above. There are a couple that could be added, but adding these would add 36 total icons and that's why I left them out in the first place. These are the different terminators and each one would be paired with the other. I will make them and put them up here (hopefully get me some more icons)

• One
• Many
• One (and only one)
• Zero or one
• One or many
• Zero or many

Example

[goyney]

@MrGrigri If those are the standard, I say we just add them all. What you prepared above looks good, so if you make them in that style, just go add them. 😄

[MrGrigri]

I'm only showing the icons relation-one-to-*. All 36 icons are in the single SVG. Each path is pre-optimized with an ID for its icon name. I've also included the Illustrator file just in case something is screwed up.

---

Files

relation.zip

[mariovials]

Sorry for my work, I didn't have the Illustrator at hand, but I tried to do something with an image editor.
It's a variant.

It might be useful to have a variant

[MrGrigri]

I believe we should just stick to the UML standard. Those can get confusing.

[CoDEmanX]

To follow the UML standard we would need to use their "many" terminal though: ⪪

[MrGrigri]

That is too much detail at 1x. That's why I used a triangle. Plus, I've seen a triangle before...I believe Access uses it. By standard, I mean it's concept

[CoDEmanX]

Probably, but it has "many" ends (3), which is somewhat intuitive. A triangle doesn't really convey this meaning.

Why do we need both ends in a single icon BTW? Why not icons for each UML terminal?

[JapanYoshi]

I implemented some of @mariovials' suggestions. Thank you!

I also made primary key and foreign key icons, but I'll post them on another thread.

[MrGrigri]

@CoDEmanX, We could do singles as well. But the reasoning behind the two terminals on one icon is to represent the relation between two records.

Also, I tried the tree lines, but it didn't work well; too small.

[Templarian]

Feel like these are pretty close to being added. If someone can finalize and add them. ✔️

[goyney]

All 36 of @MrGrigri's icons have been added. See relation-* set.