All textbooks concerning databases material in a college setting cost this much easily if not more, I had a Database book that cost over $300, Of course I bought a used one, no way in the world am I paying $300.
I dropped out of college after my first semester, went home watched this video, created and ERD, than picked up python, django, created a backend for a ecomerce store, created an api using django rest framework, then learn html, css, javascript, and vuejs. build a front end . put my store on the cloud, created a resume and applied to be a full stack web developer. Now i make 100K year in new york city. Im 22 with no college debt. All thanks to this video.
Fadhal Fatani Happens all the time mate...who listens to the boring lectures in the class?we understand better when WE are actually searching for a particular information than someone actually trying to shove some information into our brains.
Business Rule# 4 needs to be adjusted. It actually reads: An employee can be assigned to many projects, and, a project can be assigned to only one employee. The cardinality between the Project and Assignment entities should be turned around and have the minimum cardinality added. My guess is that this was done in Visio 2010. It has some sort of a bug when creating cardinality.
This video was FANTASTIC. Your portrayal of a true-to-life example and your combined use of multimedia, humor, and acting to teach and demonstrate was instrumental to getting the point across. I love the "total amateur" approach, and how it was neatly broken down and explained in understandable terms. Very helpful.
I friggin love this so much,I wish we can learn like this in a university where they would teach us step by step.Professors assume once you've grown up we should learn and act like boring adults.I wish they could teach us learn Database and Computer Science in university like kindergartens.
Aiman Rockefeller Then you should not be at University if you need concepts explained at this level, in-fact you have completely misunderstood what a University is for. RESEARCH SKILLS.............
Mikeeey S Look if you cannot keep up....... They are paid to teach research skills in their given area of expertise. If you honestly believe they are there to 'parrot' teach what they know... then I would suspect you did not progress past primary/secondary school learning level.
Mikeeey S You are poorly informed on at least two points: 1. I have never attended university "No, that's what school is for, school teaches you through various assignments how to do research on your own. It's no different in University," 2. If you think that doing an assignment a school qualifies as research... well that is just sad. There is a big difference between the 'research' of picking colored pencils for a graph and citing peer reviewed articles.
Mikeeey S I think it is better you quit whilst you are 'ahead'........ We can add a third criteria . You obviously have no concept of research skills or the purpose of 'citation' .... but good luck with your 'citethisforme'... I'm off to watch sponge bob... maybe the chance for some intelligent feedback.
Thank you even though how many years this video has been published, it helped many people every year. I hope you guys did not stopped making videos about IT/CS stuff. Both of you are very well spoken and your enunciation is superb I can understand. I did not understand our teacher but after watching your video, all my confusion is gone. Passion on things are really different.
Great video! You really broke down a confusing topic into easy to understand, manageable pieces. This really helped me understand the concepts of ERDs a lot better than what I was kind of gleaning from my text.
AMAZING! this video explains the first two weeks of headache I have been having trying to comprehend several chapters out of the text books. This class would be so much easier if I watched this video on day one!!
I'm not sure if this was a class assignment or what, but it is VERY well executed. It's clear and concise. Full of information and communicated in an engaging and easy to follow way. Excellent work!
Thank you Gina for this video tutorial! It creatively explained the topic with good inforgraphics and helped me to summarize 50% of a semester. Hope you continue such good work and help more folks to understand the concepts with creative infographics like this.
I liked that the other person was asking questions and how they were answered and explained. The video helped me out a lot. If you do more videos like this, I will definitely subscribe.
I've had at least 2 weeks worth of lessons about this and this short 15 minute video is a million times better to understand. my god is my teacher useless. great video, really helped a LOT
Gina B., Kristen T.; Marielle S.; Thank you very much for this presentation because it is the shiznit. I have seen ERD in filemaker Pro books and that is the first time that I have found a concise explanation on how the ERD works and especially the CROW's Feet Symbols with their respective meanings… CHEERS!
Thank you so so much it Really helpped me do my assignment.. This is the best Video on ERD I found already. Instructors really need to use this in class or recommended for the online students. Great Job
I think that even if the final question was wrong, i still had a pretty darn good understanding of the entire design process. Thanks a lot for the video. still helpful in 2017
14:36 Diagram B is wrong for "An employee can be assigned to many projects, however a single project can have multiple employees assigned to it". When you create an associative entity there are certain rules that must be followed. Box (one, mandatory one)-------(X, many)Associative Entity (Many, X)------(One, Mandatory) Box . X depends on the business rule but the other ones don't change.
Thanks for explaining this in an easy-to-understand manner. I took notes and now I feel a lot better when working with ERDs. Now if only I were fluent in ERDish :P
Great video. I really liked quiz part. Do more examples like this, but go in depth and hard examples. I hope you read this comment. Signing of thank you for the video.
Hi Gina thank you so much for posting this video. it helps me a lot keep clam and you explain more about data flow digram , ERD you are doing the best job
This is so awesome and so well described that i wonder why i gotta sit in a class for 3 hours plus just to understand it all when its a ll concluded in 15 minutes. great stuff guys
No doubt it is a very well done lecture. I just want to correct for future learners that @10:09 this is a SuperType/SubType Scenario and so there is a mistake in it. It is an IS-A relation and the min/max cardinality on both sides is one-and-only-one. As you can see when the subtypes (Undergraduate/Graduate) using the primary key from Student table and doesn't have their own primary, it actually says that "Undergraduate/Graduate IS-A Student". And Primary Keys are Unique, so once a subtype instance relates to a StudentID of an instance of a supertype then there is no possibility for any other subtype instance to relate to that same StudentID. At @11:34, this diagram is corrected for Hourly_Employee and Salary_Employee. But again a mistake on Assignment table, it should be one-to-many from both sides.
i like the idea of using a dialogue between two characters to convey complicated information :) socrates and plato would be proud. well done and thanks for helping me figure this out
The way video is presented is really outstanding. A naive user will definitely helpful after seeing this video. I am taking the video presentation as a template :) .
I feel this is the most clear and effective UA-cam video on database ER diagram out there.And I cant believe that this was made 10 years ago
tells you how low quality the youtube courses became
this 15 min video made so much more sense than the $200 text book I've been reading for 2 days.
+Desirae Freedman YUP! Had the same issues when learning first, second, and third normal form.
+Desirae Freedman I agree! But, my.. that's one heck of text book for 200 bucks!
All textbooks concerning databases material in a college setting cost this much easily if not more, I had a Database book that cost over $300, Of course I bought a used one, no way in the world am I paying $300.
this 15 min video made so much more sense than my whole 4 months semester
Lean Teong me too lol made more sense than my whole 4 months semester
I dropped out of college after my first semester, went home watched this video, created and ERD, than picked up python, django, created a backend for a ecomerce store, created an api using django rest framework, then learn html, css, javascript, and vuejs. build a front end . put my store on the cloud, created a resume and applied to be a full stack web developer. Now i make 100K year in new york city. Im 22 with no college debt. All thanks to this video.
Wholesome
No college degree?
Seriously?
3 boring hours of university classes about Database shorten in 15 min.
Thank you
Fadhal Fatani Happens all the time mate...who listens to the boring lectures in the class?we understand better when WE are actually searching for a particular information than someone actually trying to shove some information into our brains.
Sharan V sometimes it's better to sit thru a boring 3 hour lecture then get partial knowledge from stuff on the Internet.
slothc well that depends on the subject and the lecturer. I've seen enough of it
I agree
I learned more in these 15 minutes than a month in my current database class. Great video, many thanks to the creator(s)!
Same here!!!
Universities should hire you. I've never seen learning made so simple the way you have done it. Awesome job, wish i had this years ago.
Just this 1 video is better than my teacher or the textbook
same!
Business Rule# 4 needs to be adjusted. It actually reads: An employee can be assigned to many projects, and, a project can be assigned to only one employee.
The cardinality between the Project and Assignment entities should be turned around and have the minimum cardinality added. My guess is that this was done in Visio 2010. It has some sort of a bug when creating cardinality.
yeah true..I was breaking my head on this and suddenly saw your comment and makes sense.
Why do they charge us thousands to learn this when you can find it on youtube for free ?
you pay for a paper not the knowledge
Because they know people are just gonna get a scholarship or loan since they're forced to buy anyways, so they might as well blow up the price.
capitalism
You pay for the testing, and having someone verified vouch for you.
It also makes sure there's at least some sort of standard in the field.
@@niemaszglowy reality hits harder.
This video was FANTASTIC. Your portrayal of a true-to-life example and your combined use of multimedia, humor, and acting to teach and demonstrate was instrumental to getting the point across. I love the "total amateur" approach, and how it was neatly broken down and explained in understandable terms. Very helpful.
I friggin love this so much,I wish we can learn like this in a university where they would teach us step by step.Professors assume once you've grown up we should learn and act like boring adults.I wish they could teach us learn Database and Computer Science in university like kindergartens.
Aiman Rockefeller
Then you should not be at University if you need concepts explained at this level, in-fact you have completely misunderstood what a University is for.
RESEARCH SKILLS.............
Mikeeey S
Look if you cannot keep up.......
They are paid to teach research skills in their given area of expertise.
If you honestly believe they are there to 'parrot' teach what they know... then I would suspect you did not progress past primary/secondary school learning level.
Mikeeey S
You are poorly informed on at least two points:
1. I have never attended university
"No, that's what school is for, school teaches you through various assignments how to do research on your own. It's no different in University,"
2. If you think that doing an assignment a school qualifies as research... well that is just sad.
There is a big difference between the 'research' of picking colored pencils for a graph and citing peer reviewed articles.
Mikeeey S
I think it is better you quit whilst you are 'ahead'........
We can add a third criteria .
You obviously have no concept of research skills or the purpose of 'citation' ....
but good luck with your 'citethisforme'...
I'm off to watch sponge bob... maybe the chance for some intelligent feedback.
Thank you so much I am taking a database design class and these diagrams have been tough for me, this actually makes sense!!
I can't begin to tell you how much this video has helped me with my course. Thanks a million!!
Brilliant job. The dialogues was very important. Posed the questions and answered the questions.
paid £9000 for a year at university and this genius sums up everything in 15 mins .. THANK YOU SO MUCH
I think you guys just saved my ass
This is the best type of explanation I have ever seen!! Thank you :)
Thank you so much. 2 months of stupid sites and tuts and all I needed was your video.
Who else is spending there time learning during COVID? Super clear and easy to digest video. Very well done.
I feel like a 2 yr old watching dora the explorer when I watch this video.
Haha I was thinking this and then I saw this comment. xD
Thank you even though how many years this video has been published, it helped many people every year. I hope you guys did not stopped making videos about IT/CS stuff. Both of you are very well spoken and your enunciation is superb I can understand. I did not understand our teacher but after watching your video, all my confusion is gone. Passion on things are really different.
I'm coming back to DBA after a few years, this is an amazing summary to refresh my mind. Great work.
Fantastic! Saved me a shitload for my exam tomorrow👌🏾👌🏾
Soooooo how did you go =)))??
Why is it that i find the most useful videos right after the midterm... Excellent video! Earned my subscription.
This was actually really helpful and not boring (unlike a lot of other videos on the topic) Thanks!
I aced it! Great lesson. I missed that class and don't want to go back to school just for this. Much more explanatory and efficient. Thank you.
As a non-computer science background, this was very easy to understand. Thank you!
Why can't textbooks be written by people like this ^.
Great video Gina. I'm a person who doesn't like database but now I can understand how simple it is. Thank you for making the video so enjoyable.
Love it - made things much easier to understand and liked the little quiz at the end to see if I really did understand it.
The greatest video of all time.....(on the subject of entity relationship diagrams).
Gina you're the bomb. You have done a solid for humanity here.
I love this! Sure, it can be a bit corny with all the talking but at the same time that's what makes it great!
You just turned 4 weeks of a boring Professors lectures obsolete in a 15 min video. God Bless you and thank you
I'm writing an information systems test on Tuesday...... This video REALLY explained a lot!!!
i love you. this vid makes my life so much easier. if my professor talks like this i wouldn't have a hard time listening to the lectures
The second gal has a really soothing voice and her pronunciation was super clear.
ew freak haha...
Great video! You really broke down a confusing topic into easy to understand, manageable pieces. This really helped me understand the concepts of ERDs a lot better than what I was kind of gleaning from my text.
AMAZING! this video explains the first two weeks of headache I have been having trying to comprehend several chapters out of the text books. This class would be so much easier if I watched this video on day one!!
I normally do not comment on videos, but this is awesome. Looks like you can evaluate others' minds in terms of how they learn easily.
This is the best youtube tutorial of any sort!!! Great Work!
Great video, I could never really understand ERs until this vid.
This was helpful 9 years later! Thanks. I hope all is well.
I'm not sure if this was a class assignment or what, but it is VERY well executed. It's clear and concise. Full of information and communicated in an engaging and easy to follow way. Excellent work!
Love the way you made this conversation that make us easy to understand things. Thumbs Up.
one of the most helpful video tutorials I've ever seen. i loved that Quiz part. I've
answered all of them correctly. thnx so much for dis video
Thanks girls. Yall saved me from purchasing a $200 book. I'm more of a visual learner anyways and this helped a great deal. Thanks again.
Thank you Gina for this video tutorial! It creatively explained the topic with good inforgraphics and helped me to summarize 50% of a semester. Hope you continue such good work and help more folks to understand the concepts with creative infographics like this.
Perfect. Listened to it 5 times. I’m ready to not fail
There is no any Expiration date for these video !!! I loved !
Great job on this video... Easy to understand and follow even though there are some fairly difficult database elements contained. Thanks!
I liked that the other person was asking questions and how they were answered and explained. The video helped me out a lot. If you do more videos like this, I will definitely subscribe.
I've had at least 2 weeks worth of lessons about this and this short 15 minute video is a million times better to understand.
my god is my teacher useless. great video, really helped a LOT
Gina you need to make more videos girl. This was great!
Gina B., Kristen T.; Marielle S.;
Thank you very much for this presentation because it is the shiznit.
I have seen ERD in filemaker Pro books and that is the first time that I have found a concise explanation on how the ERD works and especially the CROW's Feet Symbols with their respective meanings…
CHEERS!
Thanks alot..for avery short & sweet explanation.This is the best vedio that I've ever seen in this topic(ERD).
Thank you, this video has cleared my doubts about ERD.
I learned more from you then from a MOOC lesson. Thank you.
Thank you so so much it Really helpped me do my assignment.. This is the best Video on ERD I found already. Instructors really need to use this in class or recommended for the online students. Great Job
you teach so well....i like the way you have the conversation with the student
Keep this up you're one of the best Ive seen.
I think that even if the final question was wrong, i still had a pretty darn good understanding of the entire design process. Thanks a lot for the video. still helpful in 2017
14:36
Diagram B is wrong for "An employee can be assigned to many projects, however a single project can have multiple employees assigned to it". When you create an associative entity there are certain rules that must be followed. Box (one, mandatory one)-------(X, many)Associative Entity (Many, X)------(One, Mandatory) Box . X depends on the business rule but the other ones don't change.
Great job ladies, make more IT video's please!
This is for the first time I am commenting on any video. Loved the way of your explanation. Grt work...
This is an AMAZING explanation, I can't believe its free.
I have a test today on this and your video is helping a lot thanks a million !!!!
wow I just learn this today in class and come here to learn more.. and it;s really helpful. Thank you
Im trying to get into database modelling, and I just had to say, your video is a lifesaver!!
Good job :)
Thanks for explaining this in an easy-to-understand manner. I took notes and now I feel a lot better when working with ERDs. Now if only I were fluent in ERDish :P
Great video. I really liked quiz part. Do more examples like this, but go in depth and hard examples. I hope you read this comment. Signing of thank you for the video.
great tutorial love it and i have 500 students who love it so much.Short and useful.
Thank you very much for creating such a short vedio which explains everything crystal clear.
you're WAAAAAAAAAAY better in explaining this than my teacher! Plus you have a kewl voice
It's like a TOEFL lecture. Very helpful :D
Hi Gina thank you so much for posting this video. it helps me a lot keep clam and you explain more about data flow digram , ERD you are doing the best job
Great presentation. Made it very clear and Easy to Understand. Thanks.
very very very helpful thank you and hoping to see more videos of these by you guys
This is so awesome and so well described that i wonder why i gotta sit in a class for 3 hours plus just to understand it all when its a ll concluded in 15 minutes. great stuff guys
I have a database exam tomorrow and i cant believe i am being helped by a 11 year old video
2 years later, its still awesome!
Hey just want to let you know this was a great job of explaining erd!
Super video..simple and sweet.. all the things covered in a simple way..thanks lot..
Best ERD learning video ever . you guys should help us with normalization too . !
one of the best ERD VIDEOS on youtube. but so sad this is the only video from Gina. pls make more video .Thanks
Thank you so much only because of you now i can prepare for my presentation in my collage... Thanks a lot
I never thought I would laugh while watching a video on database diagrams...
No doubt it is a very well done lecture. I just want to correct for future learners that @10:09 this is a SuperType/SubType Scenario and so there is a mistake in it. It is an IS-A relation and the min/max cardinality on both sides is one-and-only-one. As you can see when the subtypes (Undergraduate/Graduate) using the primary key from Student table and doesn't have their own primary, it actually says that "Undergraduate/Graduate IS-A Student". And Primary Keys are Unique, so once a subtype instance relates to a StudentID of an instance of a supertype then there is no possibility for any other subtype instance to relate to that same StudentID.
At @11:34, this diagram is corrected for Hourly_Employee and Salary_Employee. But again a mistake on Assignment table, it should be one-to-many from both sides.
i like the idea of using a dialogue between two characters to convey complicated information :) socrates and plato would be proud. well done and thanks for helping me figure this out
Excellent video, the questions at the latter segment of the video was an awesome touch!
Keep up the great job!
You have make my life much easier 😍👏
"Relationships? Are they gonna hold hands?"
"Ha ha ha ha! Not that kind of relationship"
The way video is presented is really outstanding. A naive user will definitely helpful after seeing this video. I am taking the video presentation as a template :) .
The presentation style is creative and enjoyable.
I don't know who you are... I don't know where you're from but this video was genius thanks you
Super tutorial, many thanks for your help! Keep up the excellent teaching skills. Very well presented!
Good job. I like these kind of videos. Very good explanation.
10yrs old video solve my problem in RDBMS haha thank you so much
You did a great job with this video. Very great teaching method. I really appreciated this.
THANK YOU SOO MUCH
Ive been struggling to understand my instructor.
Now I can do my final exam with clear mind