Results 1 to 2 of 2

Thread: Dbms

  1. #1
    Join Date
    Feb 2006

    Unanswered: Dbms

    WHat purpose does it serve in a situation where there is a foreign in a table which references the primary key of the same table?
    for example:
    Employee(Fname, Minit, Lname, SSN, Bdate, Address, Sex, Salary, SuperSSN,
    In Employee: SuperSSN is a foreign key that references Employee(SSN); Dno is a
    foreign key that references Department(Dnumber).??

  2. #2
    Join Date
    Jul 2003
    A Simple Guide to Five Normal Forms in Relational Database Theory
    PHP Code: 
    basically what I am saying is that you (or someone) is not following "The Guide"

    dno FK seems to be fine though.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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