This content has been marked as final. Show 1 reply
First, you are posting into the wrong forum as this one is for the SQL*Developer tool from Oracle and not for general SQL questions.
Second, you cannot create a referential integrity with two parent tables. Maybe you should introduce a thrid table emp which stores the common part of doctors and nurses. Then you can ref your team to this table.
Or you store your doctors and nurses in one table setting some kind of emp_type column.
Hope that helps,