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 Tutorial - A K...
Data Vault Model Tutorial: • Data Vault Model Tutorial - An Altern...
------------------------------------------------------------------------------
Data Podcast ►► https://open.spotify.com/show/4PWmW2g...
Website ►► https://www.nullqueries.com/
------------------------------------------------------------------------------
🎓Data courses (Not Produced by nullQueries)🎓
Azure Data Engineering: https://click.linksynergy.com/deeplin...
DE Essentials, hands on: https://click.linksynergy.com/deeplin...
------------------------------------------------------------------------------
📷VIDEO GEAR📷
Programming Mouse: https://amzn.to/3zEom7f
Lighting: https://amzn.to/3o8tXAM
RGB light: https://amzn.to/3o8AQBS
USB Microphone: https://amzn.to/3m3hjAt
Mixer: https://amzn.to/2ZyqMIk
XLR Microphone: https://amzn.to/3AHPZ0L
💻VIDEO SOFTWARE💻
music/stock: https://1.envato.market/rnX70y
------------------------------------------------------------------------------
For business inquiries please contact [email protected]
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
