Question

Part C: Describe the constraints of the domain. (3 points) MAX PTS AND BRAINLIEST

Answer 1

Answer:

Domain constraints include entity integrity and referential integrity and this domain is a set of values that may be assigned to an attribute. The entity integrity rule states that no part of a primary key cannot be null. Referential integrity states that each foreign key value must match a primary key value or be null

Each table has certain set of columns and each column allows a same type of data, based on its data type. The column does not accept values of any other data type.

Step-by-step explanation:

Domain constraints include entity integrity and referential integrity and this domain is a set of values that may be assigned to an attribute.

The ENTITY INTEGRITY rule states that no part of a primary key cannot be null while the REFERENTIAL INTEGRITY rule states that each foreign key value must match a primary key value or be null.

Each table has certain set of columns and each column allows a same type of data, based on its data type in which the column does not accept values of any other data type.

Therefore Domain constraints are user defined data type and can define in this way:

Domain Constraint = data type + Constraints (NOT NULL / UNIQUE / PRIMARY KEY / FOREIGN KEY / CHECK / DEFAULT)