I am working on creating data model from existing database.
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.
So, I am wondering how can I enforce PK-FK relationship here.
language_code from lookup table is PK and it has to associated w/ column(s) existing in main table