Database Management System20795 marksSpecifying Constraints
Explain Assertion and Triggers with example.
Explain Assertion and Triggers with example. [5]
--- An assertion is a predicate (condition) that expresses a constraint that the database must always satisfy. It is a general integrity constraint that is not tied to a single table but can span multiple tables. - Assertions are part of SQL's Data Definition Language (DDL). - Whenever a database...