On Friday, July 7, 2023, Himanshu Upadhyaya <upadhyaya.himan...@gmail.com> wrote:
> I can think of one scenario, as below > > 1) any department should have an employee > 2)any employee should be assigned to a department > so, the employee table has a FK to the department table, and another check > constraint should be added to the department table to ensure there should > be one/more employees in this department. > > That isn’t a valid/allowed check constraint - it contains a prohibited reference to another table. David J.
