SQLTeam.com | Weblogs | Forums

Data Modelling


#1

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


#2

I assume that Id in the Sales table points to the Product table, What is Id2? As for a composite key, that depends on what you need to make the key unique.


#3

Gbritton, Thanks It was solved by our team.

regards
Anna