X


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