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.