Data Modeling : Creating relationship between Tables. Plz Help..thanks

M

mgupta

I am working on creating data model from existing database using MS
Visio 2007 Profesional Edition.
Existing database is w/o PK-FKs & I am working to create relational DB
which enforces RI.
I have a lookup table which contains language codes,used by main
table. The problem ,I am running into, is that these
languagecodes(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.
Something like following:
Lookup Table Main table
Column#1 Column A
column#2 Column B
Column C
Column D
I want to link Column#2 to Column A, Column B and Column C.

FYI:
I think VISIO doesn't allow relating a single column (Of lookup table)
to 3 different columns(of main table). It associates with Either ColA
or ColB or ColC.. not with all of them

Please advise

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Modeling:Lookup table and Main table:establishing relationshi 1
PK-FK relationship: lookup & main table 1
Select all entry data from two linked (with a relationship) Tables 4
Deleting/Creating a relationship between two tables -----> Help Pl 1
Data in different sheets 1
Creating Form Using Related Tables 0
How to enforce subtypes/supertypes in Access 2000? 34
SQL 1-to-7 relationship fails ... 5

Top