Rajiv Gandhi Proudyogiki Vishwavidyalaya 2007-5th Sem B.E Computer Science .(ester) ,.-. - Question Paper

CS/IT - 503
B.E.(Fifth Semester) EXAMINATION,Nov.-Dec.2007
(Common for CS & IT Engg.)
DATABASE MANAGEMENT SYSTEM

Note : Attempt any 5 ques..All ques. carry equal marks.

1.(a) explain main categories of data models.
(b) discuss the subsequent terms :
(i) database schema
(ii) data independence
(c) discuss the difference ranging from the two-tier and three-tier client/server architecture.
2.(a) Construct an E-R diagram for a hospital with set of patients and set of Medical doctors.
Associate with every patient a log of different tests and exams conducted.
(b) What is subclass ? When is subclass needed in data modeling ? discuss is-a-relationship.
3.(a) Differentiate ranging from the subsequent :
(i) Super key and Primary key
(ii) Strong entity and weak entity
(iii) Generalization and specialization
(iv) User described and attribute described specialization
(b) explain entity integrity and referential integrity constraints. Why every is considered
important ?
4.(a) What is Union compatibility ? Why dothe Union,Intersection and Set-difference operations
require that the relations on which they are applied are union compatible ?
(b) discuss with respect to tuple calculus :
(i) tuple variable
(ii) range relation
(iii) atom formula
(iv) expression
(v) ?(Existential quantifier) and Univerasl quantifier.
5. Consier the subsequent database with primary keys underlined :
Employee(ENO,DOB,,ADDRESS,SEX,SALARY,NAME,DNO SUPER END).
Department(DNO, D Name, MGRENO,MGR begin date)
Dept-location(DNO,Dlocation)
Project(PNAME,PNO,Plocation,DNO)
Works-ON(ENO,PNO, hours)
Dependent(ENO,dep-name,Sex,bdate,relationship)
For every of the subsequent queries provide expressions in SQL and relational algebra :
(a) Retrive the names of all employees in department
(b) List the names of all employees who have no dependents
(c) Retrieve the names of all employees who do not work on any project.
(d) Retrieve the avg. salary of all female employees.
(e) obtain names of all employees who work on at lowest 1 projcet located in Hyderabad.
(f) Write SQL,DLL statements for the above database.
6.(a) Consider the relation R(A,B,C,D,E,F,G,H,I,J) and set of functional dependencies:
F={{A,B}->{C},{A}->{D,E},{B}->{F},{F}->{G,H},{D}->{I,J}}
What is the key of R, Decompose R in 2NF and three NF ?
(b) discuss the subsequent :
(i) Trivial dependency
(ii) Lossless decomposition
(iii) Dependency preservation
(iv) Functional dependency
(v) Multivalued dependency
7.(a) discuss data fragmentation,replication and allocation techniques for distributed database
design.
(b) discuss join,natural join,outer join, full outer join, left outer join and right outter join
with example.
8. Write short notes on any 4 of the subsequent :
(i) Oracle tools
(ii) Object oriented database design
(iii) Security constraint in DBMS
(iv) Role of DBA
(v) Database Management System Architecture.

Earning:   Approval pending.