Given the database schema R (a, b, c), and a relation r on the schema R, write

Question:

Given the database schema R (a, b, c), and a relation r on the schema R, write an SQL query to test whether the functional dependency b → c holds on relation r. Alsowrite an SQL assertion that enforces the functional dependency. Assume that no null values are present.