Entity Relationship Diagram (ERD) Training Video

[@desiraefreedman4791]

this 15 min video made so much more sense than the $200 text book I've been reading for 2 days.

[@subpar3398]

+Desirae Freedman YUP! Had the same issues when learning first, second, and third normal form.

[@leolallana]

+Desirae Freedman I agree! But, my.. that's one heck of text book for 200 bucks!

[@philblair8591]

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.

[@damnt3iktai]

this 15 min video made so much more sense than my whole 4 months semester

[@johnnybeats1404]

Lean Teong me too lol made more sense than my whole 4 months semester

[@friccarlo]

I feel this is the most clear and effective KZbin video on database ER diagram out there.And I cant believe that this was made 10 years ago

[@kertosyt]

tells you how low quality the youtube courses became

[@CastroWebSolution]

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.

[@Babblingbrooke101]

Wholesome

[@cheesenutz3854]

No college degree?

[@tegathemenace]

Seriously?

[@fadlooola]

3 boring hours of university classes about Database shorten in 15 min. Thank you

[@sharanv9182]

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.

[@slothc]

Sharan V sometimes it's better to sit thru a boring 3 hour lecture then get partial knowledge from stuff on the Internet.

[@sharanv9182]

slothc well that depends on the subject and the lecturer. I've seen enough of it

[@shetuamin]

I agree

[@saucecat1]

I learned more in these 15 minutes than a month in my current database class. Great video, many thanks to the creator(s)!

[@nancyndinda8474]

Same here!!!

[@billsergio6597]

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.

[@4bitmultiplexer]

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.

[@rangisettyrajkumar]

yeah true..I was breaking my head on this and suddenly saw your comment and makes sense.

[@Omni_G]

Just this 1 video is better than my teacher or the textbook

[@dartwary318]

same!

[@xPanzerschreck]

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.

[@flashforensics]

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.............

[@flashforensics]

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.

[@flashforensics]

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.

[@flashforensics]

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.

[@sablephoenix4rce]

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.

[@WillemvanderPijl]

I think you guys just saved my ass

[@sims-ek5ph]

paid £9000 for a year at university and this genius sums up everything in 15 mins .. THANK YOU SO MUCH

[@SarahPaine]

Thank you so much I am taking a database design class and these diagrams have been tough for me, this actually makes sense!!

[@TheGameconomist]

Why do they charge us thousands to learn this when you can find it on youtube for free ?

[@niemaszglowy]

you pay for a paper not the knowledge

[@HandledToaster2]

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.

[@Gh0st652]

capitalism

[@Fireprincess161]

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.

[@kolibri5861]

@@niemaszglowy reality hits harder.

[@ibuykx9956]

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.

[@jacobadeoye8372]

Brilliant job. The dialogues was very important. Posed the questions and answered the questions.

[@3litepker]

I feel like a 2 yr old watching dora the explorer when I watch this video.

[@DjNitemayr]

Haha I was thinking this and then I saw this comment. xD

[@anjaresnick2942]

I can't begin to tell you how much this video has helped me with my course. Thanks a million!!

[@kshitijkulkarni8698]

This is the best type of explanation I have ever seen!! Thank you :)

[@pascalpixel3887]

Thank you so much. 2 months of stupid sites and tuts and all I needed was your video.

[@ktadamsII]

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!!

[@TheLKStar]

I'm coming back to DBA after a few years, this is an amazing summary to refresh my mind. Great work.

[@girohead]

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.

[@johndoe-ev8ot]

The second gal has a really soothing voice and her pronunciation was super clear.

[@stevodoe4900]

ew freak haha...

[@samviner95]

You just turned 4 weeks of a boring Professors lectures obsolete in a 15 min video. God Bless you and thank you

[@nathanyost15]

Why can't textbooks be written by people like this ^.

[@BenjaminAdebowale]

I'm writing an information systems test on Tuesday...... This video REALLY explained a lot!!!

[@michelleodo2356]

Fantastic! Saved me a shitload for my exam tomorrow👌🏾👌🏾

[@chivinguyen3348]

Soooooo how did you go =)))??

[@joch3085]

Why is it that i find the most useful videos right after the midterm... Excellent video! Earned my subscription.

[@vancityexe]

Who else is spending there time learning during COVID? Super clear and easy to digest video. Very well done.

[@MoreMusicXx]

As a non-computer science background, this was very easy to understand. Thank you!

[@BaileysLetsPlay]

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

[@xDARKVEGETAx]

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.

[@memorylanezz]

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.

[@sage-mode]

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.

[@scleas]

Love it - made things much easier to understand and liked the little quiz at the end to see if I really did understand it.

[@ClashWithFalcon]

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

[@davidmax1816]

There is no any Expiration date for these video !!! I loved !

[@TheCanadianGuitar]

Gina you're the bomb. You have done a solid for humanity here.

[@unclespinnydervish2471]

The greatest video of all time.....(on the subject of entity relationship diagrams).

[@MrTanker10a]

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!

[@oscarbackdahl2247]

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!

[@madhurikamma5750]

Thanks alot..for avery short & sweet explanation.This is the best vedio that I've ever seen in this topic(ERD).

[@Ramule56]

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!

[@tylerreeves8690]

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.

[@kateminogue3155]

This was actually really helpful and not boring (unlike a lot of other videos on the topic) Thanks!

[@ranessabaker2321]

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

[@RajatDhakal]

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.

[@fishamit]

"Relationships? Are they gonna hold hands?" "Ha ha ha ha! Not that kind of relationship"

[@epicwhat001]

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

