Domain constraints, Database Management System

Domain Constraints

Domain constraints are primarily formed for defining the logically correct values for an attribute of a relation. The relation allows attributes of a relation to be confined to a range of values, for instance, values of an attribute age can be restricted as Zero to 150 or a definite type like integers, etc.

                                                      REDUNDANCY AND ASSOCIATED PROBLEMS

Let us take the subsequent relation STUDENT

Enrolment no

Sname

Address

Cno

Cname

Instructor

Office

050112345

Rahul

D-27, main Road

Ranchi

MCS-011

Problem

Solution

Nayan

Kumar

102

050112345

Rahul

D-27, Main Road

Ranchi

MCS-012

Computer

Organisation

Anurag

Sharma

105

050112345

Rahul

D-27, Main Road

Ranchi

MCS-014

SSAD

Preeti

Anand

103

050111341

Aparna

B-III, Gurgaon

MCS-014

SSAD

Preeti

Anand

103

                                                                           Figure: A state of STUDENT relation

The above relation satisfies the properties of a relation and is said to be in first normal form (or 1NF). Theoretically it is convenient to have all the information in one relation as it is then likely to be simpler to query the database. But the relation over has the following undesirable kinds:

Posted Date: 3/7/2013 1:41:24 AM | Location : United States







Related Discussions:- Domain constraints, Assignment Help, Ask Question on Domain constraints, Get Answer, Expert's Help, Domain constraints Discussions

Write discussion on Domain constraints
Your posts are moderated
Related Questions
Discuss along with examples about several types of attributes present in the ER model? Types of Attributes are: • SIMPLE attributes are attributes which are drawn from the ato

What is object identity? An object retains its identity even if some or all the values of variables or explanations of methods change overtime.

What is entity in DBMS? Entity: A DBMS entity is either a thing in the modelled world or a drawing element in an ERD.

What is serializability? Explain its types? The data base system must control concurrent implementation of transactions, to ensure that the data base state remains consistent.


a publishing company produce scientific books on various subjects. the books are written by authors who specialize in one particular subject. the company employs editors who, not n

Define the following constraints for the table client. (i) BAL_DUE must be at least 1000. (ii) NAME is a unique key. (i)ALTER TABLE CLIENT ADD CONSTRAINT CLIENT_BAL_DUE_C1

Define union compatibility? Explain why INTERSECTION of two relations cannot be performed if they are not union compatible? Two relations R(A1, A2,-------, An) and S(B1, B2,--

Define Database layer? The database layer defines the data formats used in the database.

Illustrate different types of Locks in SQL Server. There are three kinds of locks in SQL Server i.) Shared locks - These are used for operations which don't allow any update