Database Lesson #5 of 8 - Database Design

Dr. Soper gives a lecture on database design. Topics include transforming ER data models into physical database designs, denormalization, implementing one-to-one, one-to-many, and many-to-many binary and recursive relationships, and writing SQL statements for creating joins for both binary and recursive relationships.

[egncn]

The best series of database fundamentals I have found. It is 2022 and still hold high!

[mekabay]

Notes by M. E. Kabay

00:00 Objectives
01:39 From Relations to Entities to Tables
03:26 Transitioning from a Data Model to a Database
06:32 Normalization Review: Modification Anomalies
11:06 Normalization Review: Solving Modification Anomalies
12:19 Normalization Review: Definitions
14:09 Normalization Review: Normal Forms
15:29 Normalization Review: Normalized Relations
16:29 Normalization Example
18:23 Normalized Set of Tables
19:26 Denormalization
20:25 Denormalized Set of Tables
22:53 Denormalization Benefits & Costs
25:43 Representing Relationships: 1:1 Relationships
30:15 Representing Relationships: SQL for 1:1 Relationships
31:02 Representing Relationships: 1:N Relationships
32:41 Representing Relationships: SQL for 1:N Relationships
33:08 Representing Relationships: N:M Relationships
35:50 Representing Relationships: SQL for N:M Relationships
36:45 Representing Relationships: Association Relationships
37:46 Surrogate Keys and Associative Entities
41:34 Representing Relationships: Recursive Relationships
44:05 Representing Relationships: 1:1 Recursive Relationship Examples
46:14 Representing Relationships: 1:N Recursive Relationship Examples
47:55 Representing Relationships: N:M Recursive Relationship Example

[captainkeyboard]

Dr. Daniel Soper, you are superior to be King of Organization! Smile! You are appreciated by me as a keyboard specialist, even from a far distance.

[captainkeyboard]

5 is my favorite number as far as this Lesson is concerned. You touched on the intimate part of relationships and another feature I like when I have been using Microsoft Access is that I created some extra tables in a few databases for a Lookup Wizard in Microsoft Access that no one has ever taught me to make. Your lessons are very comprehensive to understand.

[mario-t]

Absolutely the best contents, presentation, speed, manners, slides etc... Perfectionne !!!!
Thanks so much Dr for you generosity 

[clarkflavor]

Best explanations of database concepts I've seen so far. Great stuff!

[obliviondew]

This is the simplest database lecture i've ever had
many many thanks Dr.Daniel Soper !

[KathrynBrock]

Thank you!!!! I'm in an online systems class, and this was the help I needed to bridge the gap between in-person and online learning. Very grateful for your doing these lectures.

[zainnm]

Fantastically clear and simple explanation of a complex subject. I was struggling with this at work and then I came across ur lectures; they have really helped me out

[nitingadgil]

Best tutorial ever on Database basics.

[aaronnarva]

This series is wonderful. Very clear and very strategically ordered.

[sansybah]

This is one of best explanation of database concepts. Thx 

[sokheachap]

by far one of the best videos to help with understanding relational databases....I'm so glad I found your videos!

[tomasloritegarcia]

Thanks a lot Dr. Soper. I am an Engineer Computer and your video tutorial helps me maintain and refresh some already rusted concepts. My sincere gratitude and admiration for your work. 

[marrr]

Great videos! Like your tone of voice and flow...

[mahendra]

Many many thanks.., I did my engineering, but nobody explained the concepts like you... you are just great :)

[kingsleyakhimien]

Thanks Dr. Soper...you excellently explained each concepts with practical examples. Great video!

[NekkruEvul]

These videos were very helpful when studying for my Database exam. Excellent stuff. Thank you sir!

[Smr]

Just an FYI, if you listen with the playback speed on 1.5, it is actually a lot easier to listen to if you have a hard time keeping attention to slow speakers like I do lol. Great info though! Thanks

[MrRapperb]

thank for these videos, they are really useful in learning, and I love the fact that you are a Big Bang Theory fan too :)