drop database if exists pers
\g
create database pers
\g
use pers 
\g
create table emps(emp_id   int NOT NULL,
		  emp_name varchar(30), 
		  dept_id  int,
		  dept_name varchar(30),
		  salary   decimal(7,2),
		  primary key(emp_id)) 
\g 		   
insert into emps (emp_id,emp_name,dept_id,salary)
	    values (1,'Roger',1,2000.00),(2,'John',2,2500.00),(3,'Alan',1,2100.00)
\g
select * from emps
\g 
create table dept (dept_id    int NOT NULL,
		  description varchar(30),
		  primary key(dept_id))
\g 
insert into dept (dept_id,description)
	    values (1,'Information Technology'),(2,'Sales')
\g
select * from dept
\g