Thank you so much for this. I've been taking a database course this season and it was such a headache trying to navigate Visio's options for making proper ERDs.
does anybody know how to diagram a scenario where students are selecting 3 workshops to attend? the third selection would be an alternate class if one of the first two choices were not available. ive got a student table, a workshop table, an intersection entity(between student & workshop), school, and staff.
For Many-to-Many relationship in your example, you had already created manually the "benifitId" attribute on the "SalariedEmployee" entity... which is, therefore, not identified as an FK by Visio... when you manually draw the many-to-many relationship.... Thus, in your final diagram, "EmpId" attribute on the "Benefits" entity is shown as an FK, but the "benifitId" attribute on the "SalariedEmployee" entity is simply a regular attribute... whereas both should be FK.
in my school, i failed this subject coz its really hard to understand. but this one, its really fast to understand. now, i can make my project without a hard time to scan lots of books. thanks to you maam. God bless..
You are correct. These videos are used as a foundation before normalization concepts are taught so students can conceptualize a M:N relationship before learning normalization.
Thanks for the great tutorials, it was the only tutorial that I found that answered all my questions. The tip about how to create a many to many relationship was especially helpful!
Nice work.
paavenda 2 weeks ago
excellent tutorial thanks :)
kr4zzym3 1 month ago
nice work thnx alot for your efort it's simple & effective :)
eslamsamymeg 5 months ago
not working for me. I'm in developer mode, clicking apply and ok when I assign the ends. it just doesn't change.
anthemofadam 6 months ago
For Visio 2010 to enable developer mode:
Go to File -> Options -> Advanced -> Under General section -> Select "Run in developer mode"...
samarch2001 7 months ago
This has been flagged as spam show
Thank you so much for this. I've been taking a database course this season and it was such a headache trying to navigate Visio's options for making proper ERDs.
LightSK 9 months ago
Comment removed
LightSK 9 months ago
Comment removed
LightSK 9 months ago
does anybody know how to diagram a scenario where students are selecting 3 workshops to attend? the third selection would be an alternate class if one of the first two choices were not available. ive got a student table, a workshop table, an intersection entity(between student & workshop), school, and staff.
lunchmakerd 1 year ago
For Many-to-Many relationship in your example, you had already created manually the "benifitId" attribute on the "SalariedEmployee" entity... which is, therefore, not identified as an FK by Visio... when you manually draw the many-to-many relationship.... Thus, in your final diagram, "EmpId" attribute on the "Benefits" entity is shown as an FK, but the "benifitId" attribute on the "SalariedEmployee" entity is simply a regular attribute... whereas both should be FK.
abcd321839955 1 year ago
Thanks for taking the time to put together this tutorial. It was very helpful.
brutalityNZ 1 year ago
thank you very much for your tutorial, that cleared up things about how to make subclasses through visio. very nice voice too. take care!
takatakboy 1 year ago
thanks for this video. its a building block
saviojason 1 year ago
Really AppreciateThis, Thanks
guerillacity 1 year ago
in my school, i failed this subject coz its really hard to understand. but this one, its really fast to understand. now, i can make my project without a hard time to scan lots of books. thanks to you maam. God bless..
ramzcezz 1 year ago
haha that's true but this tutorial is all about how to create an erd drawing in Visio, not to learn what ERD is, this is a great tutorial
valrecx 2 years ago
in a ERD it is a rule to not have many to many lol i learnt that at basic level this is not how u draw a ERD in a real world situation
ajtango 2 years ago
You are correct. These videos are used as a foundation before normalization concepts are taught so students can conceptualize a M:N relationship before learning normalization.
pashortt 2 years ago 2
nice thanks.
gongxia649 2 years ago
i love you :) i couldnt figure out how to fix the ends of the relationship, thank you :) saved me so much time
naveed80 2 years ago
thanks for the great tutorial! It saved me a lot of time reading though a text book lol. Plus you have a really nice voice :)
Julznova 2 years ago
Thanks for the great tutorials, it was the only tutorial that I found that answered all my questions. The tip about how to create a many to many relationship was especially helpful!
Thanks again.
dr3am3rs 3 years ago
Thanks, but what you were clicking on to select style around 1:38 mark? The mouse went below the viewable area. Thanks!
scottfrenz 4 years ago
I say it in the video...right click then click Format and select Style
pashortt 4 years ago
Unfortunately, there is no such option in Visio 2007. Just Protection, Behavior, and Layer, but no style. :(
otterbehave 3 years ago
You have to enable developer mode. Go to Tools->Options->Advanced->Run In Developer Mode
dork2323 3 years ago 3
@dork2323 thank you so much.
ausvincas 1 year ago