Database Product table (problem with product size)

3

Good morning first of all, let's imagine that my products table would have the fields ( product_code , name, gender, price, size), having the size field in this table would involve I would like to create a new table with (cod_product, size) as a composite key ... thanks.

    
asked by anonymous 12.05.2016 / 10:31

1 answer

0

You need to create a new table:

tbl_tamanhos
cod_tamanho (PK) - primary key
product_code (FK) - foreign key product_size

The relation between them will be N: N.

    
12.05.2016 / 11:44