Define and explain the following constraints in terms of database.
(i) Key constraint
(ii) NOT NULL constraint
(iii) Semantic constraint
(iv) Referential Integrity constraint
(i) Key constraint is implied by the existence of candidate keys. The intension includes a specification of the attribute(s) consisting the primary key and specification of the attribute(s) consisting alternate keys, if any. Each of these specifications implies a uniqueness constraint(by definition of candidate key);in addition primary key specification implies a no-nulls constraint( by integrity rule 1).
Referential constraints
Referential constraints are constraints implied by the existence of foreign keys. The intension includes a specification of all foreign keys in the relation. Each of these specifications implies a referential constraint ( by integrity rule 2).
Other constraints
Many other constraints are possible in theory.
Examples
salary >= 10000
(ii) The not-null constraint is a restriction placed on a column in a relational database table. It enforces the condition that, in that column, every row of data must contain a value - it cannot be left blank
________ ______ ____ _____ _________ ___ _________ _________ ____.
__________ ____ _____ ____ ______ __________ _______.
________ _______ _________ __________ ______ _________ ____.
_______ _______ ______ __________ ________ ___ _________ ________ ___ _________ ________ ___.
_________ ________ ________ _____ ______.
__________ ______ ________ ______ _____.
______ ________ ___ _______ _______.
__________ __________ ____ _____ __________ _________ _____.
_____ _______ _______ ________ ___ ________.
_______ ___ ________ ___ ______ ______ __________.
_____ _____ _____ ____ __________ ______ ____ ________.
____ _______ __________ ___ _____ ____.
______ ____ _________ _______ ___ __________ ______ ___ __________ ________.
_____ ___ ____ _____ ______ ______ __________ __________.
___ __________ ________ __________ __________ _______ ______ _______ __________.
________ _____ _______ ___ __________ ______ ________ _______ ______ ___ ______ __________.
_______ _______ _________ _________ ___ ________ ___ _________ _____ ________ ______.
_______ ___ __________ _____ ______ ______ ________ _______ _______ _____ _______.
_____ _______ _______ _____ ______ ___ _________ __________ _________ _____ _________.
____ _______ _____ __________ ________.
_________ _________ __________ ___ ____.
______ _________ ____ ____ ___ __________ ________.
__________ __________ __________ ___ _________ _________.
____ __________ _______ ________ ____ ____ ________ _______ _________.
_______ _____ __________ _________ _______ _____ _____ ________.
___ ________ _______ ___ ____ ___ ______ __________.
_______ __________ _____ _________ _______.
______ ______ __________ ____ ____ ____.
_________ ___ __________ ___ ___ ________ _________ _________.
_____ _____ _________ ____ ______ __________.
______ ______ __________ _______ _______ ____ ___ __________ _______ _______.
___ _____ ___ _______ __________ _____ ________ ____.
_____ _________ ____ ______ ____ ____ _______ ______ ___ ______.
__________ _________ ___ ________ ___ ___.
_______ ___ __________ ___ ______.
__________ ______ ____ _________ _________ ____ ________.
___ ____ ________ ________ _________ __________ ___ ______ ________ __________ ______.
_____ ____ __________ _______ __________.
_____ ________ ___ _________ ___.
_______ ____ ___ _______ ____ ______ _____ ____ ____ ____.
_____ _____ _________ _____ ___ ___ ________ _______ _______.
_________ ____ _______ ________ ____ _________ ______ ___ ______.
____ __________ ___ ______ _____ ____ _____ _____ __________ ______ _________.
______ ________ ______ ____ ________ ___ _________.
_____ __________ _________ ______ _____ ______.
_________ __________ ____ _______ ___ _______ _________ ______ ________ _________.
__________ ______ _______ _________ ________ ___ ______ ________.
____ ___ _________ ____ _______.
_____ _______ _______ __________ ________ _____ _____ _____.
______ ________ _______ _____ ________ __________ ______ ________ _________.
_________ _____ _______ ________ ________ _____ __________ _________ ________ ________ _________ _______.
__________ __________ _______ ________ _____ _____ ___ ____.
_________ __________ ________ ___ __________ ___ _____ ______.
______ __________ __________ _________ _________ _______ __________ _______ ___ _________ ____.
_____ ___ ______ _______ _________.
______ _________ _____ ____ _______.
_________ ______ _____ ______ ______ ___.
____ ________ _______ ____ _____ ___ _____ _______ ______ ________ ________ ________.
____ ____.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
✓ Unlock up to 60% of the answer
✓ No payment required