Wednesday, March 7, 2012

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 attachedI'd go with one joining table:

SampleID
SampleType ("Face", "Voice")
BiometriceTemplateID
MediumID

No comments:

Post a Comment