Guest Post: Schema Normalization & Why its done 

Schema normalization equips data analysts with the ability to design robust, efficient, and scalable databases, which are crucial for accurate data analysis, insightful reporting, and informed decision-making.
Understanding Normalization would help you better understand why JOINS are done.