RE: Data Modeling:Lookup table and Main table:establishing relationshi
- From: barbway@xxxxxxxxxxxxxxxxxxxx (Barb Way)
- Date: Thu, 16 Oct 2008 22:59:38 GMT
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\f0\fs26 It's true that Visio doesn't have a mechanism to set up such a structure, as far as I know. But I'm trying to understand how you set it up in SQL (for instance). What DDL code would you use to define the relationship as you envision it? You have to basically ask SQL to parse a single column into three columns ... which would require code of some sort. A trigger is not a relationship.
\par
\par Barb Way
\par Product Support - Visio
\par Microsoft Corporation
\par [This posting is provided "As Is" with no warranties, and confers no rights.]
\par \pard\li720 --------------------
\par
\par I am working on creating data model from existing database using MS
\par Visio 2007 Profesional Edition.
\par Existing database is w/o PK-FKs & I am working to create relational DB
\par which enforces RI.
\par I have a lookup table which contains language codes,used by main
\par table. The problem ,I am running into, is that these
\par languagecodes(from lookup table) are used by 3 columns in main table.
\par So, I am wondering how can I enforce PK-FK relationship here.
\par As in...
\par language_code from lookup table is PK and it has to associated w/
\par column(s) existing in main table.
\par Something like following:
\par Lookup Table Main table
\par Column#1 Column A
\par column#2 Column B
\par Column C
\par Column D
\par I want to link Column#2 to Column A, Column B and Column C.
\par
\par FYI:
\par I think VISIO doesn't allow relating a single column (Of lookup table)
\par to 3 different columns(of main table). It associates with Either ColA
\par or ColB or ColC.. not with all of them
\par
\par Please advise
\par
\par Thanks
\par \pard
\par
\par }
- Prev by Date: Re: Creating a custom stencil for Cross Functional band and Separa
- Next by Date: display of text and lines from CAD
- Previous by thread: Drawings
- Next by thread: display of text and lines from CAD
- Index(es):
Relevant Pages
|
