-- create a students table
CREATE TABLE students (
  sid INTEGER PRIMARY KEY,
  name VARCHAR(30) NOT NULL,
  gender CHAR(1) NOT NULL,
  deptid INTEGER NOT null,
  salary INTEGER NOT null
);
-- create a department table
create table department(
deptid INTEGER PRIMARY key,
deptname VARCHAR(10) NOT null
);
-- insert some students values
INSERT INTO students VALUES (1, 'adnan', 'M',1,25000),(2, 'turjoy', 'F',2,26000),(3, 'shovon', 'F',2,27000),(4, 'shovon', 'F',1,45000),(5, 'rajib', 'M',1,5000),(6, 'rinku', 'M',3,15000),(7, 'alif', 'F',3,6000);
-- insert some students values
insert into department values(1,"CSE"),(2,"EEE"),(3,"CIVIL");

select * from department;