3 SQL Table Referential integrity
Posted on 2004-03-20
I have 3 existing tables
Toys_box Toy_box_id,Toy_type_id(FK from Toy_Type table) == (Box which contains toys)
Toy Toy_Id,Toy_box_ID(FK from Toys_Box) Toy_Name,Toy_Type_id(Fk from toy_Type table)
why is Toy_type_id existing in Toy table ...We already have toy_type_id in Toys_box table right
to get the toy type from toy table cant be join the toys_box table which has toy_type_id already defined
Isnt the toy_type_id repeating in toy table ....