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
what are the states of transaction?

Explain the term- Query. Queries are used to repossess and show specific records in a table. They can also be used to show specific fields of specific records, which meet the co

What is called an evaluation primitive? A relational algebra operation annotated with instructions on how to evaluate is known as an evaluation primitive.

How does a query tree represent a relational algebra expression?  Discuss any three rules for query optimisation, giving example as to when should each rule be applied.     Ans

Oracle & Distributed Databases 1. Differentiate between PL/SQL functions and procedures. 2. Draw the diagram of logical structure of oracle database and explain it in brief.

Software failures :  In such cases, a software error abruptly stops the implementation of the current transaction (or all transactions), therefore leading to losing the state of pr

Defining Internal Classes and Operations When we enlarge algorithms, new classes can be added to the store intermediate results. A complex operation could be looked at, as a c

What subschema expresses ? A subschema expresses the external view. (External schemas are called also called as subschemas)

While sorting field groups we cannot use more than one key field False.

List the types of authorization. A) Read authorization B) Write authorization C) Update authorization D) Drop authorization