Notes

create table department(
dept_id number primary key,
dept_name varchar(20),
dept_bloc_no number
);

insert into department values(1 ,'CSIT', 111);
insert into department values(2 ,'BCA', 222);
insert into department values(3 ,'BIM', 333);
insert into department values(4 ,'BIT', 444);
insert into department values(5 ,'BBA', 555);

select * from department;


create table staff(
staff_id number primary key,
staff_name varchar2(20),
dept_id number,
foreign key(dept_id) references department (dept_id)
);

insert into staff values(101 ,'ram', 1);
insert into staff values(102 ,'shyam', 2);
insert into staff values(103 ,'sita', 3);
insert into staff values(104 ,'suman', 4);
insert into staff values(105 ,'kiran', 5);


select * from department natural join staff;

select * from department cross join staff;


--lab - 3

create table Memployee ( eid number primary key, ename varchar(20), salary number);

insert into Memployee values ( 11, 'suman', 65000);
insert into Memployee values (22, 'rajan', 45000);

create table Demployee ( eid number primary key, ename varchar(20), salary number);

insert into Demployee values ( 33, 'auman', 75000);
insert into Demployee values (44, 'rhajan', 55000);


select * from Demployee
union
Select * from Memployee;