M
mgupta010
Hi there,
I am working on creating data model from existing database using MS
Visio 2007 Profesional Edition.
Present DB is w/o PK-FKs & I am working to create relational DB which
enforces RI etc
I have a lookup table which contains language codes,used by main
table. The problem ,I am running into, is that these language
codes(from lookup table) are used by 3 columns in main table.
So, I am wondering how can I enforce PK-FK relationship here.
As in...
language_code from lookup table is PK and it has to associated w/
column(s) existing in main table
FYI:
I think VISIO doesn't allow relating a single column (from parent
table) to 3 different columns. It associates with Either ColA or ColB
or ColC.. not with all of them
Please advise
Thanks
I am working on creating data model from existing database using MS
Visio 2007 Profesional Edition.
Present DB is w/o PK-FKs & I am working to create relational DB which
enforces RI etc
I have a lookup table which contains language codes,used by main
table. The problem ,I am running into, is that these language
codes(from lookup table) are used by 3 columns in main table.
So, I am wondering how can I enforce PK-FK relationship here.
As in...
language_code from lookup table is PK and it has to associated w/
column(s) existing in main table
FYI:
I think VISIO doesn't allow relating a single column (from parent
table) to 3 different columns. It associates with Either ColA or ColB
or ColC.. not with all of them
Please advise
Thanks