if we have two tables in database..
one is the table products
Table Name: Products with attributes ( productid(pk), productname, productImage, UnitPrice, Description)
another table is of stock
TableName: Stock with attributes( stockid(pk),productid(fk),productname,orderquantity,delivarystatus,delivarydate)
i want to know that is it leagle to put productname again in stock table. can anyone explain this.