Question: Modify the create table to write CHECK constraint on cust _ bal and cust _ state in CA or CO CREATE TABLE Customer ( CustNo

Modify the create table to write CHECK constraint on cust_bal and cust_state in CA or CO
CREATETABLECustomer
( CustNoCHAR(8),
CustFirstName VARCHAR2(20)CONSTRAINTCustFirstNameRequiredNOTNULL,
CustLastName VARCHAR2(30)CONSTRAINTCustLastNameRequiredNOTNULL,
CustStreet VARCHAR2(50),
CustCity VARCHAR2(30),
CustStateCHAR(2)CONSTRAINTCustomer_CustState,
CustZipCHAR(10),
CustBalDECIMAL(12,2)DEFAULT0,
CONSTRAINTPKCustomerPRIMARYKEY (CustNo),

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!