Question · SQL and MySQL course · Module 7: Joining tables (JOIN)
Why we split data into tables
Why do we split data in a database into separate tables (e.g. ksiazki and autorzy) instead of keeping everything in one?
Answer options
- Because MySQL does not allow more than five columns in one table
- To avoid repeating the same information and keep order - we link tables with a foreign key
- To make the data load slower but look nicer
- Because every table must have a different color
You can check the correct answer by solving this task in the CodeWorlds game.