educative.io

Tuples vs rows , are they the same or differend?

Courses
,
#1

In the example provided:

The number of East region stores is 100,000
However the Stores table is 10,000 tuples. I might be confusing tuples vs entries or rows in that table but don’t understand how we can have 100,000 east stores but only 10,000 stores

Course: Grokking Modern System Design for Software Engineers & Managers - Learn Interactively
Lesson: Trade-offs in Databases - Grokking Modern System Design for Software Engineers & Managers

#2

Let’s understand this clearly :

Store table has 10,000 tuples
Product table has 100,000 tuples
Sales table has one million tuples

In the query, we are joining all three tables. Due to that join, we have the number of East region records as 100,000.

For your other query “A row can also be referred to as a record or a tuple.”