โ† Sopra Steria questions
Low-Level DesignReported in a candidate post, Sep 2019

Normalization, Cartesian product, joins, and foreign keys

Filed under Sopra Steria

The question

Explain normalization, Cartesian products (including row counts for tables of 3 and 6 rows), difference between Cartesian product and join, left and right joins, finding unique rows, and the purpose of foreign keys.

No write-up yet. Related questions below have one.

Collected from public candidate posts and coding forums. Updated Nov 2026.