[@syedburhanalishah1631]

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.

[@vela1247]

Gina you need to make more videos girl. This was great!

[@sleepingengineer4091]

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

[@mon18shan]

wow I just learn this today in class and come here to learn more.. and it;s really helpful. Thank you

[@iowbuvr]

I never thought I would laugh while watching a video on database diagrams...

[@Jazzman210]

I don't know who you are... I don't know where you're from but this video was genius thanks you

[@motown75]

Great job on this video... Easy to understand and follow even though there are some fairly difficult database elements contained. Thanks!

[@jcdeaton42]

This was helpful 9 years later! Thanks. I hope all is well.

[@rashedfaruq905]

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.

[@fouludeleon9159]

you're WAAAAAAAAAAY better in explaining this than my teacher! Plus you have a kewl voice

[@snypperkyller]

Great video, I could never really understand ERs until this vid.

[@mystikdragon9457]

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.

[@MrTactics26]

Perfect. Listened to it 5 times. I’m ready to not fail

[@laibamasood6777]

Thank you, this video has cleared my doubts about ERD.

[@Wthisthishandler]

i'm really fucked where did the semester go ? fuck fuck fuck fuck...

[@lyol1001]

Brian Phiri This was us last week lol

[@phiribrian]

Haha Colinz Mwangi I don't miss it .

[@kcampbell9248]

literally same #fuck

[@phiribrian]

Colinz Mwangi​ post project management videos lol

[@stefanmarjanovic4768]

This guy.. saying what we're all thinking

[@shiromadahanayake]

Thank you very much for creating such a short vedio which explains everything crystal clear.

[@angelaodero6797]

you teach so well....i like the way you have the conversation with the student

[@troglodyto]

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

[@jameses1221]

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

[@farhanmirza3090]

Thank you so much only because of you now i can prepare for my presentation in my collage... Thanks a lot

[@RamaKrishna-ps1xk]

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.

[@risteva5288]

great tutorial love it and i have 500 students who love it so much.Short and useful.

[@arafatrahman2063]

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 :) .

[@ickypalms]

2 years later, its still awesome!

[@angiewhite8760]

10:09 - I spotted a mistake. I guess it was supposed to be one-to-one relationship between Student and Graduate-Undergraduate entities. You also stated this when you first showcased the schema at 2:02. Otherwise, StudentID cannot be a primary key. A huge shout out to you for this video though!

[@ambassadorgt]

one of the best ERD VIDEOS on youtube. but so sad this is the only video from Gina. pls make more video .Thanks

[@AO-lo6je]

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

[@THeSIPHO1]

I have a test today on this and your video is helping a lot thanks a million !!!!

[@pepitoperez2865]

It's like a TOEFL lecture. Very helpful :D

[@dipakagarwal5052]

This is for the first time I am commenting on any video. Loved the way of your explanation. Grt work...

[@celestusplatinum5131]

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

[@leolallana]

I wish I can see both of you. I have this itch to visualize the person I'm hearing so that I can associate them with their faces. This tends to add more retention for me. But still, very informative video and well explained in human words. Haha. Thanks a bunch! :)

[@yousefharsi5926]

THANK YOU SOO MUCH Ive been struggling to understand my instructor. Now I can do my final exam with clear mind

[@AlMasumFahim027]

tried to learn the basics of ERD. learned in 15 minutes :D Thanks a lot

[@shaikfroz3848]

Loved this video sooooooooooooooo much.... finally i'v got clear idea of ERD after a long search of videos to learn... :) thank you so much.. you guys really Rocks..

[@Johny123B]

Great presentation. Made it very clear and Easy to Understand. Thanks.

[@secretnobody6460]

I have a database exam tomorrow and i cant believe i am being helped by a 11 year old video

[@kushancharaka7540]

Super video..simple and sweet.. all the things covered in a simple way..thanks lot..

[@skmuin1563]

This is the best youtube tutorial of any sort!!! Great Work!

[@Mandaragat1969]

10yrs old video solve my problem in RDBMS haha thank you so much

[@SohaibDanishOfficial]

Love the way you made this conversation that make us easy to understand things. Thumbs Up.

[@ThePersBoy]

Great job ladies, make more IT video's please!

[@waleedmohamed4104]

Wonderful video for training. Everything in just 15 min.

[@MrErichi911]

Wow... very good explanation and great example cases. thank you for the video.

[@dead94man]

very very very helpful thank you and hoping to see more videos of these by you guys

[@AbrarKhan-eu5ok]

Best ERD learning video ever . you guys should help us with normalization too . !

[@jaym4229]

I liked your video it will help me in my exam, it was easy and simple I was looking for this kind of videos, thank you!!

[@batyrenko]

You have mistake on about 11.32. Relationship between Assignment and Project - One to Many - is not correct. In this case your Project table will have not unique Key - Project ID. Relation has to be Many (Assignment) to One (Project). Each project has only one record in table Project - description of the project. But using assignment table, you can assign a lot of employee to the same project and a lot of projects to the same employee. As result we have relationship between Employee - Project = Many to Many. If I am nor right, please, correct. Thanks! p.s. on more mistake: on 10.48 you show this rule. And not correct answer in Quiz on 14.49.

[@artexfyne8122]

Girls just regurgitate words that sounds rational

[@timboyadjian2231]

Andrew is correct

[@PierLim]

Yes I think you are correct for this. This is repeated again in 14:34, I think!

[@johnvak7390]

Wow they dont teach like this anymore... Time has changed and this video made it so easy to understand

[@whitneyparsons3009]

Taught me more than the 14 chapters of my text book...