Data organization in a database is done by normalization. This entails creating tables and linking those tables together in accordance with principles intended to safeguard the data and increase the database’s adaptability by removing duplication and inconsistent reliance.
In other words, the practice of normalization improves data integrity in the table by removing redundant data and duplication. Additionally, normalization aids in database data organization.
Click here to read more about Normalization.
4 projects with unnormalized raw data are shown below in tabular format. I typically provide this to beginners to practice data normalization and modeling.
Big Data and SQL 