create table department(deptno number(5)PRIMARY KEY,deptname varchar2(10));
create table employee(empno number(5) primary key,ename varchar2(10),sal number(5), deptno number(5), CONSTRAINT fkey_cnst FOREIGN KEY (deptno) references department(deptno));