Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    9

    Tables with No Relationships

    Hi All,

    I have a simple data modeling question. Is it proper in a rationalized data model to have tables with no relationship to any other tables? These tables would have a column identifying itself such as "tblId" which would have the same value in this column for each record. All references to these tables would occur in SQL statements. The "tblId" column value would be created when the table was dynamically created from the primary key Id of a type table.

    Many Thanks
    mBlack

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    If such a table is useful, then certainly you may have it! I don't understand why it would need a tblId column to identify itself though; surely the table name already does that?

  3. #3
    Join Date
    Jan 2004
    Posts
    9
    Andrew

    You are right about the "tblId" column. That stemmed from an earlier attempt to model a superType / subType situation in MS Access and didnt get erased from my whiteboard before I wrote the original post. I guess sometimes you cant see the forest because the trees block your view.

    Anyhow, thanks for your help.

    Mike

Posting Permissions

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