hard20 pts · first answer countsdata-modellingconstraints

Two tables that reference each other

departments.head_emp_id references employees, and employees.dept_id references departments, both NOT NULL. You cannot insert the first department or employee. What PostgreSQL feature helps?

A.ON DELETE CASCADE on both foreign keysB.DEFERRABLE INITIALLY DEFERRED foreign keysC.A UNIQUE constraint on head_emp_idD.Disabling the primary keys during inserts

Discussion 0

Join free to post in the discussion.

Two tables that reference each other

Discussion 0

Related questions