create table emp
(emp_id int constraint pk_emp_id_main primary key,
emp_name nvarchar(50) not null,
emp_sex nvarchar(20),
emp_age int check(emp_age>=0 and emp_age <=120),
emp_salary float check(emp_salary>=1000 and emp_salary <=10000),
dep_id int constraint fk_dep_id_middle foreign key references dep(dep_id))
insert into emp values (1,'max','male',27,8000,1)