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.

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