Database Schema
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:
– identifying the tables in a given situation
– 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:
Main channel:
Discussion:
Worksheets and other resources:
Nguồn: https://saesrpg.net/
Xem thêm bài viết khác: https://saesrpg.net/giai-tri/
Xem thêm Bài Viết:
- TRÒ CHƠI "XOẮN NÃO" DỄ QUẠO NHẤT VỤ TRỤ | Nabee TV
- Conversation with foreigners in English | Learn English for all levels
- Cố Chấp – Về Nơi Đâu (Phần 1) – TraCy Thảo My [ Official Music Video ]
- Học trực tuyến trên truyền hình MyTV: Giải pháp tối ưu mùa Covid-19
- Hướng dẫn sử dụng tính năng Điều khiển tivi (Remote Controller) trên MyTV và MyTV Net
Simplest explanation on Schema in database and how to define it with real life example.
It helped me a lot hopefully you will like it too.
https://youtu.be/6CBjFBpZgaM
Excellent way of explanation.
Thank you sir
Very simply explained…Keep going!
THERE ARE MANY GOOD TEACHERS IN THE WORLD. BUT I WONDER WHY MY COLLEGE HAS NO TEACHERS LIKE THIS.
How did you manage to get the desired screens or options just by touching the projected part. Ive never seen that before.
Good job sir. Helped in understanding
Another important concept is Normalization. So, following Eddie's example tables, we see that certain fields don't belong. The Student table shouldn't directly contain ClassIDs. The Class table shouldn't know anything about Teachers. The Teacher table shouldn't have a Subject (aka class). A more normalized approach would be to have a Person table with fields: PersonID, FirstName, LastName, DOB, and Address. The Class table would have ClassID, Room, and Subject. A separate Role table would have RoleID, RoleTitle (ie Teacher, Principal, Student, Undergraduate, …). Then a join or joint table would contain mostly foreign keys: Courses with fields: CourseID, ClassID, PersonID, RoleID.
Topic is on Schema and students can't even answer elementary questions like primary and foreign key? The teacher is awesome but I guess his talents are wasted on this bunch.
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
Kowalski Analysis. Select VideoLikes From YoutubeDB.ThisVideoInfo
Helpful man…thanks for tutorial
Thanks man, you are amazing! Very informative and the presentation absolutely helps! Thank you so much!! Subscribed.
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
he's fucking drawing in paint with his fingers wtf
uxsql.com ^^ make you database business application.. just few click~~
thank u brother
yoooo, it's that math guy. What's up dude
Thank you!
I apologise in advance, some may call me a hater but I feel compelled to tell you young eddie woo, that I find your energy and zeal very fucking annoying and I would enjoy punching you in the face many, many times, regards Caolain.
wow this was awesome teaching method
god I wish you were my database teacher
I literally just started watching this video and got a splash of all the energy in your teaching method. You're awesome!
would the field in the class table be "TeacherID"" as the foreign key because the primary key in the Teacher table is "TeacherID"?
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.
thank you lord woo
Liked that moment of pausing and letting the class think, what key would that be? hmmm… . Well done!
What is the difference between database schema and relation schema