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 during insert or update operations. If this column is left blank, this will produce an error message and the entire insert or update operation will fail.

Consider a table named CUSTOMER_MASTER

_________ __________ ___ __________ ___ __________ ________ ________ _______ ________.
___ _____ _____ _____ ___ ___ ________ __________ ____ ___.
_______ _______ _______ ________ ____ _______ ________ _____.
____ ____ ____ __________ ________.
_________ ___ __________ ____ ________ _____.
________ ________ ____ __________ ___ ______ __________ _________ _________ ______ ______ ______.
_________ ___ __________ ___ _______.
___ ___ ____ _____ ______ __________ _______ ____ _____ ______ ___ ______.
______ _________ ________ __________ ___ ________ ___ ___ ____.
______ __________ _________ _______ _____ _________ _________ _________ ________ ____ ___ _____.
______ ______ _________ ____ ________ _____.
_____ ___ _______ ______ ____ _______ __________ ______ ______ ________ ______.
_____ ___ _________ ____ _________ ___ ______ ________ __________ __________.
________ ____ _________ ________ _____ ____ _________ _________ ______ ___ ______.
_________ _______ ____ ________ _____.
__________ _______ _______ ___ ___ _________ ____.
____ ________ ______ _______ ________ ______ ______ ____ ________ ___ _____ ___.
____ _____ ___ _________ ____ _____ ______ ___ ______ ________ ______.
___ ___ ______ _____ ______ _______ __________ ______ ____ ______.
_______ __________ _______ ____ ___ _________ _____ ____ ___.
___ _______ ______ ___ _____ ________ ____ __________ _______ _______.
______ __________ ____ ________ __________ _________ ________ ___ ____.
____ ________ ____ ____ _______.
_______ _________ ______ _____ __________ ______ __________ _______ ______.
_____ ______ _____ __________ __________ _______ ______.
__________ ___ __________ _______ ________ __________ _________ ________.
________ ________ ____ ________ ______ ____ __________ _____ ______ ____.
____ ________ ___ __________ _______ __________.
__________ _______ ________ __________ _________ ___ ___ ______ __________.
_______ __________ ______ ________ _____ _____ _______ _____ _____.
___ ________ ___ ________ _________ _______ _____ _______ _____ ___ _______.
_______ ____ _________ __________ _______ _____ ___ _____ ______ ______ __________.
________ ____ ____ _____ _________ ______ ______.
______ _____ _____ ______ ______ ___ ____ _____.
____ _______ _____ _____ ____ __________ _____ ______ __________ _______ ________.
____ _______ _______ _______ ______ _____ ____ ________ ________ ______ _______.
____ ____ ______ ________ ________ ________ _________ ____ ___.
__________ ________ ____ ____ ____ ________ ________ _____ _____ __________ ___.
________ ____ ________ ________ ______ _________ ___ __________.
_______ ________ ______ _______ _______ ____ _________ ________ _________ _____ ___.
________ __________ ____ ___ ______ _______ __________ _____ _________ _____ ______ ________.
___ _________ ______ ___ ________ ________ _______ _________ ______.
____ _______ _______ ____ ________.
______ ______ ______ ________ ____ ______ __________ ______.
___ _____ ________ ___ ____ ________.
_______ __________ ____ _______ ___ ___ ___.
______ _________ _____ _____ ________ ______ ___ ____ __________ _____ _________ ___.
_____ _______ _____ ___ __________ ______ ________.
______ _______ ______ ___ ____ ___.
_____ ________ ________ __________ _________.
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
→