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.