DBMS 18 Slips
Q.18) Employee_Project
create table emp1
(
eno number(10) primary key,
ename varchar2(20),
dname varchar2(20),
sal number(10)check(sal>0)
);
create table pr1
(
pno number(10) primary key,
pname varchar2(20),
budget number(10)
);
create table e_p
(
eno number(10) references emp1(eno),
pno number(10) references pr1(pno)
);
insert into emp1 values(31,'sujit','hr',55000);
insert into emp1 values(32,'kavita','computer',58000);
insert into emp1 values(33,'sushma','account',61000);
insert into emp1 values(34,'riya','marketing',55000);
insert into emp1 values(35,'kunal','finance',50000);
insert into pr1 values(1,'onlineshopping',40000);
insert into pr1 values(2,'monitor',35000);
insert into pr1 values(3,'computer',20000);
insert into pr1 values(4,'stockmarket',38000);
insert into pr1 values(5,'pen',45000);
insert into e_p values(31,1);
insert into e_p values(32,2);
insert into e_p values(33,3);
insert into e_p values(34,4);
insert into e_p values(35,5);
1.select ename,dname from emp1 where sal>50000;
ENAME DNAME
-------------------- ------------
sujit hr
kavita computer
sushma account
riya marketing
2.select emp1.ename from emp1,pr1,e_p
where emp1.eno=e_p.eno and
pr1.pno=e_p.pno and
emp1.ename='riya';
ENAME
-------------
riya
3.select ename,pname from emp1,pr1,e_p
where emp1.eno=e_p.eno and
pr1.pno= e_p.pno and
pr1.budget>30000;
ENAME PNAME
-------------------- ----------------
sujit onlineshopping
kavita monitor
riya stockmarket
kunal pen
4.select emp1.dname from emp1,pr1,e_p
where emp1.eno=e_p.eno and
pr1.pno=e_p.pno and
pr1.pno>=2;
DNAME
---------------
computer
account
marketing
finance
5.update pr1 set budget=budget+0.15
where emp1.dname='computer';
Tags:
Dbms