There are some relations between Faculty and Clinic Faculty tables
- For any record in the Clinic Faculty table, it should have a mapped Faculty ID exists in the Faculty table.
- There are First name and Last name fields in the Clinic Faculty table. But to simplify record maintenance purpose, they will not be used. Instead, the First and Last names from its mapped Faculty table will be used. So the mapped ID field cannot be blank for all Clinic Faculty records.
1 thought on “Clinic Faculty records housekeeping”
Closed