CREATE TABLE employee
(empid NUMBER(3) NOT NULL,
lastname VARCHAR2(10) NOT NULL,
firstname VARCHAR2(15) NOT NULL,
title CHAR(9),
salary NUMBER(9,2),

PK
CONSTRAINT employee_pk PRIMARY KEY (empid),
CONSTRAINT emp_sal_min CHECK (salary >=5000));

--------------------------------
FK
CONSTRAINT order_custid_fk FOREIGN KEY (customer_id) REFERENCES customer (customer_id)