The relationship between STORE and EMPLOYEE is defaulted to mandatory, that is, the FK value in EMPLOYEE is required. How do you eliminate a record from STORE?

(A) Delete the employees from the STORE to be deleted
(B) Permanently remove the referential integrity enforcement
(C) Open the EMPLOYEE table in the design format; then change the Required property of the EMPLOYEE’s FK to No and make sure that its default value is set to null
(D) Delete all relationships between STORE and EMPLOYEE. Redesign the database to work without them