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.