Question: modify the create table statement table to add check constraint for cust _ bal and cust _ state CREATE TABLE Customer ( CustNo CHAR (

modify the create table statement table to add check constraint for cust_bal and cust_state
CREATETABLECustomer
( CustNoCHAR(8),
CustFirstName VARCHAR2(20)CONSTRAINTCustFirstNameRequiredNOTNULL,
CustLastName VARCHAR2(30)CONSTRAINTCustLastNameRequiredNOTNULL,
CustStreet VARCHAR2(50),
CustCity VARCHAR2(30),
CustStateCHAR(2)CONSTRAINTCustomer_CustStateCHECK(CustStateIN('CO','CA','WA','AZ','UT','NV','ID','OR')),
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!