Question

Define and explain the following constraints in terms of database.

(i) Key constraint

(ii) NOT NULL constraint

(iii) Semantic constraint

(iv) Referential Integrity constraint

26 Oct 2017
Answer :
Word Count : 617

(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

_________ ______ __________ _______ _____ __________ _______ ________ ___ ___ ________ ______.
________ ______ ____ _____ _________ ___ _________ _________ ____.
__________ ____ _____ ____ ______ __________ _______.
________ _______ _________ __________ ______ _________ ____.
_______ _______ ______ __________ ________ ___ _________ ________ ___ _________ ________ ___.
_________ ________ ________ _____ ______.
__________ ______ ________ ______ _____.
______ ________ ___ _______ _______.
__________ __________ ____ _____ __________ _________ _____.
_____ _______ _______ ________ ___ ________.
_______ ___ ________ ___ ______ ______ __________.
_____ _____ _____ ____ __________ ______ ____ ________.
____ _______ __________ ___ _____ ____.
______ ____ _________ _______ ___ __________ ______ ___ __________ ________.
_____ ___ ____ _____ ______ ______ __________ __________.
___ __________ ________ __________ __________ _______ ______ _______ __________.
________ _____ _______ ___ __________ ______ ________ _______ ______ ___ ______ __________.
_______ _______ _________ _________ ___ ________ ___ _________ _____ ________ ______.
_______ ___ __________ _____ ______ ______ ________ _______ _______ _____ _______.
_____ _______ _______ _____ ______ ___ _________ __________ _________ _____ _________.
____ _______ _____ __________ ________.
_________ _________ __________ ___ ____.
______ _________ ____ ____ ___ __________ ________.
__________ __________ __________ ___ _________ _________.
____ __________ _______ ________ ____ ____ ________ _______ _________.
_______ _____ __________ _________ _______ _____ _____ ________.
___ ________ _______ ___ ____ ___ ______ __________.
_______ __________ _____ _________ _______.
______ ______ __________ ____ ____ ____.
_________ ___ __________ ___ ___ ________ _________ _________.
_____ _____ _________ ____ ______ __________.
______ ______ __________ _______ _______ ____ ___ __________ _______ _______.
___ _____ ___ _______ __________ _____ ________ ____.
_____ _________ ____ ______ ____ ____ _______ ______ ___ ______.
__________ _________ ___ ________ ___ ___.
_______ ___ __________ ___ ______.
__________ ______ ____ _________ _________ ____ ________.
___ ____ ________ ________ _________ __________ ___ ______ ________ __________ ______.
_____ ____ __________ _______ __________.
_____ ________ ___ _________ ___.
_______ ____ ___ _______ ____ ______ _____ ____ ____ ____.
_____ _____ _________ _____ ___ ___ ________ _______ _______.
_________ ____ _______ ________ ____ _________ ______ ___ ______.
____ __________ ___ ______ _____ ____ _____ _____ __________ ______ _________.
______ ________ ______ ____ ________ ___ _________.
_____ __________ _________ ______ _____ ______.
_________ __________ ____ _______ ___ _______ _________ ______ ________ _________.
__________ ______ _______ _________ ________ ___ ______ ________.
____ ___ _________ ____ _______.
_____ _______ _______ __________ ________ _____ _____ _____.
______ ________ _______ _____ ________ __________ ______ ________ _________.
_________ _____ _______ ________ ________ _____ __________ _________ ________ ________ _________ _______.
__________ __________ _______ ________ _____ _____ ___ ____.
_________ __________ ________ ___ __________ ___ _____ ______.
______ __________ __________ _________ _________ _______ __________ _______ ___ _________ ____.
_____ ___ ______ _______ _________.
______ _________ _____ ____ _______.
_________ ______ _____ ______ ______ ___.
____ ________ _______ ____ _____ ___ _____ _______ ______ ________ ________ ________.
____ ____.
IGNOU ACADEMY
Your IGNOU journey, made easier.
  • Solved Assignments
  • Study Notes
  • Guess Papers
  • Question Papers
Skip in 10
Top
📞
Call Support Instant phone assistance IGNOU CIT 1 2015 2016 - Define and explain the following constraints in terms of database. | IGNOU Academy
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→