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
• Disable the constraint between the DEPENDENTS and EMPLOYEES tables

Watch Sheila manage the constraints on the DEPENDENTS table by using the Object Browser.

Show Me and Try It

Watch Sheila disable the foreign key constraint on the DEPENDENTS table by using the appropriate SQL statement.

Show Me and Try It