Database Normalization Tutorial - Modeling 3NF for OLTP

Let's take a hand's on look at modeling an OLTP, or transactional, database into third normal form (3NF). This design can take a business process and create a relational database from it, including some best practices and general concepts for normalization. Hope you enjoy this data modeling tutorial!
⏯RELATED VIDEOS⏯
Dimensional Data Model: • Dimensional Data Model...
Data Vault Model Tutorial: • Data Vault Model Tutor...
------------------------------------------------------------------------------
Data Podcast ►► open.spotify.com/show/4PWmW2g...
Website ►► www.nullqueries.com/
------------------------------------------------------------------------------
🎓Data courses (Not Produced by nullQueries)🎓
Azure Data Engineering: click.linksynergy.com/deeplin...
DE Essentials, hands on: click.linksynergy.com/deeplin...
------------------------------------------------------------------------------
📷VIDEO GEAR📷
Programming Mouse: amzn.to/3zEom7f
Lighting: amzn.to/3o8tXAM
RGB light: amzn.to/3o8AQBS
USB Microphone: amzn.to/3m3hjAt
Mixer: amzn.to/2ZyqMIk
XLR Microphone: amzn.to/3AHPZ0L
💻VIDEO SOFTWARE💻
music/stock: 1.envato.market/rnX70y
------------------------------------------------------------------------------
For business inquiries please contact [e-mail]
Some of the links in this description are affiliate links and support the channel. Thanks for the support!
------------------------------------------------------------------------------
00:00 Intro
00:45 Business Process
01:40 Raw Data
01:53 1st NF
02:42 2nd NF
03:45 3rd NF
04:20 ER diagram
06:40 Queries

[@nullQueries]

Next We'll be using this OLTP database as a starting point for modeling a dimensional data warehouse, and a data vault.
Check it out here: ruclips.net/video/gQisQHPhjwU/видео.html

[@coding3438]

The data engineering community is forever indebted to you sir. The way you explain concepts is unmatched. And I’m talking about being unmatched even when compared with top paid courses.

[@PeterHarket]

This channel has the best data modelling videos by far. Keep it up, and the world will notice!

[@phecdu]

You are so professional ^^ thank you so much, you will get 100.000 sub soon ^^

[@dhanangwibisono9821]

thank you for making these tutorial sir.

[@akshaykapoor8180]

very nice explanation

[@asd855280]

This is a really informative and insightful video, thank you for sharing. I am curious about the relationship between Book entity and Author entity, I was wondering would it be better to have another bridge table between the Book and Author entities, because some books are co-authored by more than one authors, therefore, it may ended up many-to-many relationship between Book and Author relation.

[@hussamcheema]

Hi. Which tool do you use for making such videos? How do you use these animations and effects?