Developing SQL Databases — Question 28

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You have a database that contains a table named Employees. The table stores information about the employees of your company.
You need to implement and enforce the following business rules:
✑ Limit the values that are accepted by the Salary column.
✑ Prevent salaries less than $15,000 and greater than $300,000 from being entered.
✑ Determine valid values by using logical expressions.
✑ Do not validate data integrity when running DELETE statements.
Solution: You implement cascading referential integrity constraints on the table.
Does the solution meet the goal?

Answer options

Correct answer: A

Explanation

The solution of implementing cascading referential integrity constraints does meet the requirements, as it helps maintain data integrity by enforcing limits on the Salary column without validating data integrity during DELETE operations. The other option, 'No,' is incorrect because it does not recognize that cascading constraints can effectively enforce the specified salary limits.