How are database tables separated?

Question

In the context of this exercise, how are database tables separated?

Answer

Database tables are typically separated based on what information they store and focus on a single idea.

For instance, for the Songify database, the data has been separated into tables based on the information, such as for users, plans and songs. Each table is mostly independent of each other and contains data relevant to itself. The users table stores just information about each user, the songs table stores information for just the songs, and so on.

5 Likes