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
Redo Logs: Any database must have minimum two redo logs. These are the rules for the database; the redo logs record all modifies to the system objects or user objects. If any type

What are the three classes of SQL expression? SQL expression consists of three clauses:  Select  From  Where

1. Determine that the Checkpoints are a part of  Ans: Checkpoints are a part of Recovery measures

Explain Deadlock detection and recovery Deadlock Detection - A deadlock is said to take place when there is a circular chain of transaction, every waiting for the release of a

Describe Hashing in DBMS? Hashing: Hashing is a technique to store data within an array so which storing, searching, inserting and deleting data is fast (in theory it's O(1))

Improved availability: The data in a distributed system may be replicated so that it is at more than one site. Thus, the failure of a node or a communication link does not necessar

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

What are the benefits of prepared statements and place holders? Parameter binding operations automatically handle escaping of characters Encourage Statement reuse

Ask Write the SQL code that will create the table structure for a table named EMP _1. This table is a subset of the EMPLOYEE table. The basic EMP_1 table structure is summarized in

Explain Clustering file organization (i) Determine if a record of file is physically ordered on a nonkey field - that does not comprise a different value for each record - that