Results 1 to 2 of 2

Thread: Specialisation

  1. #1
    Join Date
    Sep 2004


    I have a Patient table and then two specialisations for patient entity i.e. Inpatient and Outpatient (separate tables for both of these). I have converted the entities into tables. How do I connect them when I make relatioships between the Patient (Patient_No) and Inpatient (I_Patient_No)? Then, Patient_No and O_Patient_No (for Outpatient). The given attributes are the primary keys for their respective tables.

    Hopefully someone can help me with this. Any help will be appreciated. Thanks in advance.

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    what do you mean "connect" them?

    I_Patient_No is a foreign key to Patient.Patient_No

    O_Patient_No is also a foreign key to Patient.Patient_No | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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