Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2006
    Posts
    1

    Question Unanswered: Sanity check of data model

    Hi, new to this forum. I have a data model that I'm curious about, because it has a structure that's new to me:

    TableA -- TableB -- TableD
    TableA -- TableC -- TableD

    TableB and TableC each model a many-to-many relationship between TableA and TableD.

    In addition to being new to me, it might also be the causing us problems with our code generator (a product called .netTiers).

    Anyone used this construct before, or suggest an alternative?

    Dave

    P.S. Data model is attached
    Attached Thumbnails Attached Thumbnails Tygart DataModel.jpg  

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I'd go with one joining table:

    SampleID
    SampleType ("Face", "Voice")
    BiometriceTemplateID
    MediumID
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •