Most database developers and data modelers make this mistake. When designing databases, they add PK-FKs between 2 tables, if they see that these 2 tables will be joined in SQL queries. This is not right. Watch this video to understand why
Link to OLTP & OLAP video -
https://youtu.be/e6zg--p6SoU
Hi, My name is Bindu Kumar and I am a Data Architect who is passionate in learning as well as sharing my learning with others.
If you found this video useful, please do Like, Share & Subscribe.
If you found this content useful, consider buying me a cup of coffee -
https://www.buymeacoffee.com/dataacademy
https://ko-fi.com/dataacademy
Contact Info -
Email ID:
[email protected]
Telegram Group: t.me/dataupskill
LinkedIN: https://www.linkedin.com/in/sandeepkumardwbi/
Website: www.dataacademy.in
Tags:
DataAcademy, DataAcademyIN, Data Academy India, Data Academy, Bindu Kumar, BinduKumar, Data Model, Data Modeling, 3NF, E F Codd, Primary Key, Foreign Key, PK, FK, Database Design, Normal Forms