Hello Experts,
I have two tables though these are dummy ones::
Product
Id as Primary key,
name of product varchar(3)
there is another table
Sales
SalesId as Primary key
Id as foreign key
Id2 as foreign key
product_name varchar(30)
I want to know If I repeat the column Id and Id2 in sales table to create a composite key for that table, am I increasing data redundancy