The normal forms are about how data is stored, rather than how it looks after a query. After all, most joins will violate second normal form. But yes, SQL does

The normal forms are about how data is stored, rather than how it looks after a query. After all, most joins will violate second normal form. But yes, SQL doesn't work well with this solution.