The interactions in this eCourse require Javascript to be enabled.
Implementing Business Rules
previous|next
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.