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
Explain Derived and Non-Derived Attribute? In few cases, two or more attribute values are related, for instance, Age and BirthDate attributes of a person. For specific person e

Question (a) Concurrent access to data from a database is a normal part of application program usage. Describe three approaches to concurrency control (b) Distinguish among

Explain the components of Database System in details.

What is database utility? Database utility is the interface among the ABAP/4 Dictionary and the underlying the SAP system.

crete a data base relationship model Entity: Students; Professors; Dormitories buildings; Attributes of students: Name; Address; Dorm;

DISADVANTAGES OF RDBMS

List some security violations (or) name any forms of malicious access. A) Unauthorized reading of data B) Unauthorized modification of data C) Unauthorized destruction of

Describe analysis of access paths To describe analysis of access paths, consider an example of the design of a company's employee skills database. A part of the object model fr

One-to-one relationship: For every 1:1 relationship type R in the ER diagram including two entities E1 and E2 we take one of entities (say E1) preferably with total participatio

Explain trivial dependency? Functional dependency of the form α ->β. is trivial if α C β. Trivial functional dependencies are satisfied by all the relations.