Beacuse OrderDetails is the only table where that key makes sense. There can be multiple products per order so multiple productgroups per order are possible. Therefore the key cannot be part of the Orders table. Country is not related to Product so the key can't be part of the Products table. The only place where that key can be created is in the OrderDetails table.