Database normalization is the cornerstone of database theory. Once a database is normalized, relationships between the data in multiple tables must be established. A hefty part of designing a ...

I have an order table that is an order for a customer. I need to reference as a foreign key an unknown number of products that could make up the order (product_id) how do I do this? What am I missing.

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Jinsong Yu shares deep architectural insights ...