I have the following scenario:
- Products table (a lot of products info, including prices)
- Clients table (just the client id and name)
- A CliPrice table (product price for each client, columns: id, id_prod, id_cli, price)
Would it be better to join the CliPrice table with the Clients table by adding the Client name in the CliPrice?
Is it wrong?
OBS: The same happens with a VolRegion (id, id_reg, id_prod, volume) table where I have a Region table with the region name and id only.