Integrity Constraints

Not Null Constraint

Unique Constraint

The check Clause

Referential Integrity

SQL Assertions :

Q. For each tuple in the student relation, the value of the attribute tot_cred must equal the sum of credits of courses that the student has completed successfully. [ Hint : student (ID, name, dept_name, tot_cred)

SQL Data Types and Schemas

Q. Date and time values can be specified like this:

Previous Next