Domain constraint, Database Management System

Domain Constraint

It shows that each attribute in a relation has to contain an atomic value only from the corresponding domains. The data types associated with commercial RDBMS domains include:

1) Real numbers (double precision floats, float,)

2) Standard numeric data types for integer (such as integer, short- integer,  long integer)

3)  Characters

4)  Fixed length strings and variable length strings.

Therefore, domain constraint shows the condition that we want to put on every instance of the relation. So the values that show in each column must be drawn from the domain associated with that column.

For instance, consider the relation:

STUDENT

 

ROLLNO

 

NAME

 

LOGIN

 

AGE

 

4677

 

Kanu

Golgin_atat@yahoo.com

 

20

 

3677

 

Shikha

 

Noorie_jan@yahoo.com

 

20

 

In the relation above, AGE of the relation STUDENT always relates to the integer domain within a specified range (if any), and not to strings or any other domain. Within a domain non-atomic values should be avoided. This much time cannot be checked by domain constraints. For instance, a database which has area code and phone numbers as two dissimilar fields will take phone numbers as-

 

Area code

 

Phone

 

11

 

29534466

A non-atomic value in this case for a phone can be 1129534466, Though, this value can be accepted by the Phone field.

Posted Date: 3/6/2013 5:26:22 AM | Location : United States







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

Write discussion on Domain constraint
Your posts are moderated
Related Questions
a set of possible data value of an attribute is called??

What are axioms? Axioms or rules of inference give a simpler technique for reasoning about

How does the system cope up with a record crash when recovery is going on after the first crash? Ans:  In a system the undo and redo operations are needed to be idempotent to c

What is a dataset? A dataset is an in-memory database that is disconnected from any regular database, but has all the significant characteristics of a regular database. Dataset

Explain view in RDBMS? View - A view is a relation (virtual rather than base) and could be used in query expressions, which is, queries can be written by using the view as a re

Define about the Stored Procedure - It's a set of T-SQL statements combined together to perform a single task formed by combining numerous small tasks. - When you essentiall

FitAll Ltd is a company that manufactures clothes. Its processes are manual and there are stand-alone Information Systems that aid to manage them. The Information Systems were purc

Define the phases of two phase locking protocol Growing phase: a transaction may get locks but not release any lock. Shrinking phase: a transaction might be release locks bu

Explain the Fundamental concepts of object-orientation Software developers, data base administrators (DBAs) need to be familiar with fundamental concepts of object-orientation.

folding method and mid square method using visual basic