Data domain

domaindomain constraintsdomains
In data management and database analysis, a Data Domain refers to all the values which a data element may contain.wikipedia
41 Related Articles

Null (SQL)

NULL NULLs
This gender column might be declared as a string data type, and allowed to have one of two known code values: "M" for male, "F" for female, and NULL for records where gender is unknown or not applicable.
Since Null is not a member of any data domain, it is not considered a "value", but rather a marker (or placeholder) indicating the undefined value.

Reference table

In a normalized data model, the reference domain is typically specified in a reference table.
It is also called a domain table because it represents the domain for the columns that reference it.

Data management

managementData maintenancedata-management
In data management and database analysis, a Data Domain refers to all the values which a data element may contain.

Database

database management systemdatabasesDBMS
In data management and database analysis, a Data Domain refers to all the values which a data element may contain. For example, a database table that has information about people, with one record per person, might have a "gender" column.

Data element

elementelementsAtomic" data
In data management and database analysis, a Data Domain refers to all the values which a data element may contain.

Data type

typedatatypetypes
This gender column might be declared as a string data type, and allowed to have one of two known code values: "M" for male, "F" for female, and NULL for records where gender is unknown or not applicable. The rule for determining the domain boundary may be as simple as a data type with an enumerated list of values.

Enumeration

enumeratedenumerativelist
The rule for determining the domain boundary may be as simple as a data type with an enumerated list of values.

Table (database)

tabletablesdatabase table
For example, a database table that has information about people, with one record per person, might have a "gender" column.

Gender

gender issuessexgenders
For example, a database table that has information about people, with one record per person, might have a "gender" column.

Identifier

IDidentifiersidentification number
This gender column might be declared as a string data type, and allowed to have one of two known code values: "M" for male, "F" for female, and NULL for records where gender is unknown or not applicable.

Database normalization

normalizationnormalizednormal form
In a normalized data model, the reference domain is typically specified in a reference table.

Data model

structured datastructuredData models
In a normalized data model, the reference domain is typically specified in a reference table.

Master data management

master dataMaster data storereference domain
In a normalized data model, the reference domain is typically specified in a reference table.

Foreign key

Foreignforeign key constraintforeign key references
Reference tables are formally related to other tables in a database by the use of foreign keys.

Check constraint

constraints constraintconstraints
Less simple domain boundary rules, if database-enforced, may be implemented through a check constraint or, in more complex cases, in a database trigger.

Database trigger

triggerstriggerprocedural triggers
Less simple domain boundary rules, if database-enforced, may be implemented through a check constraint or, in more complex cases, in a database trigger.

Set (mathematics)

setsetsmathematical set
This definition combines the concepts of domain as an area over which control is exercised and the mathematical idea of a set of values of an independent variable for which a function is defined.

Dependent and independent variables

dependent variableindependent variableexplanatory variable
This definition combines the concepts of domain as an area over which control is exercised and the mathematical idea of a set of values of an independent variable for which a function is defined.

Function (mathematics)

functionfunctionsmathematical function
This definition combines the concepts of domain as an area over which control is exercised and the mathematical idea of a set of values of an independent variable for which a function is defined.

Relational database

relational database management systemRDBMSrelational databases

First normal form

1NF
A relation is in first normal form if and only if the domain of each attribute contains only atomic (indivisible) values, and the value of each attribute contains only a single value from that domain.