Implementing Business Rules

Sheila's manager wants to ensure that data integrity is handled on the new tables and columns that she has created. The manager has asked Sheila to add constraints with the following rules:

• In the DEPENDENTS table, have a primary key constraint on the Id column
• Allow the Gender column to hold the value of M or F
• Tie the DEPENDENTS table to the EMPLOYEES table so that the RelativeId column must hold a valid value from the EMPLOYEES Id column

Help Sheila manage the constraints on the DEPENDENTS table.

Show Me and Try It

Help Sheila disable the foreign key constraint on the DEPENDENTS table and produce a report of the disabled constraints.

Show Me and Try It