define the following constraints for the table


Define the following constraints for the table client.

(i) BAL_DUE must be at least 1000.
(ii) NAME is a unique key.

(i)ALTER TABLE CLIENT
ADD CONSTRAINT CLIENT_BAL_DUE_C1 CHECK(BAL_DUE < 1000);
(ii) ALTER TABLE CLIENT
ADD CONSTRAINT CLIENT_NAME_U UNIQUE(NAME);

Request for Solution File

Ask an Expert for Answer!!
Database Management System: define the following constraints for the table
Reference No:- TGS0282597

Expected delivery within 24 Hours