Jaypee Institute of Information Technology %28JIIT%29 2007 B.E Computer Science DATABASE MANAGEMENT SYSTEM TEST 1 - Question Paper

JAYPEE UNIVERSITY OF info TECHNOLOGY
WAKNAGHAT
TEST1 third SEMESTER
COURSE CODE: 07B31CI104
COURSE NAME:DATABASE MANAGEMENT SYSTEM
COURSE CREDIT:4
MAX. MARKS: 20
TIME: one Hr

1) Bring out five differences ranging from File Management and DBMS. (3)

2) describe Atomicity with example. (2)

3) 30000 records is to be stored in a file. The length of every record is 100 bytes and the block size is 1024 bytes. compute the avg. number of block accesses needed to find a record of this file assuming it to be unspanned for:-
a) Sequential access
b) Binary Search

4) Write any two kinds of indexing in detail with1 e.g. of every. (2)

5) three relations are provided to you write the SQL query/ command for every of the folowing:-
emp(eid: integer,ename: string,age: integer,salary : real)
works(eid: integer, did: integer, pcttime: integer)
Dept(did: integer, dname: string, budget: real, managerid: integer) (10)

(a) Create structure for all above reactions.
(b) Make eid of Emp relation a primary key using alter command.
(c) Impose check constraint on salary that salary entered by user at run tim must be btw 15000 and 150000.
(d) How will you see the constraint names?
(e) Retrieve third max. salary from Emp realtion.
(f) Make a view of two attributes eid of Works and did of Dept relation.
(g) provide choose and insert privilege to u234. presume your login is u432.
(h) Make eid of Work relation a foreign key. presume eid of Emp is primary key.
(i) Display the nuber of employees in every department.
(j) Copy managerid of Dept to new relation say JUITManager.

Earning:   Approval pending.