In relational database, the data type of values in each column of a table is called

Correct option is B

In a relational database, the data type of values in each column of a table is called the domain. The domain defines the set of possible values that can be stored in a particular column. It specifies constraints on the values, such as their data type (e.g., integer, string, date), the range of values, and other restrictions such as whether the value can be null.
Important Key Points:
1. Domain: The domain is the set of valid values that an attribute (column) can hold. It defines the type of data (like integer, string, or date) and the possible values that can be entered for each attribute in a table.
2. Data Type Restrictions: The domain ensures that only valid data can be inserted into a column, preventing data inconsistency and maintaining data integrity.
3. Enforces Integrity: By setting a domain for each column, databases ensure that data inserted into a column follows the predefined rules, such as numeric values for age or date values for birth dates.
Knowledge Booster:
· Attribute: An attribute is a column in a table that represents a specific data element of an entity. While the domain defines the allowed values for the attribute, the attribute itself is the name of the column.
· Relation: A relation is another term for a table in a relational database. It represents a collection of tuples (rows), where each tuple corresponds to a set of values for the attributes (columns) defined in the relation.