CREATE TABLE EMPLOYEE (
        EMP# NUMBER (6)
			CONSTRAINT EMP#_PK PRIMARY KEY,
	EMP_FNAME VARCHAR2(14)
		CONSTRAINT EMP_FNAME_NN NOT NULL,
	EMP_LNAME VARCHAR2(14)
		CONSTRAINT EMP_LNAME_NN NOT NULL,
	EMP_ADDR VARCHAR2(30)
		CONSTRAINT EMP_ADDR_NN NOT NULL,	
	EMP_CITY VARCHAR2(15) 
		CONSTRAINT EMP_CITY_NN NOT NULL
		DEFAULT 'Chico',
	EMP_STATE CHAR(2) 
		CONSTRAINT EMP_STATE_NN NOT NULL
		DEFAULT 'CA',
	EMP_ZIP	NUMBER(5) 
		CONSTRAINT EMP_ZIP_NN NOT NULL
		DEFAULT '95926',
	EMP_PHONE	CHAR(13) DEFAULT '(530)'
		CONSTRAINT EMP_PHONE_NN NOT NULL
		CONSTRAINT EMP_PHONE_CK
			CHECK ( EMP_PHONE LIKE '(___)___-____' ) ,
	HIRE_DATE DATE
		CONSTRAINT HIRE_DATE NOT NULL
		CONSTRAINT HIRE_DATE_CK
			CHECK ( HIRE_DATE >= '26-OCT-2002' ),
	JOB_TITLE	VARCHAR2(20)
		CONSTRAINT JOB_TITLE_NN NOT NULL
		DEFAULT 'Salesperson',
	SS# CHAR(11)
		CONSTRAINT SS#_NN NOT NULL
		CONSTRAINT SS#_UQ UNIQUE
		CONSTRAINT SS#_CK
			CHECK  ( SS# LIKE '___-__-___' ) ,
	MAR_STATUS	CHAR(1)
		CONSTRAINT MAR_STATUS_NN NOT NULL
		CONSTRAINT MAR_STATUS_CK
			CHECK ( MAR_STATUS IN ('S', 'M', 'D', 'W', 'H') ) ,
	PAY_RATE NUMBER(5,2)
		CONSTRAINT PAY_RATE_NN NOT NULL
		CONSTRAINT PAY_RATE_CK
			CHECK ( PAY_RATE BETWEEN 7.25 AND 80.00) ,
	COMM_PER NUMBER(4)
		CONSTRAINT COMM_PER_NN NOT NULL
		CONSTRAINT COMM_PER_CK
			CHECK ( COMM_PER = 0 OR BETWEEN (6 AND 15) )
			) ;