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
Insertion Anomaly: Inability to show certain information-The primary key of the over relation be (enrolment number, Cno). Any new tuple to be inserted in the relation should have

What is Thread splitting A thread of control is a path by which a set of state diagrams on that a single object is active at a time. Objects are shared between threads

By using the delete operation some consisting records can be deleted from a relation. To delete some definite records from the database a condition is also specified based on which

User error :  This contains errors in the program (e.g., Logical errors) with errors made by online users of database.  These types of errors can be avoided by applying some check

What are the Objectives of object design After going through this unit, you could be able to: explain steps of object design; discuss algorithms that reduce costs;

Example -GRANT CREATE SESSION TO MCA12; (This command gives system level permission on creating a session - not portable) GRANT SELECT ON EMP TO MCA12; (Object level permi

Question : Object-Oriented Database (OODM) is defined as a logical data model that captures the semantics of objects supported in object-oriented programming. An Object-Oriente

What is the way a particular application views the data from the database that the application uses? Sub schema is the way a particular application views the data from the data

Submission Requirements All answers must be computer generated (including text and diagrams). The hand-in version must include a header page (or with sufficient space)

What is a query tree?     Ans:  A query tree, as well known as operator graph, is a tree data structure that corresponds to a relational algebra expression. It denotes the inpu