Results 1 to 6 of 6

Thread: Refrential Intergrity in same table

  1. #1
    Join Date
    Nov 2002
    Posts
    231

    Refrential Intergrity in same table

    Hi,
    my client enforced Foreign Key Relationship to the same table in DB2 database. is it usefull?.
    Let me know your thought.
    Ravi

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Depends, do it if have to.

  3. #3
    Join Date
    Nov 2002
    Posts
    231
    rmiao,
    will it make sense?

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    It does in some cases, for example Empoyee table

    EMPID, MANAGER_ID

    Since manager is also an employee, you have a self referencing table.

  5. #5
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    I saw that before in some application where parentID and ChildID will be on the same table.

    It depends on the functionality of your app' and the approach you take for database design.

  6. #6
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    skhanal......

    you beat me this time.



Posting Permissions

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