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
Objectives After reading this part, you should be able to: Modify, create, and delete database schema objects; Update database using SQL command; Retrieve data f

Compare three clustering algorithms in Weka. For this comparison, you will need to use at least two different datasets. Run the algorithms on the datasets, and use the visual

Benefits of Hashed file Organisation 1.      Insertion or search on hash-key is quick. 2.      Best if equality search is required on hash-key. Drawbacks of Hashed file

each publisher has uniqe name a mial addrs are also kept on each pubisher.a publisher publish one book.a book publish y one publisher.book identified by isbn.each book writn by one

Attributes having a one value for a particular entity. For instance, Age is a single valued attribute of a student entity. Attributes  that  have  more  than  single  values

Describe the shadow paging technique.

What are the reasons for having variable length records? What are the various ways to store variable length records? Variable-length records arise in a database in various wa

Consider the 1ollowin8 relation: CAR SALE (Car_id, Option_type, Option_listprice, Sale_date, Option_discountedprice) This relation refers to options installed in cars (e.g., crui

Using a labelled diagram explain the operation of the Data Warehouse, define the basic architectural components and outline the main functionalities. Briefly explain the role an op

Need for Client Server Computing- Client/Server (C/S) architecture includes running the application on multiple machines in which every machine with its component software tackles