Domains, Database Management System

A domain is a set of permissible values that can be given to an attribute. So each attribute in a table has a definite domain. Values to these attributes cannot be assigned outside their domains.

In the example given above if domain of PERSON_ID is a set of integer values from 1 to

1000 than a value outside this range will not be valid. Many other common domains may be age between 1 and 150. The domain can be definite by assigning a type or a format or a range to an attribute. For instance, a domain for a number 501 to 999 can be particular by having a 3-digit number format having a range of values between 501 and 999. Therefore, please note the domains can also be non-contiguous. For instance, the enrolment number of IGNOU has the last digit as the check digit, therefore the nine- digit enrolment numbers are non continuous.

Posted Date: 3/6/2013 5:16:18 AM | Location : United States







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

Write discussion on Domains
Your posts are moderated
Related Questions
Representing complex relationship among data A database may contain varieties of data interrelated to each other in numerous ways. A DBMS must have the capability to represent


What does data dictionary is a special file contains ? The data dictionary is a special file contain The name of all fields in all files.The width of all fields in all files an

What is database Trigger? A database trigger is a PL/SQL block that can explained to automatically execute for insert, update, and delete statements against a table. The trigge

What are the various properties of Relational tables? Relational tables have 6 properties: 1. Each row is unique. 2. Column values are of the same kind. 3. Values are

i want notes on this topic

What are the advantages of object oriented databases in comparison with others? Why it is still not widely used? Object oriented designs are coherent, efficient and less prone

Explain ER Relationship model? An entity-relationship model (ERM): An entity-relationship model (ERM) is an abstract theoretical illustration of structured data. Entity-relatio

A software contract and consultancy firm maintains details of all the various projects in which its employees are currently involved. These details comprise: Employee Numbe

I need ERP system We are selling automotive spare parts on the internet and we require ERP software, which would sync with our e-shop. Our e-shop doesn't use any e-commerce plat