Assignment – 1
Subject – Database Management System
TABLE: EMPLOYEE
EMPNO NAME JOB MGR HIERDATE SAL DEPTNO
1
2
3
4
5
6
7
8
9
10
Answer – (A) SELECT * FROM EMPLOYEE WHERE DEPTNO=20;
Answer – (B) SELECT * FROM EMPLOYEE WHERE JOB='CLERK' OR
SAL BETWEEN 1000 AND 2000;
Answer – (C) SELECT NAME FROM EMPLOYEE ORDER BY SAL;
Answer – (D)
Answer – (E) SELECT COUNT(NAME) FROM EMPLOYEE WHERE
SAL<3000;
Answer – (F) INSERT INTO EMPLOYEE VALUES (11, 'MILLER',
'MANAGER', 7698, TO DATE ('25/02/98', 'DD/MM/YY'), 4300, 20);
Answer – (G) OUTPUTS:
(A) COUNT (*)
11
(B) MIN(SAL)
1250
(C) SUM(SAL)
14650
(D) AVG(SAL)
2472.7272
Assignment – 2
TABLE: CLIENT_MASTER
CLIENT_N NAM ADD ADD CIT STAT PINCOD BAL_DU
O E 1 2 Y E E E
TABLE: PRODUCT_MASTER
PRODUCT_NO DESCRIPTION PROFIT_PERCENT UNIT_MEASURE QTY_ON_ REORDER_ SELL_PRICE COST_PRICE
HAND LVL
Answer – (1) SELECT NAME FROM CLIENT_MASTER;
Answer – (2) SELECT NAME, CITY FROM CLIENT_MASTER;
Answer – (3) SELECT * FROM PRODUCT_MASTER;
Answer – (4) SELECT NAME FROM CLINT_MASTER WHERE
CITY=’MUMBAI’;
Answer – (5) SELECT * FROM CLINT_MASTER WHERE CLINT_NO=001
OR CLIENT_NO=002;
Answer – (6) SELECT * FROM PRODUCT_MASTER WHERE DESCRIPTION IN
(‘1.44 DRIVE’, ‘1.22DRIVE’);
Answer – (7) SELECT * FROM PRODUCT_MASTER WHERE
SELL_PRICE>5000;
Answer – (8) SELECT * FROM CLIENT_MASTER WHERE CITY IN
(‘MUMBAI’, ‘DELHI’, ‘MADRAS’);
Answer – (9) SELECT * FROM PRODUCT_MASTER WHERE
SELL_PRICE>2000 OR SELL-PRICE<=5000;
Answer – (10) SELECT NAME, CITY, STATE FROM CLIENT_MASTER
WHERE STATE NOT IN (‘MAHARASTRA’);
Answer – (11)
Answer – (12)
Answer – (13)
Answer – (14)
Answer – (15)
Answer – (16) SELECT * FROM CLIENT_MASTER WHERE CITY LIKE
‘_A%’;
Answer – (17) SELECT NAME FROM CLIENT_MASTER WHERE NAME
LIKE ‘_A%’;
Answer – (18) SELECT * FROM PRODUCT_MASTER ORDER BY
DESCRIPTION;
Answer – (19)
Answer – (20)
Answer – (21)
Answer – (22)
Answer – (23) SELECT COUNT(*) FROM PRODUCT_MASTER HAVING
SELL_PRICE>=1500;
Assignment – 3
TABLE: EMPLOYEE
EMP_ID EMP_NAME EMP_STREET EMP_CITY
TABLE: WORKS
EMP_ID COMPANY_ID SALARY
TABLE: LOCATED_IN
COMP_I
COMP_NAME COMP_CITY
D
Answer – (A) SELECT EMPLOYEE.EMP_NAME FROM EMPLOYEE JOIN
LOCATED_IN WHERE LOCATED_IN.COMP_NAME=’SANOMED’;
Answer – (B)
Answer – (C)
Answer – (D)
Answer – (E)
Assignment – 4
TABLE: SAILERS
RATIN
SID SNAME AGE
G
TABLE: BOATS
BID BNAME BCOLOR
TABLE: RESERVE
SI
BID DAY
D
Answer – (A)
Answer – (B)
Answer – (C)
Answer – (D)
Answer – (E)
Answer – (F)
Assignment – 5
TABLE: STUDENT
SID SNAME SEX AGE YEAR GPA
TABLE: DEPT
DNAM NUMPHD
E S
TABLE: PROF
PNAME DNAME
TABLE: COURSE
DNAME CNO CNAME
TABLE: MAJOR
DNAME SID
TABLE: SECTION
DNAME CNO SECTNO PNAME
TABLE: ENROLL
SID DNAME CNO SECTNO GRADE
Answer – (1)
Answer – (2)
Answer – (3)
Answer – (4)
Answer – (5)
Answer – (6)
Answer – (7)
Answer – (8)
Answer – (9)
Answer – (10)
Answer – (11)
Answer – (12)
