this 15 min video made so much more sense than the $200 text book I've been reading for 2 days.
@subpar33988 жыл бұрын
+Desirae Freedman YUP! Had the same issues when learning first, second, and third normal form.
@leolallana8 жыл бұрын
+Desirae Freedman I agree! But, my.. that's one heck of text book for 200 bucks!
@philblair85918 жыл бұрын
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.
@damnt3iktai7 жыл бұрын
this 15 min video made so much more sense than my whole 4 months semester
@johnnybeats14047 жыл бұрын
Lean Teong me too lol made more sense than my whole 4 months semester
@friccarlo10 ай бұрын
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
@kertosyt7 ай бұрын
tells you how low quality the youtube courses became
@CastroWebSolution5 жыл бұрын
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.
@Babblingbrooke1017 ай бұрын
Wholesome
@cheesenutz38544 ай бұрын
No college degree?
@tegathemenace2 ай бұрын
Seriously?
@fadlooola9 жыл бұрын
3 boring hours of university classes about Database shorten in 15 min. Thank you
@sharanv91829 жыл бұрын
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.
@slothc9 жыл бұрын
Sharan V sometimes it's better to sit thru a boring 3 hour lecture then get partial knowledge from stuff on the Internet.
@sharanv91829 жыл бұрын
slothc well that depends on the subject and the lecturer. I've seen enough of it
@shetuamin4 жыл бұрын
I agree
@saucecat111 жыл бұрын
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!!!
@billsergio659710 жыл бұрын
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.
@4bitmultiplexer10 жыл бұрын
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.
@rangisettyrajkumar6 ай бұрын
yeah true..I was breaking my head on this and suddenly saw your comment and makes sense.
@Omni_G8 жыл бұрын
Just this 1 video is better than my teacher or the textbook
@dartwary3183 жыл бұрын
same!
@xPanzerschreck9 жыл бұрын
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.
@flashforensics9 жыл бұрын
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.............
@flashforensics9 жыл бұрын
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.
@flashforensics9 жыл бұрын
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.
@flashforensics9 жыл бұрын
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.
@sablephoenix4rce10 жыл бұрын
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.
@WillemvanderPijl8 жыл бұрын
I think you guys just saved my ass
@sims-ek5ph7 жыл бұрын
paid £9000 for a year at university and this genius sums up everything in 15 mins .. THANK YOU SO MUCH
@SarahPaine10 жыл бұрын
Thank you so much I am taking a database design class and these diagrams have been tough for me, this actually makes sense!!
@TheGameconomist8 жыл бұрын
Why do they charge us thousands to learn this when you can find it on youtube for free ?
@niemaszglowy4 жыл бұрын
you pay for a paper not the knowledge
@HandledToaster24 жыл бұрын
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.
@Gh0st6524 жыл бұрын
capitalism
@Fireprincess1613 жыл бұрын
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.
@kolibri58613 жыл бұрын
@@niemaszglowy reality hits harder.
@ibuykx99563 жыл бұрын
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.
@jacobadeoye83723 жыл бұрын
Brilliant job. The dialogues was very important. Posed the questions and answered the questions.
@3litepker10 жыл бұрын
I feel like a 2 yr old watching dora the explorer when I watch this video.
@DjNitemayr10 жыл бұрын
Haha I was thinking this and then I saw this comment. xD
@anjaresnick29425 жыл бұрын
I can't begin to tell you how much this video has helped me with my course. Thanks a million!!
@kshitijkulkarni869810 жыл бұрын
This is the best type of explanation I have ever seen!! Thank you :)
@pascalpixel38877 жыл бұрын
Thank you so much. 2 months of stupid sites and tuts and all I needed was your video.
@ktadamsII9 жыл бұрын
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!!
@TheLKStar7 жыл бұрын
I'm coming back to DBA after a few years, this is an amazing summary to refresh my mind. Great work.
@girohead7 жыл бұрын
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-ev8ot9 жыл бұрын
The second gal has a really soothing voice and her pronunciation was super clear.
@stevodoe49006 жыл бұрын
ew freak haha...
@samviner959 жыл бұрын
You just turned 4 weeks of a boring Professors lectures obsolete in a 15 min video. God Bless you and thank you
@nathanyost1510 жыл бұрын
Why can't textbooks be written by people like this ^.
@BenjaminAdebowale8 жыл бұрын
I'm writing an information systems test on Tuesday...... This video REALLY explained a lot!!!
@michelleodo23568 жыл бұрын
Fantastic! Saved me a shitload for my exam tomorrow👌🏾👌🏾
@chivinguyen33484 жыл бұрын
Soooooo how did you go =)))??
@joch308510 жыл бұрын
Why is it that i find the most useful videos right after the midterm... Excellent video! Earned my subscription.
@vancityexe4 жыл бұрын
Who else is spending there time learning during COVID? Super clear and easy to digest video. Very well done.
@MoreMusicXx8 жыл бұрын
As a non-computer science background, this was very easy to understand. Thank you!
@BaileysLetsPlay9 жыл бұрын
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
@xDARKVEGETAx7 жыл бұрын
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.
@memorylanezz7 жыл бұрын
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-mode8 жыл бұрын
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.
@scleas9 жыл бұрын
Love it - made things much easier to understand and liked the little quiz at the end to see if I really did understand it.
@ClashWithFalcon6 жыл бұрын
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
@davidmax181610 жыл бұрын
There is no any Expiration date for these video !!! I loved !
@TheCanadianGuitar10 жыл бұрын
Gina you're the bomb. You have done a solid for humanity here.
@unclespinnydervish247110 жыл бұрын
The greatest video of all time.....(on the subject of entity relationship diagrams).
@MrTanker10a10 жыл бұрын
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!
@oscarbackdahl224710 жыл бұрын
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!
@madhurikamma575010 жыл бұрын
Thanks alot..for avery short & sweet explanation.This is the best vedio that I've ever seen in this topic(ERD).
@Ramule5611 жыл бұрын
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!
@tylerreeves869010 жыл бұрын
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.
@kateminogue31558 жыл бұрын
This was actually really helpful and not boring (unlike a lot of other videos on the topic) Thanks!
@ranessabaker232110 жыл бұрын
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
@RajatDhakal9 жыл бұрын
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.
@fishamit3 жыл бұрын
"Relationships? Are they gonna hold hands?" "Ha ha ha ha! Not that kind of relationship"
@epicwhat0018 жыл бұрын
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.
@vela12475 жыл бұрын
Gina you need to make more videos girl. This was great!
@sleepingengineer40918 жыл бұрын
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
@mon18shan10 жыл бұрын
wow I just learn this today in class and come here to learn more.. and it;s really helpful. Thank you
@iowbuvr7 жыл бұрын
I never thought I would laugh while watching a video on database diagrams...
@Jazzman2108 жыл бұрын
I don't know who you are... I don't know where you're from but this video was genius thanks you
@motown759 жыл бұрын
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.
@rashedfaruq9055 жыл бұрын
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.
@fouludeleon91598 жыл бұрын
you're WAAAAAAAAAAY better in explaining this than my teacher! Plus you have a kewl voice
@snypperkyller9 жыл бұрын
Great video, I could never really understand ERs until this vid.
@mystikdragon945710 жыл бұрын
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.
@MrTactics262 жыл бұрын
Perfect. Listened to it 5 times. I’m ready to not fail
@laibamasood67777 ай бұрын
Thank you, this video has cleared my doubts about ERD.
@Wthisthishandler10 жыл бұрын
i'm really fucked where did the semester go ? fuck fuck fuck fuck...
@lyol100110 жыл бұрын
Brian Phiri This was us last week lol
@phiribrian10 жыл бұрын
Haha Colinz Mwangi I don't miss it .
@kcampbell92489 жыл бұрын
literally same #fuck
@phiribrian9 жыл бұрын
Colinz Mwangi post project management videos lol
@stefanmarjanovic47686 жыл бұрын
This guy.. saying what we're all thinking
@shiromadahanayake5 жыл бұрын
Thank you very much for creating such a short vedio which explains everything crystal clear.
@angelaodero67974 ай бұрын
you teach so well....i like the way you have the conversation with the student
@troglodyto7 жыл бұрын
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
@jameses12217 жыл бұрын
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
@farhanmirza30909 жыл бұрын
Thank you so much only because of you now i can prepare for my presentation in my collage... Thanks a lot
@RamaKrishna-ps1xk5 жыл бұрын
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.
@risteva528810 жыл бұрын
great tutorial love it and i have 500 students who love it so much.Short and useful.
@arafatrahman206310 жыл бұрын
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 :) .
@ickypalms8 жыл бұрын
2 years later, its still awesome!
@angiewhite87606 жыл бұрын
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!
@ambassadorgt11 жыл бұрын
one of the best ERD VIDEOS on youtube. but so sad this is the only video from Gina. pls make more video .Thanks
@AO-lo6je9 жыл бұрын
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
@THeSIPHO18 жыл бұрын
I have a test today on this and your video is helping a lot thanks a million !!!!
@pepitoperez28657 жыл бұрын
It's like a TOEFL lecture. Very helpful :D
@dipakagarwal50529 жыл бұрын
This is for the first time I am commenting on any video. Loved the way of your explanation. Grt work...
@celestusplatinum51316 жыл бұрын
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
@leolallana8 жыл бұрын
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! :)
@yousefharsi592610 жыл бұрын
THANK YOU SOO MUCH Ive been struggling to understand my instructor. Now I can do my final exam with clear mind
@AlMasumFahim0279 жыл бұрын
tried to learn the basics of ERD. learned in 15 minutes :D Thanks a lot
@shaikfroz38488 жыл бұрын
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..
@Johny123B10 жыл бұрын
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
@kushancharaka75407 жыл бұрын
Super video..simple and sweet.. all the things covered in a simple way..thanks lot..
@skmuin15636 жыл бұрын
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
@SohaibDanishOfficial8 жыл бұрын
Love the way you made this conversation that make us easy to understand things. Thumbs Up.
@ThePersBoy8 жыл бұрын
Great job ladies, make more IT video's please!
@waleedmohamed410410 жыл бұрын
Wonderful video for training. Everything in just 15 min.
@MrErichi9117 жыл бұрын
Wow... very good explanation and great example cases. thank you for the video.
@dead94man8 жыл бұрын
very very very helpful thank you and hoping to see more videos of these by you guys
@AbrarKhan-eu5ok8 жыл бұрын
Best ERD learning video ever . you guys should help us with normalization too . !
@jaym42299 жыл бұрын
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!!
@batyrenko8 жыл бұрын
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.
@artexfyne81228 жыл бұрын
Girls just regurgitate words that sounds rational
@timboyadjian22318 жыл бұрын
Andrew is correct
@PierLim5 жыл бұрын
Yes I think you are correct for this. This is repeated again in 14:34, I think!
@johnvak73902 ай бұрын
Wow they dont teach like this anymore... Time has changed and this video made it so easy to understand
@whitneyparsons300910 жыл бұрын
Taught me more than the 14 chapters of my text book...