What would you like to do?

What is domain constraints in DBMS?

already exists.

Would you like to merge this question into it?

already exists as an alternate of this question.

Would you like to make it the primary and merge this question into it?

exists and is an alternate of .

each column contains same type of data thus when you select a data type for a particular domain then DBMS will not accept any value of other data type.

Further information contributed by Ramona Maxwell. Please visit www.sqlsolver.com:

Domain constraints are a user-defined data type which enforces the integrity of the standard data types. A domain consists of all values permitted in a column. In constructing your database you would first select a standard data type such as VARCHAR or INT. You could then constrain or limit the data using NOT NULL, UNIQUE, CHECK, PRIMARY KEY or FOREIGN KEY. For example the CHECK constraint could limit INT data within your domain [column] to numbers less than 5000. You would thus define a custom data type using domain constraints.
17 people found this useful
Thanks for the feedback!

What is a constraint?

Constraint, in Project Management terms, means a factor that affects when an activity can be scheduled. ---------------------------------------------------------------------

What is the dbm?

dBm is decibel power unit referenced to 1 milliwatt. Look at the related links for conversion: voltage to dBm, dBu, and dBV.

What is a DBMS?

DataBase Management System (DBMS) is a software package that allows data to be effectively stored, retrieved and manipulated and the data stored in a DBMS packege can be ac

What is a dBm?

it is the power ratio in decibels No, it isn't. dB on its own is a ratio. But when dB has a suffix, the figure is an absolute measurement, not a ratio. For instance, dBm is a

Consistency constraints in dbms?

it describes the instance of one entity is associated with each instances of an entity depending upon the range of cardinality constraints are two types they are minimum cardi

What are domains?

A web domain is a means of identifying or addressing a particular device on a network. More importantly, a domain name can be used as a means of identifying a brand or o

Define domain with respect to dbms?

  In database technology, domain refers to the description of an attribute's allowed values. The physical description is a set of values the attribute can have, and the se

Integrity constraints in dbms?

The term integrity means to correctness and completeness of the data in data base. A relational data base is collection of related table. Table contains various information.

What is meant by constraints in DBMS?

Constraints within a database are rules which control values allowed in columns and also enforce the integrity between columns and tables. An example of a column constraint

What is DBMS and what r the features of Dbms?

DBMS stands for data base management system. DBMS is a collection  of programs that enables users to create and maintain a database.  The DBMS is a general purpose software
In Uncategorized

What does an DBMS do?

DBMS is database management system and it stores data that are related. DBMS maintains data security and integrity as well.