Table Organization

Relational Databases

Table Organization

🙋 Need help? Ask an expert now!

Table Organization

Usually we separate tables in order to contain data for a specific type of purpose.

Table Relationships to Data

Each table can have relationships with each other, instead of repeating the same product how ever many times someone buys it, we can instead reference back to that product in a separate table.

The same database can be used in different ways across applications at the same time.

Again, don't worry if this is a bit confusing! It will make more sense as we go!

Examples

  • An app could be pulling data to show the average time a product is being used.
  • An analyst could be pulling the data to learn what product has the most sales.
Edit Me on GitHub!