CLOUD COMPUTING

Detailed explanation-1: -Integrity constraints in DBMS are used to ensure that data is consistent and accurate. There are four main types of integrity constraints: domain, entity, referential, and key.

Detailed explanation-2: -Data integrity rules specify the criteria that need to be met to insure that the data resource contains the highest quality necessary to support the current and future business information demand.

Detailed explanation-3: -Data integrity is normally enforced in a database system by a series of integrity constraints or rules. Three types of integrity constraints are an inherent part of the relational data model: entity integrity, referential integrity and domain integrity.

Detailed explanation-4: -Syntax to define a Primary key at table level: [CONSTRAINT constraint name] PRIMARY KEY (column name1, column name2, ..) column name1, column name2 are the names of the columns which define the primary Key. The syntax within the bracket i.e. [CONSTRAINT constraint name] is optional.

Detailed explanation-5: -Domain constraint. Entity integrity constraint. Referential integrity constraint. Key constraint. 19-Jan-2023