Database Schema
Вставка
- Опубліковано 17 жов 2024
- How to draw a diagram representing the entities, relationships and fields of a relational database.
If this video helped you, you may also benefit from these further examples of constructing database schema:
• Loans Database: Identi... - identifying the tables in a given situation
• Loans Database: Buildi... - building the schema and determining the relationships
I'm Mr. Woo and my channel is all about learning - I love doing it, and I love helping others to do it too. I guess that's why I became a teacher! I hope you get something out of these videos - I upload almost every weekday, so subscribe to find out when there's something new!
For categorised playlists: www.misterwootu...
Main channel: / misterwootube
Discussion: / misterwootube
Worksheets and other resources: woo.jamesruse.n...
I'm studying to be a full stack developer and being that I'm self taught the material is tricky. There's no shortage of free educational material in virtually any subject (it just takes dedication to find it). What's hard to find is necessary material delivered in a way that you can not only understand, but understand it easily. You sir accomplish this! Instead of just presenting the information you provide it in an energetic way that allows the student to feel like they naturally understand. Which then allows a student to go from not knowing a subject to being able to replicate it on their own.
Daym, that`s one energetic and inspiring teacher! Imagine a world filled with these kinds of IT-teachers! :)
We would be living in space by now.
ai will make it so
your teaching with energy and method is awesome...
wrr, infix enerx nmw
I love the way you express yourself and you seen a lot passionate talking about the subject.
Of course: I Google for help, and Eddie Woo shows up. Not only does he show up, I'm HAPPY TO SEE he shows up. I know that after the video, I'll understand things better. Dude is just SO helpful.
10 years later and this information is so useful and you taught it so well! I am currently studying for my SAA exam. Thank you!
I must say these videos are about ten times easier to understand than my overly complicated jargon filled uni lectures. Thanks Eddie, wish I had you as my teacher in high school!
Absolutely. I found Eddie Woo while studying entry level pure math at uni, and I'm back four years later when covering entry databases.
The dude is timeless.
For the life of me I have always had a difficult time mastering the concept of what a foreign key and primary keys are. Now I can explain it to others. You have explained it easily, thoroughly and without confusion. Thank you.
My school forced Database Management on us. And expected us to just learn it on our own. -_-
You sir, are a god sent.
I had to watch so many videos until I found this one that explained it so clearly. Thank you.
seeing this 9 years after and the energy in the video is still shocking me
Brother...you are so natural ...with your knowledge.... i wish i could be like you..
Hmm..I agree Sir.. also....was little curious ,do you have any more videos for database...?
I literally just started watching this video and got a splash of all the energy in your teaching method. You're awesome!
I was randomly searching through database tutorials and felt ecstatic to find you've covered one of these things :D
讲得怎么这么好,我为什么现在才看到这个视频!!主要是讲课好帅!!!
one of the best explanations of 'Schema' on UA-cam.
Man, this was literally the best tutorial I watched whole this year! I really mean it man, You taught Database schema the best way possible. Salute to you bro ✌✌❤
I wish this guy was my database management professor. He made my assignment so much more clear.
this video was made 9 years ago yet it is the best explanation I have come across. Awesome!!!
Love these, even 10 years later. Thanks so much!
This the best explanation of this topic that I have seen. It is crystal clear to me now. Thanks Mr. Woo you rock!
I have to admit that I am impressed with your presentation style. I wish I could lecture like you.
***** Not quite. But when it comes to explaining concepts to colleagues and friends, I find it very hard to translate thoughts to words, keep the audience involved. There's a lot of clarity in your speech and your occasional impromptu humor adds to the quality. You're certainly a very good teacher.
omg why are you so underrated huhu. you're so great. it is not complicated that's why i love it. thank youuuu !
May I ask what is the touchscreen that you are using? It could come quite handy in my daily life. Thanks for the video
Just watching random database design videos and clicked on this without looking at the author. I legit was so excited to see Eddie's face! You explain things like no other
I wish you had a SQL/DB playlist. I find it difficult to find more DB videos
ua-cam.com/video/ymb9gsl_x1U/v-deo.html&ab_channel=EddieWoo
@@andrewprimary yayy..thank you
Very helpful i am in a higher education and i was having a little bit of trouble understanding this but this video has helped me a lot. thank you so much professor for your help and keep up the great work.
Wow, great. Eddie, what kind of "whiteboard" are you using doing this video? It's awesome.
Sooo glad I found this, really great teacher here, I read this twice in textbook and still didn't understand like one time watching lecture. Thanks a lot!
This series was really helpful. Thanks alot.
It would be great to see it as a full course.
2 Things:
1) There is no way to distinguish student A from student B granted they share FirstName, LastName, ClassID and POB -> Solution: Use extra field, StudentID
2) When I first started learning Databases I was confusing the theory with the practice
To understand the concept I had to follow a few tutorials of how to create actual databases
Hi Eddie, your explanation was so simple and clear....appreciate you would shed so more topics on database schema's and their relationships....I wanted to clear my all concepts with you....one again thanks for posting such a wonder full video
I'd love an explanation from you on database vs schema vs model vs instance etc. These are confusing.
hope my professor r half of you=.= ur 7 min. worth him the whole class
HAHAHAHAHA
This guy is a gifted teacher.
Please make more lectures on sql.
Your videos are really helpful to understand the concept easily.
Thanks for the video. Brief, concise and a good pace
I easily understood your lesson, it was a nice refresher for me. I'm just here to say that I like your teaching style and I've actually found you first from watching your lessons on mathematical induction so I was surprised when my friend linked me this video (we're working on a project involving databases). Keep up the good work :) I'm sure not enough people do this but I really appreciate you uploading your lessons, some teachers or professors seriously don't explain the topics you upload in such a way that the student can easily understand them.
you are the best teacher in the world :) !!!
you are such a good teacher
I understood everything you said so quickly
He is a good teacher .. good work sir !
We don't have that kind of teaching technology here in the Philippines. Luckily I found your channel. Now I can understand more about our lessons. Thank you Sir. I've watched your video about data flow diagram. Can you make more tutorials please? Our subject is System Analysis and Design and the way of teaching our professor does is not that student friendly. He just read it from his presentation. he don't have actual examples.
I really want to excel in math. That's my weakness. Your videos about math can help me also sir. I hope that the way of teaching here in my country is like the way you teach. Thanks for the immediate reply. God bless.
😍 Eddie has absolutely Woo’d me 😍
Brilliant teacher!! A clear explanation of Schema
The concept was explained well. But another thing that impressed me is how could you use your fingers on board with some application projected on to a screen. Thats amazing..!! Please let me know. Thats very interactive technology you were using in this video.
Hi Mr Eddy. I guess it's a smart board. Just now googled. If I am wrong please do let me know.
where did you get it Eddie??
Love the projector touchscreen thing you have going here!
Eddie, my daughter is going to take the AP (Advanced Placement) Statistics course this fall, she is in Sarasota, Florida, U.S.A at her junior year, I wonder is this the course series you teach that can help her with the course AP Statistics?
S
I'd just like to thank you for this video. My lecturer isn't the best at teaching people but I guess everybody has their strengths. That doesn't mean I can't be annoyed about needing a mandatory 70% attendance to pass the subject.
i love the way you explain the things ... really great.
Xcellent explanation and very simple to understand. Thanks.
Very well explained - class id, primary key foreign key -
dayum man, now that's how an expositor should speak, well done eddie :D
i love your classes
wow, great energy teaching something like this
Simple and easy to understand. Great Video help me lot.
Nicely addressed, great videos, great teacher! Have saved your video list, definitely will come back to watch others later. Thank you very much!
Thanks Eddie ...very well explained in short time!!
Well I always thought I wasn't ever going to make one of these comments but here I am . Thanks a alot sir seriously I have a As level paper tomorrow and this was going straight over my head .
Good and clear video, very helpful
Awesome tutorial, very clear, and good energy from the instructor!
This is owsome. Please what kind of screen is this called?
glad to found this video mr. Eddie, do you have an UML video..? i need it so much, thank you
as a graphic designer who has a web developer job, i specially appreciate this video
great video! just a small question though: which key do the class.teacher and teacher.teacherID have? thanks!
Dunno if you still need the answer but the class.teacher is a foreign key for the teacher table (meaning it needs to have the same data as teacher.teacherID) while the teacher.teacherID would be your primary key for the teacher table I think it kinda got confusing because it would've been better if he used class.teacherID but anyways hope that clears it out :)
What kind of board is that?
I watched some other videos, your style is much easier to follow but it is reinforcing what I learned from those. I feel like im in class answering your questions haha
i'm actually learning about this in my college systems analysis class. thank you for having this video. helps me a ton to understand it.
Well explained. Cheers mate.
This video is really helpful and nicely explained everything.Thanks
What a great teacher!
Well this is what we call learning .Thank you for a great Presentation
Is there any online resource where we can find pre-built schemas?
Thank you, simple and precise!
Could u also show an example of many to many?
Is this mapping always done from right to left?
Thanks
Records produced after joining depend on this mapping?
Thanks
In the relationship between the Class and Teacher table which table contains the foreign key and the primary key?
Excellent way of explanation.
Very simply explained...Keep going!
That's101. Or 100.5, more. But now a university, where students take many classes, or courses with different, simultaneous subcourses. And professors with more than one subject, or 2 professors, teaching the same course, or separate lessons in a single course, etc, etc. Things get more complicated when an ERD grows. Also, you cannot duplicate records (So you can't have Class ID in the Student table when a Student takes more than one class). That's called normalization. And then, this ERD only applies to transactional systems. For analytical systems, or auditable financial system, you have other schemas alltogether.
eddi thanks so much, i just try learning about, for my homepage and try the top. this is the beggining i love it, and i like so much your explain, may you tell me how i can do whit the codes using this ? thank you so much
***** thanks so much eddie for your answer, i talk about schema, im sorry im just begginer, and i dont understand it all.
please please make more videos , there something about you so captivating
Great Video. I've added the the Structural Data, and Google's markup tool shows the info but, my Business's knowledge graph hasn't updated. How can I have the info updated?
Eddie Woo. This was great! Good job.
which thing is ur using to write on the BOARD or touch screen
Thanks, you just made it simple for me, preparing for an exam.
How did you manage to get the desired screens or options just by touching the projected part. Ive never seen that before.
Thats a smart board
well class and teacher is a MANY TO MANY relationship
I'm watching this before my Final and it has helped me a lot. Thanks!
Ey how are you now?
@@v.rprasad5377 I got an A+ on my final thanks to this video
@@captnhotdog awesome
4:53 hahhahaa TKO abbrieviates to technical knock out lol
Anyways top video thanks man really help a lot
Love your enthusiasm in teaching, thanks for the help. :)
Awesome:-) , you make things so easy to understand..You really have a gift to teach:-), can you post some videos on sequence diagram,state diagram and use case diagram pls
Excellent Explanation. Really enjoyed it.
Would an intersecting table Consist of just primary keys from other tables?
You are so smart and discovered the idea about DB.
nice vid! watching for my database analytics class!
is it a board or a projector, i haven't seen this kind before
Excellent teaching approach thanks a million.
Great video. Very informative and helpful. Thanks!
Good job sir. Helped in understanding
so it is correct to say that database schema and ERB are essentially the same thing then. It has been puzzling for me for a while.
This is a really good explanation.