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:
Worksheets and other resources:


Xem thêm bài viết khác:


  1. Tech Donor 11 July, 2020 at 16:42 Reply

    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.

  2. Divya Nesana 11 July, 2020 at 16:42 Reply


  3. spandan gude 11 July, 2020 at 16:42 Reply

    How did you manage to get the desired screens or options just by touching the projected part. Ive never seen that before.

  4. Fido Lost 11 July, 2020 at 16:42 Reply

    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.

  5. Sreekant K 11 July, 2020 at 16:42 Reply

    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.

  6. Good DeedsLeadTo 11 July, 2020 at 16:42 Reply

    Could u also show an example of many to many?
    Is this mapping always done from right to left?
    Records produced after joining depend on this mapping?

  7. SeanJTharpe 11 July, 2020 at 16:42 Reply

    Thanks man, you are amazing! Very informative and the presentation absolutely helps! Thank you so much!! Subscribed.

  8. Pacific NW 11 July, 2020 at 16:42 Reply

    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

  9. Caolain Hession 11 July, 2020 at 16:42 Reply

    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.

  10. Harrison Woodard 11 July, 2020 at 16:42 Reply

    I literally just started watching this video and got a splash of all the energy in your teaching method. You're awesome!

  11. gowithchristbrah 11 July, 2020 at 16:42 Reply

    would the field in the class table be "TeacherID"" as the foreign key because the primary key in the Teacher table is "TeacherID"?

  12. Vinyl Addiction 11 July, 2020 at 16:42 Reply

    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.

  13. Nico Braun 11 July, 2020 at 16:42 Reply

    Liked that moment of pausing and letting the class think, what key would that be? hmmm… . Well done!

Leave a reply