Birla Institute of Technology (BIT Mesra) 2012 B.E Computer science information technology (CSIT) CS4105 Database Management system - Question Paper

Time-1.5 hours Full marks-25


.Define a DBMS.What are the main functions of database manager?

Q2.Distinguish ranging from the following:
(i)disjoint and overlapping design constraints.
(ii)strong and weak entity sets.

Q3.Define the subsequent the terms with examples
(i)super key (ii)primary key (iii)candidate key (iv)participation (v)identifying relationship

Q4. Briefly discuss the concept of generalization and,specialization and aggregation with diagrams
consider the subsequent database suppliers(sid,sname,address)
parts(pid,pname,colour)
catalog(sid,pid,cost)

Q5.Write the subsequent queries in relational algebra-
(a) obtain the sid's of suppliers who have a few red and a few green part
(b) obtain the sid's of suppliers who supply every part
(c) obtain the pids of the most expensive part supplied by Mr.X


Q6. For the provided database,write the subsequent queries in SQL

(a)For every part,find sname of the supplier who charges the most for that part.
(b) obtain the sid's of suppliers who supply a red and a green part.
(c)Find the sid's of supplier who charges more for a few part than the avg. cost of that part(averaged over all the suppliers who supply that part).

Earning:   Approval pending.